[200615.76일차] Spring 6 - jdbc

DB 연동

DTO

DAO

JdbcService Interface

JdbcContentServiceImpl

MemberController

content.jsp

 

---

데이터 삽입

MemberController

JdbcSaveServiceImpl

=> model을 map에 저장해서 사용해도 되지만,

HttpServletRequest request로 직접 받아서 사용해도 무관하다.

DAO

 

---

특정 회원 정보 가져오기

 

 

---

삭제

 

 

---

jdbc 오라클 xml설정 ( DB 접근 템플릿 )

<!-- JDBC Template -->
 <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>4.1.4.RELEASE</version>
 </dependency>

=> pom.xml 119번째 줄에 추가

---

<bean name="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
   <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
   <property name="url" value="jdbc:oracle:thin:@192.168.164.128:1521:xe" />
   <property name="username" value="jsp" />
   <property name="password" value="1234" />
</bean>
<bean name="template" class="org.springframework.jdbc.core.JdbcTemplate">
   <property name="dataSource" ref="dataSource" />
</bean>

=> xml 파일을 생성해서 붙여넣음

---