📄 maillist.java
字号:
package webmailservlet;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;public class maillist extends HttpServlet { private static final String CONTENT_TYPE = "text/html; charset=GBK"; /**Initialize global variables*/ public void init() throws ServletException { String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; try { Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e) { System.err.println( e.getMessage()); } } public ResultSet executeQuery(String sql) { String sConnStr = "jdbc:odbc:webmail"; Connection connect = null; ResultSet rs = null; rs = null; try { connect = DriverManager.getConnection(sConnStr); Statement stmt = connect.createStatement(); rs = stmt.executeQuery(sql); } catch(SQLException ex) { System.err.println(ex.getMessage()); } return rs; } public String getStr(String str) { try { String temp_p=str; byte[] temp_t=temp_p.getBytes("ISO8859-1"); String temp=new String(temp_t); return temp; } catch(Exception e) { } return "null"; } /**Process the HTTP Get request*/ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); HttpSession session=request.getSession(true); out.println("<html>"); out.println("<head>"); out.println("<title>Untitled Document</title>"); out.println("<meta http-equiv=\"Content-Type content=text/html; charset=gb2312\">"); out.println("</head>"); out.println("<body bgcolor=#FFFFFF>"); out.println("<table width=100% border=1>"); out.println("<tr>"); out.println(" <td width=18%>发件人</td>"); out.println(" <td width=25%>标题</td>"); out.println(" <td width=29%>时间</td>"); out.println(" <td width=28%>附件</td>"); out.println(" </tr>"); String sql; sql="select * from inbox where userID='"+session.getAttribute("username")+"'"; ResultSet RS; RS=executeQuery(sql); try { while(RS.next()) { int id; id=RS.getInt("id"); out.println("<tr>"); out.println("<td width=\"18%\"> "); out.println(RS.getString("fromID")); out.println("</td>"); out.println("<td width=\"25%\"> "); out.println("<a href=\"../webmail_sev/read.jsp?id="); out.println(id); out.println("\">"); out.println(RS.getString("title")); out.println("</a></td>"); out.println("<td width=\"29%\"> "); out.println(RS.getDate("send_time")); out.println("</td>"); out.println("<td width=\"28%\"> "); out.println(RS.getString("fujian")); out.println("</td>"); out.println("</tr>"); } RS.close(); } catch(Exception e) { System.err.println(e.getMessage()); } out.println("</table>"); out.println("</body>"); out.println("</html>"); } /**Clean up resources*/ public void destroy() { }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -