[jsp] 커넥션풀 이용하기

이론적인 설명은 없습니다. 어차피 안읽을거 다알아요..

(1) 톰캣 서버 -> context.xml로 가서 설정해준다(Resource).

<Context>
 
    <!-- Default set of monitored resources. If one of these changes, the    -->
    <!-- web application will be reloaded.                                   -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
    <WatchedResource>${catalina.base}/conf/web.xml</WatchedResource>
 
    <!-- Uncomment this to disable session persistence across Tomcat restarts -->
    <!--t
    <Manager pathname="" />
    -->
    
    <Resource auth="Container" 
              name="jdbc/Portfolio" 
              driverClassName="com.mysql.jdbc.Driver" 
              type="javax.sql.DataSource" 
              url="jdbc:mysql://localhost:3306/jsp" 
              username="root" //<-보통이거
              password="비밀번호입력" 
              loginTimeout="10" 
              maxActive="50" 
              maxIdle="20"
              maxWait="5000" 
              testOnBorrow="true" />
</Context>    

(2) 아래와 같이 dao에서 이용해줍니다.

public void album3(BoardAlbumDTOIn ALdto ) throws SQLException
{
    Connection con = DBCP.getConnection();  //커넥션풀연결
    String sql = "insert into album3 set link=?, path=?,albumtype=?";
    PreparedStatement pstm = con.prepareStatement(sql);
    pstm.setInt(1, ALdto.getLink()); //물음표에 순서대로 값넣기
    pstm.setString(2, ALdto.getPicpath());
    pstm.setString(3, ALdto.getAlbumType());
    
    pstm.executeUpdate(); //insert, update문은 executeUpdate입니다.
    
    pstm.close();
    con.close();
    
        
}