JSP+Oracle数据库开发与实例

package jsp.oracle; import java.io.IOException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import jsp.oracle.util.MD5; import jsp.oracle.util.Signal; import jsp.oracle.mail; import jsp.oracle.users; import jsp.oracle.AdminUser; public class AdminServlet extends HttpServlet { private static final long serialVersionUID = 878216958170698920L; final static boolean VERBOSE = true; private HttpServletRequest bw_request = null; private HttpServletResponse bw_response = null; public void service(HttpServletRequest request, HttpServletResponse response) { bw_request = request; bw_response = response; String command = request.getParameter("cmd"); try { switch (Signal.getCommand(command)) { case Signal.COMMAND_ADMINUSER_LOGIN: adminUserLogin(); break; case Signal.COMMAND_ADMINUSER_LOCK: lockAdminUser(); break; case Signal.COMMAND_ADMINUSER_DEL: delAdminUser(); break; case Signal.COMMAND_ADMINUSER_UNLOCK: unlockAdminUser(); break; case Signal.COMMAND_ADMINUSER_EDITPWD: editAdminUserPwd(); break; case Signal.COMMAND_ADMINUSER_LOGOUT: adminUserLogout(); break; case Signal.COMMAND_ADMINUSER_PWDMODIFY: adminUserPwdModify(); break; case Signal.COMMAND_USER_ADD: addUser(); break; case Signal.COMMAND_USER_LOCK: lockUser(); break; case Signal.COMMAND_USER_UNLOCK: unlockUser(); break; case Signal.COMMAND_USER_EDITPWD: adminEditUserPwd(); break; case Signal.COMMAND_USER_EDITINFO: editUserInfo(); break; case Signal.COMMAND_ADMINUSER_ADD: addAdminUser(); break; case Signal.COMMAND_USER_RECOVER_MAIL: recoverMail(); break; case Signal.COMMAND_USER_2NDDEL_MAIL: user2ndDelMail(); break; case Signal.COMMAND_RECEIVER_DEL_MULTIPLE_MAIL: receiverDelMultipleMail(); break; case Signal.COMMAND_SENDER_DEL_MULTIPLE_MAIL: senderDelMultipleMail(); break; case Signal.COMMAND_RECEIVER_DEL_MAIL: receiverDelMail(); break; case Signal.COMMAND_SENDER_DEL_MAIL: senderDelMail(); break; case Signal.COMMAND_MULTIPLE_MAIL_FINAL_DEL: delMultipleMail(); break; case Signal.COMMAND_MULTIPLE_USER_FINAL_DEL: delMultipleUser(); break; default: bw_response.sendRedirect("error.jsp?msg='没有指定操作类型'"); break; } } catch (Exception ex) { ex.printStackTrace(); } } boolean CheckDate(String item) { String validChar="0123456789"; int i=0; //检测是否包含“-” if(item.indexOf("-")==-1) {return false;} //截取第一个“-”前的字符串 String CheckYear=item.substring(0,item.indexOf("-")); //判断这个字符串长度是不是4 if(CheckYear.length()!=4) {return false;} //判断是不是数值型 for(i=0;i<4;i++) { if(validChar.indexOf(CheckYear.charAt(i))==-1) {return false;} } //判断这个数值的大小 if(Integer.parseInt(CheckYear)<1900||Integer.parseInt(CheckYear)>2100) {return false;} //截取除去年份的字符串 item=item.substring(5,item.length()); //检测是否包含“-” if(item.indexOf("-")==-1) {return false;} //截取第一个“-”前的字符串为月份 String CheckMonth=item.substring(0,item.indexOf("-")); //判断这个字符串长度是不是1或2 if((CheckMonth.length()!=1)&&(CheckMonth.length()!=2)) {return false;} //判断是不是数值型 for(i=0;i<CheckMonth.length();i++) { if(validChar.indexOf(CheckMonth.charAt(i))==-1) {return false;} } //判断这个数值的大小是不是超过12 if(Integer.parseInt(CheckMonth)>12||Integer.parseInt(CheckMonth)<1) {return false;} //截取除去月份的字符串 String CheckDay=item.substring((CheckMonth.length()+1),item.length()); //判断这个字符串长度是不是1或2 if((CheckDay.length()!=1)&&(CheckDay.length()!=2)) {return false;} //判断是不是数值型 for(i=0;i<CheckDay.length();i++) { if(validChar.indexOf(CheckDay.charAt(i))==-1) {return false;} } //判断这个数值的大小是不是超过31 if(Integer.parseInt(CheckDay)>31||Integer.parseInt(CheckDay)<1) {return false;} return true; } public void adminUserLogin() throws IOException { HttpSession session = bw_request.getSession(true); String adminUser = bw_request.getParameter("adminUser"); String adminPwd = bw_request.getParameter("adminPwd"); String msg = "System error!"; AdminUser admin=new AdminUser(); MD5 md5=new MD5(); admin.setAdminUser(adminUser); admin.setAdminPwd(md5.getMD5ofStr(adminPwd)); //admin.setAdminPwd(adminPwd); try { int result=admin.verifyAdminUser(); if (result == 1) { session.setAttribute("adminLogin", "true"); AdminUser sessionUser = admin.getAdminUserByAdminUser(); session.setAttribute("adminUser", sessionUser); bw_request.getRequestDispatcher("index.jsp").forward(bw_request, bw_response); } else { try { msg = "用户名或密码输入错误,请重新登录!"; bw_request.getRequestDispatcher("error.jsp?msg="+msg).forward(bw_request, bw_response); } catch (Exception ex) { ex.printStackTrace(); } } } catch (Exception ex) { ex.printStackTrace(); } } public void adminUserLogout() throws IOException { try { String msg = "System error!"; HttpSession session = bw_request.getSession(true); String login = (String) session.getAttribute("adminLogin"); if(login!=null && login.equals("true")) { session.removeAttribute("adminUser"); session.invalidate(); bw_request.getRequestDispatcher("login.jsp").forward(bw_request, bw_response); } else{ try { msg = "登录时间过长,已经自动退出!"; bw_request.getRequestDispatcher("error.jsp?msg="+msg).forward(bw_request, bw_response); } catch (Exception ex) { ex.printStackTrace(); } } } catch (Exception ex) { ex.printStackTrace(); } } public void lockAdminUser() throws IOException{ HttpSession session = bw_request.getSession(true); String adminUser = bw_request.getParameter("adminUser"); String msg=""; if(adminUser!=null) { AdminUser admin=new AdminUser(); admin.setAdminUser(adminUser); admin=admin.getAdminUserByAdminUser(); try { int result=admin.lock(); if(result==1) { session.setAttribute("message","禁用管理员成功!"); bw_response.sendRedirect(bw_request.getHeader("referer")); } else { session.setAttribute("message","禁用管理员失败，请稍后再试!"); bw_response.sendRedirect(bw_request.getHeader("referer")); } } catch (Exception ex) { ex.printStackTrace(); } } else { msg="没有指定管理员用户名！"; bw_response.sendRedirect("error.jsp?msg="+msg); } } public void unlockAdminUser() throws IOException{ HttpSession session = bw_request.getSession(true); String adminUser = bw_request.getParameter("adminUser"); String msg=""; if(adminUser!=null) { AdminUser admin=new AdminUser(); admin.setAdminUser(adminUser); admin=admin.getAdminUserByAdminUser(); try { int result=admin.unlock(); if(result==1) { session.setAttribute("message","恢复管理员成功!"); bw_response.sendRedirect(bw_request.getHeader("referer")); } else { session.setAttribute("message","恢复管理员失败，请稍后再试!"); bw_response.sendRedirect(bw_request.getHeader("referer")); } } catch (Exception ex) {