客户关系管理系统jsp+servlet+javabean

package com.crm.servlet; import java.io.IOException; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.crm.factory.DAOFactory; import com.crm.vo.Employee; import com.crm.vo.Sal_chance; public class ChanceServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } private List<Employee> getEmployee(){ List<Employee> list = new ArrayList<Employee>(); try { list = DAOFactory.getChanceInstance().findByName(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { int action = Integer.valueOf(request.getParameter("act")); if(action == 1){ List<Sal_chance> list = new ArrayList<Sal_chance>(); String path = "list.jsp"; try { list = DAOFactory.getChanceInstance().findByAll(); if(list.size()!=0){ request.setAttribute("chance", list); }else{ request.setAttribute("error", "数据库查无记录！"); } request.getRequestDispatcher(path).forward(request, response); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if(action == 2){ String cust_name = request.getParameter("name"); String title = request.getParameter("title"); String linkman = request.getParameter("linkname"); System.out.println(cust_name); System.out.println(title); System.out.println(linkman); String sql = "WHERE chc_cust_name="+cust_name+" AND chc_title="+title+" AND chc_linkman="+linkman; List<Sal_chance> list = new ArrayList<Sal_chance>(); String path = "list.jsp"; try { list = DAOFactory.getChanceInstance().findByTitle(sql); if(list.size()!=0){ request.setAttribute("chance", list); }else{ request.setAttribute("error", "数据库查无记录！"); } request.getRequestDispatcher(path).forward(request, response); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if(action == 3){ String source = request.getParameter("source"); String custname = request.getParameter("custname"); int rate = Integer.valueOf(request.getParameter("rate")); String title = request.getParameter("title"); String linkman = request.getParameter("linkman"); String tel = request.getParameter("tel"); String desc = request.getParameter("desc"); String creater = request.getParameter("creater"); long createid = Long.valueOf(request.getParameter("createid")); String date = request.getParameter("date"); String status = "新建"; Sal_chance chance = new Sal_chance(); chance.setChc_source(source); chance.setChc_cust_name(custname); chance.setChc_rate(rate); chance.setChc_title(title); chance.setChc_linkman(linkman); chance.setChc_tel(tel); chance.setChc_desc(desc); chance.setChc_create_by(creater); chance.setChc_create_id(createid); chance.setChc_create_date(date); chance.setChc_status(status); String path = "add.jsp"; try { int flag = DAOFactory.getChanceInstance().chance_save(chance); if(flag == 1){ List<Sal_chance> list = new ArrayList<Sal_chance>(); list = DAOFactory.getChanceInstance().findByAll(); request.setAttribute("chance", list); path = "list.jsp"; request.getRequestDispatcher(path).forward(request, response); }else{ request.setAttribute("error", "添加失败"); response.sendRedirect(path); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if(action == 4){ long id = Long.valueOf(request.getParameter("id")); Sal_chance chance = null; String path = "dispatch.jsp"; try { chance = DAOFactory.getChanceInstance().findById(id); if(chance instanceof Sal_chance){ request.setAttribute("sal", chance); request.setAttribute("emp", getEmployee()); }else{ request.setAttribute("error", "查找失败"); } request.getRequestDispatcher(path).forward(request, response); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if(action == 5){ String name = request.getParameter("name"); long id = Long.valueOf(request.getParameter("id")); long empno = Long.valueOf(request.getParameter("empno")); String path = "dispatch.jsp"; Employee emp = new Employee(); emp.setEmp_no(empno); emp.setEmp_name(name); int flag = 0; try { flag = DAOFactory.getChanceInstance().chance_due_update(emp, id); if(flag == 1){ List<Sal_chance> list = new ArrayList<Sal_chance>(); list = DAOFactory.getChanceInstance().findByAll(); request.setAttribute("chance", list); path = "list.jsp"; request.getRequestDispatcher(path).forward(request, response); }else{ request.setAttribute("error", "指派人员失败"); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if(action == 6){ long id = Long.valueOf(request.getParameter("id")); Sal_chance chance = null; String path = "edit.jsp"; try { chance = DAOFactory.getChanceInstance().findById(id); if(chance instanceof Sal_chance){ request.setAttribute("sal", chance); request.setAttribute("emp", getEmployee()); }else{ request.setAttribute("error", "查找失败"); } request.getRequestDispatcher(path).forward(request, response); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if(action == 7){ long id = Long.valueOf(request.getParameter("id")); String source = request.getParameter("source"); String custname = request.getParameter("custname"); int rate = Integer.valueOf(request.getParameter("rate")); String title = request.getParameter("title"); String linkman = request.getParameter("linkman"); String tel = request.getParameter("tel"); String desc = request.getParameter("desc"); Sal_chance chance = new Sal_chance(); chance.setChc_id(id); chance.setChc_source(source); chance.setChc_cust_name(custname); chance.setChc_rate(rate); chance.setChc_title(title); chance.setChc_linkman(linkman); chance.setChc_tel(tel); chance.setChc_desc(desc); String path = "edit.jsp"; try { int flag = DAOFactory.getChanceInstance().chance_update(chance); if(flag == 1){ List<Sal_chance> list = new ArrayList<Sal_chance>(); list = DAOFactory.getChanceInstance().findByAll(); request.setAttribute("chance", list); path = "list.jsp"; request.getRequestDispatcher(path).forward(request, response); }else{ request.setAttribute("error", "修改失败"); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }