📄 showinfo.java
字号:
package simplebbs;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import java.util.Vector;
public class ShowInfo 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:info");
//数据驱动
String str="SELECT * FROM info";
Statement statement=cn.createStatement();
ResultSet resultSet=statement.executeQuery(str);
String name,date,email,topic,words;
while(resultSet.next()){
name=resultSet.getString("name");
date=resultSet.getString("wdate");
email=resultSet.getString("email");
topic=resultSet.getString("topic");
words=resultSet.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>");
}
statement.close();
cn.close();
//关闭
}
catch(Exception e){
out.print(e.getMessage());
}
out.print("<form name=\"inputinfohome\" action=\"inputinfohome\" 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -