%@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);
%>