showinfo.java

来自「我也是网上找的,换积分.对文件进行数字鉴名:」· Java 代码 · 共 68 行

JAVA
68
字号
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 + =
减小字号Ctrl + -
显示快捷键?