JDBC

pom.xml 메이븐 추가

<!-- 스프링에서 JDBC 를 사용하기 위한 라이브러리 입니다. -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${org.springframework-version}</version>
</dependency>

<!-- 컨넥션 풀을 위한 라이브러리 -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>

<!-- 오라클 JDBC 드라이버 -->
<dependency>
     <groupId>com.oracle.database.jdbc</groupId>
     <artifactId>ojdbc6</artifactId>
     <version>11.2.0.4</version>
</dependency>

<!-- lombok -->
<dependency>
     <groupId>org.projectlombok</groupId>
     <artifactId>lombok</artifactId>
     <version>1.18.10</version>
     <scope>provided</scope>
</dependency>

 

server.xml

  <GlobalNamingResources> 에 추가

<Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" maxActive="50" maxWait="1000" name="jdbc/Oracle"  username="scott" password="tiger" type="javax.sql.DataSource" url="jdbc:oracle:thin:@localhost:1521:xe"/>

 

<Context> 에 추가

<ResourceLink global="jdbc/Oracle" name="jdbc/Oracle" type="javax.sql.DataSource"/>

 

DAO

public NoteDao() {
try {
Context context = new InitialContext();
ds = (DataSource)context.lookup("java:comp/env/jdbc/Oracle"); // 거의 고정
}catch(Exception e) {
e.printStackTrace();
}
}