📄 pooltest.jsp
字号:
<HTML>
<BODY>
<%@ page import="java.util.*, java.sql.*"
contentType="text/html;charset=GB2312" %>
<jsp:useBean id="pool" scope="application" class="chapter10.ConnPool"/>
<%@ include file="conn.jsp"%>
<% sql="select * from Users";
ResultSet rs =statement.executeQuery(sql);
out.println("<TABLE CELLSPACING=10>" + "<TR><TH>ID</TH>" +
"<TH>Name</TH><TH>Email</TH><TH>IsDisable</TH>");
while (rs.next()){
out.println("<TR>\n<TD>" + rs.getInt("id") + "</TD>");
out.println("<TD>" + rs.getString("Name") + "</TD>");
out.println("<TD>" + rs.getString("Email") + "</TD>");
out.println("<TD STYLE=\"text-align:center;\">" +
rs.getBoolean("Disable")+"</TD></TR><BR>");
}
out.println("</TABLE>");
%>
<%@ include file="disconn.jsp"%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -