?? 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 + -