<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=Big5" %>
CH14 - Proxool-config.jsp
使用 Proxool Connection Pool
<%
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String new_last_name = "";
String new_first_name = "";
try
{
con = DriverManager.getConnection("proxool.JSPBook");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String query = "SELECT * FROM employee";
rs = stmt.executeQuery(query);
while(rs.next()) {
new_last_name = rs.getString("last_name");
new_first_name = rs.getString("first_name");
%>
從 employee 取出姓名：<%= new_last_name+new_first_name %>
<%
}
stmt.close();
con.close();
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
finally
{
try {
if(con != null)
{
con.close();
}
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
}
%>