Spring 2.5 가장 기본적인 DBCP 사용법

Spring 2.5에서 BasicDataSource를 사용하여 DBCP를 사용하는 예

기본 라이브러리 외에 추가해야 할 파일
spring-dbcp.jar,  spring-pool.jar, ojdbc14.jar

WEB-INF/web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  <display-name>SpringDemo</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
 
  <filter>
   <filter-name>encodingFilter</filter-name>
   <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
   <init-param>
    <param-name>encoding</param-name>
    <param-value>EUC-KR</param-value>
   </init-param>
  </filter>
  <filter-mapping>
   <filter-name>encodingFilter</filter-name>
   <url-pattern>/*</url-pattern>
  </filter-mapping>
 
  <servlet>
    <description></description>
    <display-name>dispatcher</display-name>
    <servlet-name>dispatcher</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>dispatcher</servlet-name>
    <url-pattern>*.htm</url-pattern>
  </servlet-mapping>
 
</web-app>

사용된 모든 라이브러리

cglib-nodep-2.1_3.jar

commons-logging.jar

spring-web.jar

spring-webmvc.jar

spring.jar

commons-dbcp.jar

commons-logging.jar

commons-pool.jar

ojdbc14.jar

src/config/jdbc.properties (src/아래에 config패키지를 생성하고 그 안에 작성)

jdbc.driver=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:XE
jdbc.username=scott
jdbc.password=tiger

위와 같이 작성된 properties 파일은 PropertyPlaceholderConfigurer클래스를 사용하여 로드할 수 있다.


WEB-INF/dispatcher-servlet.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
 
 <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
  <property name="location">
   <value>classpath:config/jdbc.properties</value>
  </property>
 </bean>
 
 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
   <property name="driverClassName" value="${jdbc.driver}"/>
   <property name="url" value="${jdbc.url}"/>
   <property name="username" value="${jdbc.username}"/>
   <property name="password" value="${jdbc.password}"/>
  </bean>
  
 <bean id="beanNameUrlMapping"
  class="org.springframework.web.servlet.handler.BeanNameUrlHandlerMapping"/>

 <bean name="/hello.htm"
  class="spring.test.controller.HelloController">
  <property name="dataSource" ref="dataSource"/>
 </bean>
  
 <bean id="viewResolver"
  class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  <property name="prefix" value="/hello/"/>
  <property name="suffix" value=".jsp"/>
 </bean>
</beans>

HelloController.java

package spring.test.controller;

import java.sql.*;
import java.util.ArrayList;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.dbcp.BasicDataSource;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.AbstractController;

public class HelloController extends AbstractController {

 private BasicDataSource dataSource;

 public void setDataSource(BasicDataSource dataSource) {
  this.dataSource = dataSource;
 }

 @Override
 protected ModelAndView handleRequestInternal(HttpServletRequest request,
   HttpServletResponse response) throws Exception {
  int empno = Integer.valueOf(request.getParameter("empno"));
  Connection conn = dataSource.getConnection();
  String sql = "select * from emp where empno=?";
  PreparedStatement pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, empno);
  ResultSet rs = pstmt.executeQuery();
  String ename = null;
  if(rs.next()){
   ename = rs.getString("ENAME");
  }
  ModelAndView mav = new ModelAndView();
  mav.setViewName("empView");
  mav.addObject("empno", empno);
  mav.addObject("ename", ename);
  return mav;
 }
}

Web-Content/hello/empView.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>사원정보 보기</title>
</head>
<body><br/><br/><center>
${empno}으로 검색된 사원정보<p/>
${ename}
</center>
</body>
</html>