📄 fatbbsresults.jsp
字号:
<%@ page import="java.sql.*" %>
<%
// instance variables for connection
ResultSet result;
Connection connection = null;
Statement statement = null;
String url = "jdbc:db2:board";
%>
<HTML>
<HEAD>
<TITLE>Message Board Posts</TITLE>
</HEAD>
<BODY BGCOLOR=#C0C0C0>
<H1>All Messages</H1>
<P>
<TABLE border="1">
<TR>
<TD>Subject</TD>
<TD>Author</TD>
<TD>Board</TD>
</TR>
<%
try {
// Establish a connection
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
// connect with default id/password
connection = DriverManager.getConnection(url);
// set and execute SQL statement
// retrieve data from the database
statement = connection.createStatement();
result = statement.executeQuery("SELECT subject, author, board from posts");
// print the results
while (result.next()) {
out.println("<TR> <TD>" + result.getString(1) + "</TD>");
out.println("<TD>" + result.getString(2) + "</TD>");
out.println("<TD>" + result.getString(1) + "</TD></TR>");
}
result.close();
statement.close();
} catch (Throwable theException) {
out.println("Connection or output print failed.");
}
%>
</TABLE>
<P>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -