最简单的servlet加jsp增删改查项目，附数据库语句

package com.menghuan.controller; import java.io.IOException; import java.io.PrintWriter; import java.util.List; import java.util.Map; 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 org.jcp.xml.dsig.internal.MacOutputStream; import com.alibaba.druid.sql.ast.statement.SQLIfStatement.Else; import com.menghuan.domain.Equipment; import com.menghuan.domain.PageUtil; import com.menghuan.domain.Role; import com.menghuan.domain.Student; import com.menghuan.service.StudentService; import com.menghuan.service.impl.StudentServiceImpl; import com.menghuan.util.ServiceFactory; import com.sun.org.apache.bcel.internal.generic.NEW; public class StudentController extends HttpServlet{ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { System.out.println("进入学生信息操作"); StudentService ss=(StudentService) ServiceFactory.getProxy(new StudentServiceImpl()); String path=request.getServletPath(); if("/list.do".equals(path)){ list(request,response,ss); }else if("/save.do".equals(path)){ save(request,response,ss); }else if("/delete.do".equals(path)){ delte(request,response,ss); }else if("/edit.do".equals(path)){ edit(request,response,ss); }else if("/update.do".equals(path)){ update(request,response,ss); }else if("/out.do".equals(path)){ out(request,response,ss); }else if("/role.do".equals(path)){ role(request,response,ss); }else if("/equipment.do".equals(path)){ equipment(request,response,ss); } } private void equipment(HttpServletRequest request, HttpServletResponse response, StudentService ss) throws IOException { System.out.println("进入装备查询操作"); int rid = Integer.parseInt(request.getParameter("rid")); List<Equipment> eList=ss.listEquiment(rid); StringBuffer sb=new StringBuffer(); //{"id":?,"name":"?"}} //{"pList":[{},{} sb.append("{\"eList\":["); for(int i=0;i<eList.size();i++){ Equipment e=eList.get(i); sb.append("{\"id\":"); sb.append(e.getId()); sb.append(",\"name\":\""); sb.append(e.getName()); sb.append("\"}"); if(i<eList.size()-1){ sb.append(","); } } sb.append("]}"); System.out.println(sb.toString()); PrintWriter out=response.getWriter(); out.print(sb.toString()); out.close(); } private void role(HttpServletRequest request, HttpServletResponse response, StudentService ss) throws IOException { System.out.println("进入角色查询操作"); List<Role> rList = ss.listRole(); StringBuffer sb=new StringBuffer(); //{"id":?,"name":"?"}} //{"pList":[{},{} sb.append("{\"rList\":["); for(int i=0;i<rList.size();i++){ Role r=rList.get(i); sb.append("{\"id\":"); sb.append(r.getId()); sb.append(",\"name\":\""); sb.append(r.getName()); sb.append("\"}"); if(i<rList.size()-1){ sb.append(","); } } sb.append("]}"); System.out.println(sb.toString()); PrintWriter out=response.getWriter(); out.print(sb.toString()); out.close(); } private void out(HttpServletRequest request, HttpServletResponse response, StudentService ss) throws ServletException, IOException { System.out.println("进行登出操作"); HttpSession session = request.getSession(); String username = (String)session.getAttribute("username"); if(username==null){ response.sendRedirect(request.getContextPath()+"/login.jsp"); } session.invalidate(); response.sendRedirect(request.getContextPath()+"/login.jsp"); } private void update(HttpServletRequest request, HttpServletResponse response, StudentService ss) throws IOException { System.out.println("进入修改页面"); String id=request.getParameter("id"); String name = request.getParameter("name"); int age =Integer.parseInt(request.getParameter("age")) ; Student s=new Student(); s.setId(id); s.setName(name); s.setAge(age); ss.updateStudent(s); response.sendRedirect(request.getContextPath()+"/jsp/list.jsp"); } private void edit(HttpServletRequest request, HttpServletResponse response, StudentService ss) throws IOException { System.out.println("进入编辑页面"); String id = request.getParameter("id"); Student s=ss.editStudent(id); //{"id":"?","name":"?","age":?} String str="{\"id\":\""+s.getId()+"\",\"name\":\""+s.getName()+"\",\"age\":"+s.getAge()+"}"; System.out.println(str); PrintWriter out=response.getWriter(); out.print(str); out.close(); } private void delte(HttpServletRequest request, HttpServletResponse response, StudentService ss) throws IOException { System.out.println("进行删除操作"); String[] id = request.getParameterValues("id"); ss.deleteStudent(id); response.sendRedirect(request.getContextPath()+"/jsp/list.jsp"); } private void save(HttpServletRequest request, HttpServletResponse response, StudentService ss) throws IOException { System.out.println("进入添加学生操作"); String name = request.getParameter("name"); int age =Integer.parseInt(request.getParameter("age")) ; Student s=new Student(); s.setName(name); s.setAge(age); ss.saveStudent(s); response.sendRedirect(request.getContextPath()+"/jsp/list.jsp"); } private void list(HttpServletRequest request, HttpServletResponse response, StudentService ss) throws ServletException,IOException { String pageNoStr=request.getParameter("pageNo"); Map<String, Object> map=ss.getAll(pageNoStr); PageUtil pu=(PageUtil) map.get("pu"); System.out.println(pu); List<Student> sList=(List<Student>) map.get("sList"); System.out.println(sList); StringBuffer sb=new StringBuffer(); //{"sList":[{"id":"?","name":"?","age":?},{}]} sb.append("{\"pu\":{\"pageNo\":"); sb.append(pu.getPageNo()); sb.append(",\"pagecount\":"); sb.append(pu.getPagecount()); sb.append(",\"pagesize\":"); sb.append(pu.getPagesize()); sb.append(",\"total\":"); sb.append(pu.getTotal()); sb.append("},\"sList\":["); for(int i=0;i<sList.size();i++){ Student s=sList.get(i); //sb.append("{\"id\":\""+s.getId()+"\",\"name\":\""+s.getName()+"\",\"age\":"+s.getAge()+"}"); sb.append("{\"id\":\""); sb.append(s.getId()); sb.append("\",\"name\":\""); sb.append(s.getName()); sb.append("\",\"age\":"); sb.append(s.getAge()); sb.append("}"); if(i<sList.size()-1){ sb.append(","); } } sb.append("]}"); System.out.println(sb.toString()); PrintWriter out=response.getWriter(); out.print(sb.toString()); out.close(); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }