PROGRAMMING

java dbcp

🩷 슈 🧡 2010. 6. 29. 19:28
728x90
SMALL

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ page import="java.sql.*"
         import="javax.sql.*"
         import="javax.naming.*"
%>   
<!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>JNDI를 이용한 Connection Pool Demo</title>
</head>
<body>
<%
  //변수 준비
  DataSource ds = null;
  Connection con = null;
  try{
   //네이밍 서비스에 접근
   Context ctx = new InitialContext();
   //Java 자원으로 접근
   Context envCtx = (Context)ctx.lookup("java:/comp/env");
   //우리가 설정한 자원을 검색
   ds = (DataSource)envCtx.lookup("jdbc/mysql");
   //커넥션풀 객체를 찾았으니 커넥션을 빌려오자!
   con = ds.getConnection();
   out.println("con = " + con + "<br/>");
  }catch(Exception e){
   e.printStackTrace();
   out.println(e.getMessage());
  }finally{
   if(con != null){
    //빌려온 커넥션은 반드시 돌려주자
    con.close();
    out.println(con + " closed");
   }
  
  }
%>
</body>
</html>





728x90
LIST