<%@page contentType="text/html; charset=euc-kr"%>
<%@page import="java.sql.*"%>
Database Programming
Pooling 기법
<%
ConnectionPool pool = ConnectionPool.getConnectionPool();
Connection conn = pool.getConnection();
Statement stmt = conn.createStatement();
String sql = "select * from NovelJSP";
ResultSet rs = stmt.executeQuery(sql);
%>
| 이름 |
나이 |
<%
while(rs.next()) {
out.print("");
out.print("| " + rs.getString(1) + " | ");
out.print("" + rs.getInt(2) + " | ");
out.print("
");
}
%>
<%
pool.releaseConnection(conn);
%>