DBCP(커넥션풀)을 이용한 데이터베이스 연결방법

:: Tomcat 설정 파일 context.xml 에 추가


:: 사용 예시

public class ContentDao {

	private DataSource dataSource;

	public ContentDao() {
		try {
			Context context = new InitialContext();
			dataSource = (DataSource)context.lookup("java:comp/env/jdbc/Oracle11g");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public ArrayList<ContentDto> list() {
		ArrayList<ContentDto> ContentDtos = new ArrayList<ContentDto>();
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
			conn = dataSource.getConnection();
			String query = "SELECT * FROM TEST_BOARD";
			pstmt = conn.prepareStatement(query);
			rs = pstmt.executeQuery();
			while (rs.next()) {
				// ...
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (rs != null) rs.close();
				if (pstmt != null) pstmt.close();
				if (conn != null) conn.close();
			} catch (Exception e2) {
				e2.printStackTrace();
			}
		}
		return ContentDtos;
	}	
}