cms.rar_jsp servlet cms_班级管理系统

package servlet; import java.io.IOException; import java.io.PrintWriter; import java.io.UnsupportedEncodingException; import java.util.ArrayList; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import dao.DepartDao; import entity.Departinfo; public class DepartServlet extends HttpServlet { /** * Constructor of the object. */ public DepartServlet() { 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 { //获取修改页面上每个输入框里面的值 request.setCharacterEncoding("gb2312"); response.setCharacterEncoding("gb2312"); String sper=request.getParameter("oper"); if(sper.equals("1")){ UpdateServelet(request,response); } else if(sper.equals("2")){ DeleteServelet(request, response); } else if(sper.equals("3")){ AddServelet(request, response); } // else if(sper.equals("4")){ // BackServelet(request, response); // } else if(sper.equals("5")){ QueryoneServlet(request, response); } } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occurs */ public void init() throws ServletException { // Put your code here } public void UpdateServelet(HttpServletRequest request, HttpServletResponse response) throws IOException{//修改部门信息 //编码 request.setCharacterEncoding("gb2312"); response.setCharacterEncoding("gb2312"); //获取页面上输入的值 String deid=request.getParameter("id"); //获取编号 String deno=request.getParameter("number"); //获取输入的部门编号 String dename=request.getParameter("name"); //获取输入的部门名称 String depfor=request.getParameter("select");//获取选中的上级部门名称 //创建dao和实体对象 DepartDao depdao=new DepartDao(); Departinfo depinfo=new Departinfo(); Departinfo depinfo1=new Departinfo(); //通过上级部门名称获取上级部门编号 depinfo1=depdao.QueryByName(depfor); //通过对获取的上级部门名称查询出一个实体对象depinfo1 String forward=depinfo1.getDepart_no()+""; //获取depinfo1的部门编号 depfor=forward+deno; //将获取的部门编号与输入的部门编号（2个字符串）进行连接成depfor //判断新增加的部门编号depfor在数据库中是否存在 ArrayList list=new ArrayList(); Departinfo depin=new Departinfo(); DepartDao depDao=new DepartDao(); list=depDao.QueryAll(); //对数据库进行查询 //判断查询到的实体的部门编号是否与新增的部门编号depfor相等 for(int i=0;i<list.size();i++){ depin=(Departinfo)list.get(i); //通过i值获取对应的实体 if(Integer.parseInt(depfor)==depin.getDepart_no()){//当查询到的实体的部门编号与新增的部门编号depfor相等时，直接返回不执行后面的语句 //response.sendRedirect("error.jsp"); return; } } //当查询完数据库里面存在的所有部门编号与新增的部门编号不相同的时候执行下面的代码，进行修改 //将获得的值放入实体对象depinfo里面 depinfo.setDepart_id(Integer.parseInt(deid)); depinfo.setDepart_no(Integer.parseInt(depfor));//修改后的部门编号 depinfo.setDepart_name(dename);//修改后的部门名称 depinfo.setDepart_forward(Integer.parseInt(forward));//获取的上级部门编号 //将实体类放入DepartDao里面让其对数据库进行更新 boolean result= depdao.UpdateDepart(depinfo); if(result){//如果修改成功跳转到显示所有信息界面 response.sendRedirect("web/depart_manage/departlist.jsp"); } else{//如果修改失败，跳转到错误页面 response.sendRedirect("../error.jsp"); } } public void DeleteServelet(HttpServletRequest request, HttpServletResponse response) throws IOException{//删除部门信息 String sid=request.getParameter("id");//获取需要删除的编号 //创建dao与实体 DepartDao depdao=new DepartDao(); Departinfo depinfo=new Departinfo(); depinfo=depdao.QueryById(sid);//通过获取的编号进行查询并得到对象depinfo int count = 0; ArrayList list=new ArrayList(); list=depdao.QueryAll();//对数据库里面的数据进行全部查询，并放到数组list里面 for(int i=0;i<list.size();i++){ Departinfo depin=new Departinfo(); depin=(Departinfo)list.get(i);//将数组中每一个值存入一个实体depin对象里面 if(depin.getDepart_forward()==depinfo.getDepart_no()){//如果要删除的编号下的当前实体的部门编号存在与查询到的实体depin的上级部门编号相同的话，对count进行累加 count++; } } if(count > 0) {//如果count的值大于0的话说明要删除的部门存在下级部门则该部门不能进行删除跳转到错误页面 response.sendRedirect("error1.jsp"); } else {//如果count值依然为0的话说明该部门不存在下级部门可以进行删除操作 boolean result=depdao.deletdepart(sid);//执行dao里面的删除方法 if(result){//删除成功 response.sendRedirect("web/depart_manage/departlist.jsp"); } else{//删除失败，跳转到错误页面。 response.sendRedirect("error1.jsp"); } } } public void AddServelet(HttpServletRequest request, HttpServletResponse response) throws IOException{//增加部门信息 //编码 request.setCharacterEncoding("gb2312"); response.setCharacterEncoding("gb2312"); //获取页面上输入的值 String deno=request.getParameter("no");//获取输入的部门编号 String dename=request.getParameter("name");//获取输入的部门名称 String depfor=request.getParameter("select");//获取上级部门名称 //System.out.println(depfor); if(deno!=""&&dename!=""&&depfor!=""){//如果从输入框中获取的2个值都不为空的时候则执行下面的代码 //创建dao和实体对象 DepartDao depdao=new DepartDao(); Departinfo depinfo=new Departinfo(); Departinfo depinfo1=new Departinfo(); //通过上级部门名称获取上级部门编号 depinfo1=depdao.QueryByName(depfor);//通过选择获取的部门名称查询该部门的部门信息 String forward=depinfo1.getDepart_no()+"";//获取查询到的depinfo1的部门编号 depfor=forward+deno;//将输入的部门编号deno与获取到的上级的部门编号forward（它们都为字符串）进行连接 //System.out.println(depfor); ArrayList list=new ArrayList(); Departinfo depin=new Departinfo(); DepartDao depDao=new DepartDao(); list=depDao.QueryAll();//查询数据库中所有的部门信息，并放入到数组list中 for(int i=0;i<list.size();i++){ depin=(Departinfo)list.get(i);//把获取的每一条部门信息放入实体对象depin中去 if(Integer.parseInt(depfor)==depin.getDepart_no()){//如果查询到的depin的部门编号与新增的部门编号相同的话，则直接返回不执行后面的代码 response.sendRedirect("error.jsp");//跳转到错误页面 return; } } //如果查询到的depin的部门编号与新增的部门编号不相同的话，则将获得的值放入实体对象depinfo里面 depinfo.setDepart_no(Integer.parseInt(depfor)); depinfo.setDepart_name(dename); depinfo.setDepart_forward(Integer.parseInt(forward)); //将实体类放入DepartDao里面让其对数据库进行�