📄 reg.java
字号:
package webmailservlet;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;public class reg 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>reg</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); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head><title>reg</title></head>"); out.println("<body>"); String logname,realname,passwd1,passwd2,email,gender,phone; String problem,answer,province,education,selfintro,hobby; String[] hobbies; boolean regAttempt = false; String errorMessage = ""; HttpSession session=request.getSession(true); //必须填写的项目 logname=request.getParameter("logname"); realname=request.getParameter("realname"); passwd1=request.getParameter("passwd1"); passwd2=request.getParameter("passwd2"); email=request.getParameter("email"); gender=request.getParameter("Gender"); //非必须填写的项目 phone=request.getParameter("phone"); if(phone.trim().equals("")){ phone=null; } problem=request.getParameter("problem"); if(problem.trim().equals("")){ problem=null; } answer=request.getParameter("answer"); if(answer.trim().equals("")){ answer=null; } province=request.getParameter("Province"); if(province.trim().equals("")){ province=null; } education=request.getParameter("education"); if(education.trim().equals("")){ education=null; } hobbies=request.getParameterValues("hobbies"); hobby=""; if(hobbies!=null){ for (int i=0;i<hobbies.length;i++){ hobby=hobby+hobbies[i]; } }else hobby="null"; selfintro=request.getParameter("selfintro"); if(selfintro.trim().equals("")){ selfintro=null; } ///转换中文 logname=getStr(logname); realname=getStr(realname); passwd1 =getStr(passwd1); email=getStr(email); gender =getStr(gender); phone =getStr(phone); problem =getStr(problem); answer =getStr(answer); province =getStr(province); education=getStr(education); hobby=getStr(hobby); selfintro=getStr(selfintro); String sql="select ID from member where logname='"+logname+"'"; ResultSet RS=executeQuery(sql); out.println(sql); int rowscount=0; try { while(RS.next()) { rowscount++; } } catch(Exception e) { } //count.........// out.println(rowscount); if(rowscount==0) { regAttempt=true; }else response.sendRedirect("../webmail_sev/error.jsp"); if(regAttempt==true) { String sqlinsert="insert into member(logname,realname,password,email,gender,phone,problem,answer,province,education,hobbies,selfintro) Values('"+logname+"','"+realname+"','"+passwd1+"','"+email+"','"+gender+"','"+phone+"','"+problem+"','"+answer+"','"+province+"','"+education+"','"+hobby+"','"+selfintro+"')"; out.println(sqlinsert); executeQuery(sqlinsert); session.setAttribute("username",logname); response.sendRedirect("../webmail_sev/main.jsp"); } out.println("</body></html>"); } /**Clean up resources*/ public void destroy() { }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -