JSP DBConnection

1. WebContent > META-INF > context.xml 파일에 DB Connetion 정보 추가, 접속 DB 종류에 따라 컨넥션 정보는 다를 수 있음.

    <Resource removeAbandonedOnBorrow="true" removeAbandonedTimeout="10" logAbandoned="true"
        name="jdbc/mysql"
        auth="Container"
        type="javax.sql.DataSource"
        url="jdbc:mysql://127.0.0.1:4040/데이터베이스명"
        driverClassName="com.mysql.jdbc.Driver"        
        username="데이터베이스사용자명"
        password="비밀번호"
        loginTimeout="10"
        maxActive="100"
        maxIdle="30"
        maxWait="10000"
        testOnBorrow="true" />

2. 클래스 생성, DB Connection을 위한 클래스

import java.sql.Connection;
import java.sql.SQLException;

import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;

public class DBConnection {

    public static Connection getConnection() throws ClassNotFoundException, SQLException, NamingException {
        Context context = new InitialContext();
        DataSource ds = (DataSource) context.lookup("java:comp/env/jdbc/mysql");
        Connection dbConn = ds.getConnection();
        
        return dbConn;
    }
}

3. 클래스 사용, DB Connection Class 를 이용한 실제 쿼리문 작성

Connection conn = DBConnection.getConnection();

PreparedStatement pstm = null;
ResultSet rs = null;

StringBuffer query = new StringBuffer();

query.append("쿼리문");

pstm = conn.prepareStatement(query.toString());
rs = pstm.executeQuery();