📄 login.java
字号:
package webmailservlet;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;public class login 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("<font color=\"green\">"); out.println("<p>The servlet get method is the reply.</p>"); out.println("</font>"); } /**Process the HTTP Post request*/ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head><title>login</title></head>"); out.println("<body>"); out.println("</body></html>"); String logname,logpass; boolean loginAttempt = false; boolean loginOK = false; String errorMessage = "请您登陆"; HttpSession session=request.getSession(true); if(request.getParameterValues("login") != null&&request.getParameterValues("logname") != null&&request.getParameterValues("logpass") != null){ loginAttempt = true;}if (loginAttempt){ logname=request.getParameter("logname"); logpass=request.getParameter("logpass"); logname=getStr(logname); logpass=getStr(logpass); String sql="select * from member where logname='"+logname+"' and password='"+logpass+"'"; out.println(sql); ResultSet RS=executeQuery(sql); int rowscount=0; try { while(RS.next()) { rowscount++; } } catch(Exception e) { } //count......... out.println(rowscount); if(rowscount!=0) { errorMessage="成功登陆"; session.setAttribute("username",logname); loginOK=true; if(loginOK){ response.sendRedirect("../webmail_sev/main.jsp"); } }else{ errorMessage="loginerr"; session.setAttribute("username",""); response.sendRedirect("../webmail_sev/login.jsp?err="+errorMessage); }} } /**Clean up resources*/ public void destroy() { }}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -