displaywords.java
来自「JAVA数据库编程实例随书源码」· Java 代码 · 共 58 行
JAVA
58 行
import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.sql.*;import java.util.Vector;public class DisplayWords extends HttpServlet { protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { java.io.PrintWriter out=new java.io.PrintWriter(response.getOutputStream()); out.print("<html>"); // 输出响应的HTML 文件头部信息 out.print("<head><title>查看留言</title></head>"); out.print("<body>"); out.print("<h2>查看留言</h2>"); out.print("<hr>"); try{ // 创建数据库连接取得库中保存的留言信息 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection cn=DriverManager.getConnection("jdbc:odbc:words"); String str="SELECT * FROM words"; Statement st=cn.createStatement(); ResultSet rs=st.executeQuery(str); String name,date,email,topic,words; while(rs.next()){ name=rs.getString("name"); date=rs.getString("wdate"); email=rs.getString("email"); topic=rs.getString("topic"); words=rs.getString("words"); out.print("<table>"); out.print("<tr><td align=\"right\">"); out.print("<b>主题：</b></td><td colspan=\"3\"><b>"); out.print(topic); out.print("</b></td></tr>"); out.print("<tr><td align=\"right\">姓名：</td><td colspan=\"3\" >"); out.print(name); out.print("</td></tr>"); out.print("<tr><td align=\"right\">Email地址：</td><td colspan=\"3\" >"); out.print(email); out.print("</td></tr>"); out.print("<tr><td valign=\"top\" align=\"right\">留言：</td><td colspan=\"3\" >"); out.print(words); out.print("</td></tr>"); out.print("<tr><td align=\"right\">日期：</td><td>"); out.print(date); out.print("</td>"); } st.close(); cn.close(); } catch(Exception e){ out.print(e.getMessage()); } out.print("<form name=\"leavewordshome\" action=\"/test/servlet/LeaveWordsHome\" method=\"POST\">"); out.print("<input type=\"submit\" name=\"action\" value=\"留言主页\">"); out.print("</form>"); out.print("</body></html>"); out.flush(); }}⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?