netbeans에서 Services탭의 Database선택

마우스 오른쪽 버튼으로 New Databae Connection선택

derby 드라이버를 추가하기 위해 Name은 New Driver선택후 derbyclient.jar를 추가하여 준다.

Port는 1527, Database는 test , user는 APP, password는 APP

connect해서

데이타도 확인해보고

http://docs.sun.com/app/docs/doc/820-4496/beamj?l=ko&a=view를 참조하여

testDBCP.jsp생성

<%@ page contentType="text/html;charset=euc-kr" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>
<%
try{
//DBCP init
InitialContext ic = new InitialContext();
String dsName = "jdbc/derbypool";
DataSource ds = (javax.sql.DataSource)ic.lookup(dsName);
Connection connection = ds.getConnection();

Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();

String sql="SELECT id,text FROM test";

ResultSet rs = stmt.executeQuery(sql);

if (rs.next()){
  out.println(rs.getString("id"));
  out.println(rs.getString("text"));
}

stmt.close();
conn.close();

} catch(Exception e) {
out.println("error : " + e);
}

%>