ssm jsp mysql 旅游管理系统.zip

package control; import java.io.BufferedInputStream; import java.io.BufferedOutputStream; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.io.PrintWriter; import java.io.UnsupportedEncodingException; import java.net.URLEncoder; import java.util.ArrayList; import java.util.HashMap; 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 jxl.Cell; import jxl.Sheet; import jxl.Workbook; import org.apache.commons.fileupload.FileItem; import org.apache.commons.fileupload.FileUpload; import org.apache.commons.fileupload.RequestContext; import org.apache.commons.fileupload.disk.DiskFileItemFactory; import org.apache.commons.fileupload.servlet.ServletFileUpload; import org.apache.commons.fileupload.servlet.ServletRequestContext; import util.Info; import util.StrUtil; import dao.CommDAO; public class MainCtrl extends HttpServlet { public MainCtrl() { super(); } public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } public void go(String url, HttpServletRequest request, HttpServletResponse response) { try { request.getRequestDispatcher(url).forward(request, response); } catch (ServletException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } public void gor(String url, HttpServletRequest request, HttpServletResponse response) { try { response.sendRedirect(url); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); String ac = request.getParameter("ac"); if (ac == null) ac = ""; CommDAO dao = new CommDAO(); String date = Info.getDateStr(); String today = date.substring(0, 10); String tomonth = date.substring(0, 7); HttpSession session = request.getSession(); if (ac.equals("compl")) { String touname = request.getParameter("touname") == null ? "" : request.getParameter("touname"); String sname = request.getParameter("sname") == null ? "" : request.getParameter("sname"); String ctype = request.getParameter("ctype") == null ? "" : request.getParameter("ctype"); String message = request.getParameter("message") == null ? "" : request.getParameter("message"); String bid = request.getParameter("bid") == null ? "" : request.getParameter("bid"); String savetime = date; String uname = Info.getUser(request).get("uname").toString(); String sql = "insert into compl(sname,touname,ctype,message,bid,savetime,uname " + ")values('" + sname + "','" + touname + "','" + ctype + "','" + message + "','" + bid + "','" + savetime + "','" + uname + "')"; dao.commOper(sql); session.setAttribute("suc", "suc"); response.sendRedirect("/travelopr/pre.jsp?id=" + bid); } if (ac.equals("login")) { String pagerandom = request.getParameter("pagerandom") == null ? "" : request.getParameter("pagerandom"); String random = (String) request.getSession().getAttribute("random"); if (!pagerandom.equals(random) && request.getParameter("a") != null) { request.setAttribute("random", ""); go("/login.jsp", request, response); } else { String username = request.getParameter("uname"); String password = request.getParameter("upass"); String utype = request.getParameter("utype"); request.getSession().setAttribute("utype", utype); List<HashMap> list = dao .select("select * from sysuser where uname='" + username + "' and status='正常'"); if (list.size() == 1) { HashMap map = list.get(0); List<HashMap> ulist = dao .select("select * from sysuser where utype='" + utype + "' and uname='" + username + "' and upass='" + password + "' and status='正常' "); if (ulist.size() == 1 && password.equals(map.get("upass").toString())) { request.getSession().setAttribute("admin", map); gor("/travelopr/index.jsp", request, response); } else { request.setAttribute("error", ""); go("/login.jsp", request, response); } } else { request.setAttribute("error", ""); go("/login.jsp", request, response); } } } //修改密码 if (ac.equals("uppass")) { String userpass = request.getParameter("upass"); String copyuserpass = request.getParameter("copyuserpass"); HashMap user = dao.getmap(Info.getUser(request).get("id").toString(), "sysuser"); String id = (String) user.get("id"); String sql = "update sysuser set upass='" + userpass + "' where id=" + id; dao.commOper(sql); request.setAttribute("suc", ""); go("/admin/uppass.jsp", request, response); } if (ac.equals("uploaddoc")) { try { String filename = ""; request.setCharacterEncoding("utf-8"); RequestContext requestContext = new ServletRequestContext(request); if (FileUpload.isMultipartContent(requestContext)) { DiskFileItemFactory factory = new DiskFileItemFactory(); factory.setRepository(new File(request.getRealPath("/upfile/") + "/")); ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(100 * 1024 * 1024); List items = new ArrayList(); items = upload.parseRequest(request); FileItem fileItem = (FileItem) items.get(0); if (fileItem.getName() != null && fileItem.getSize() != 0) { if (fileItem.getName() != null && fileItem.getSize() != 0) { File fullFile = new File(fileItem.getName()); filename = Info.generalFileName(fullFile.getName()); File newFile = new File(request.getRealPath("/upfile/") + "/" + filename); try { fileItem.write(newFile); } catch (Exception e) { e.printStackTrace(); } } else { } } } gor("/travelopr/js/uploaddoc.jsp?docname=" + filename, request, response); } catch (Exception e1) { e1.printStackTrace(); } } if (ac.equals("uploaddoc2")) { try { String filename = ""; request.setCharacterEncoding("utf-8");