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

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

<Resource
	auth="Container"
	driverClassName="oracle.jdbc.driver.OracleDriver"
	name="jdbc/Oracle11g"
	type="javax.sql.DataSource"
	url="jdbc:oracle:thin:@localhost:1521:xe"
	username="publicvoid"
	password="privatevoid"
	maxActive="50"
	maxWait="500"
/>

Markup

Copy

:: 사용 예시

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;
	}
}

Java

Copy