📄 send.java
字号:
package webmailservlet;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;public class send 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(); out.println("<html>"); out.println("<head><title>send</title></head>"); out.println("<body>"); out.println("<p>The servlet has received a GET. This is the reply.</p>"); out.println("</body></html>"); } /**Process the HTTP Post request*/ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); HttpSession session=request.getSession(true); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head><title>send</title></head>"); out.println("<body>"); String toID,title,content,fujian;toID=request.getParameter("toID");title=request.getParameter("title");content=request.getParameter("content");fujian=request.getParameter("fujian");//转换成中文toID=getStr(toID);title=getStr(title);content=getStr(content);fujian=getStr(fujian);String sql;sql="insert into inbox(userID,fromID,title,content,fujian) values('";sql=sql+toID+"','"+session.getAttribute("username")+"','"+title+"',";sql=sql+"'"+content+"','"+fujian+"')";out.println(sql);try{ executeQuery(sql);}catch(Exception e){ out.println(e);} out.println("成功发送信件"); out.println("</body></html>"); } /**Clean up resources*/ public void destroy() { }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -