jsp+sql火车订票系统

package com.action; /** * 会员注册、修改资料等 * @author Administrator * */ import java.io.IOException; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import com.bean.MemberBean; import com.bean.SystemBean; import com.util.Constant; import com.util.Filter; import com.util.MD5; public class MemberServlet extends HttpServlet { /** * Constructor of the object. */ public MemberServlet() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(Constant.CONTENTTYPE); request.setCharacterEncoding(Constant.CHARACTERENCODING); HttpSession session = request.getSession(); MemberBean memberBean = new MemberBean(); String method = Filter.escapeHTMLTags(request.getParameter("method").trim()); /********************************************* * 会员注册通用（检查用户名 修改密码 reg2.jsp页面跳转） *********************************************/ if(method.equals("reg2")){//会员注册 reg2.jsp String username = Filter.escapeHTMLTags(request.getParameter("username").trim()); String password = Filter.escapeHTMLTags(request.getParameter("password").trim()); String reg_type = Filter.escapeHTMLTags(request.getParameter("reg_type").trim()); request.setAttribute("username", username); request.setAttribute("password", password); request.setAttribute("reg_type", reg_type); if(username.trim().equals("admin")){ request.setAttribute("username", username); request.setAttribute("message", "非法的用户名，请重新选择！"); request.getRequestDispatcher("reg2.jsp").forward(request, response); } else{ int flag = memberBean.checkRegName(username); if(flag == Constant.SUCCESS){ if(reg_type.equals("person")){//如果是个人会员 request.getRequestDispatcher("personreg.jsp").forward(request, response); } else if(reg_type.equals("co")){//如果是企业会员 request.getRequestDispatcher("coreg.jsp").forward(request, response); } else{ request.getRequestDispatcher("index.jsp").forward(request, response); } } else if(flag == Constant.SAME_NAME){ request.setAttribute("username", username); request.setAttribute("message", "对不起，该用户名已存在，请重新选择！"); request.getRequestDispatcher("reg2.jsp").forward(request, response); } else{ request.setAttribute("message", "系统维护中，请稍后再试！"); request.getRequestDispatcher("reg2.jsp").forward(request, response); } } } else if(method.equals("checksame")){//检查注册名是否可用 String username = Filter.escapeHTMLTags(request.getParameter("username").trim()); if(username.trim().equals("admin")){ request.setAttribute("username", username); request.setAttribute("message", "非法的用户名，请重新选择！"); request.getRequestDispatcher("reg2.jsp").forward(request, response); } else{ int flag = memberBean.checkRegName(username); if(flag == Constant.SUCCESS){ request.setAttribute("username", username); request.setAttribute("message", "恭喜您，这个名字可以使用！"); request.getRequestDispatcher("reg2.jsp").forward(request, response); } else if(flag == Constant.SAME_NAME){ request.setAttribute("username", username); request.setAttribute("message", "对不起，该用户名已存在，请重新选择！"); request.getRequestDispatcher("reg2.jsp").forward(request, response); } else{ request.setAttribute("message", "系统维护中，请稍后再试！"); request.getRequestDispatcher("reg2.jsp").forward(request, response); } } } else if(method.equals("Editpwd")){//会员修改登陆密码 String member=(String)session.getAttribute("member"); String type=(String)session.getAttribute("type"); if(member==null||type==null){ response.sendRedirect("error.jsp"); } else{ String oldpwd = MD5.MD5(request.getParameter("oldpwd").trim()); String newpwd = MD5.MD5(request.getParameter("newpwd").trim()); int flag = memberBean.editPassword(member, oldpwd, newpwd); switch (flag){ case Constant.SUCCESS: request.setAttribute("message", "密码修改成功！"); request.getRequestDispatcher("member/info/editpwd.jsp").forward(request, response); break; case Constant.PASSWORD_ERROR: request.setAttribute("message", "原始密码错误，请确认权限！"); request.getRequestDispatcher("member/info/editpwd.jsp").forward(request, response); break; case Constant.SYSTEM_ERROR: request.setAttribute("message", "系统维护中，请稍后再试！"); request.getRequestDispatcher("member/info/editpwd.jsp").forward(request, response); break; } } } /********************************************* * 个人会员注册、修改资料 *********************************************/ else if(method.equals("PREG")){//个人会员详细资料 String username = Filter.escapeHTMLTags(request.getParameter("username").trim()); String password = Filter.escapeHTMLTags(request.getParameter("password").trim()); String type = "person"; String realname = Filter.escapeHTMLTags(request.getParameter("realname").trim()); String sex = Filter.escapeHTMLTags(request.getParameter("sex").trim()); String sheng = Filter.escapeHTMLTags(request.getParameter("sheng").trim()); String city = Filter.escapeHTMLTags(request.getParameter("city").trim()); String bir = Filter.escapeHTMLTags(request.getParameter("bir").trim()); String telphone = Filter.escapeHTMLTags(request.getParameter("telphone").trim()); String email = Filter.escapeHTMLTags(request.getParameter("email").trim()); String question = Filter.escapeHTMLTags(request.getParameter("question").trim()); String answer = Filter.escapeHTMLTags(request.getParameter("answer").trim()); String lastip = request.getRemoteAddr(); int off = 1; int flag = memberBean.personReg(username, password, type, realname, sex, bir,sheng,city, telphone, email, question, answer, lastip, off); if(flag == Constant.SUCCESS){ List siteList = new SystemBean().getSiteInfo(); String sitename = siteList.get(0).toString(); request.setAttribute("message", "注册成功！恭喜您成为"+sitename+"的注册会员，登陆后您可以发布业务信息！"); request.getRequestDispatcher("login.jsp").forward(request, response); } else{ request.setAttribute("message", "系统维护中，请稍后再试！"); request.getRequestDispatcher("personreg.jsp").forward(request, response); } } else if(method.equals("UPREGINFO")){//个人会员修改资料 String member=(St