JDBCExample.zip

package qust.jdbcexample.servlet; import java.io.IOException; import java.lang.reflect.InvocationTargetException; import java.util.List; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.commons.beanutils.BeanUtils; import qust.jdbaexample.domain.Student; import qust.jdbcexample.service.*; @WebServlet("/StudentServlet") public class StudentServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub String action=request.getParameter("action"); switch(action){ case "show": show(request,response); break; case "insert": insert(request,response); break; case "update": update(request,response); break; case "save": save(request,response); break; case "del": del(request,response); break; case "login": login(request,response); break; } } private void login(HttpServletRequest request, HttpServletResponse response)throws ServletException,IOException { // TODO 自动生成的方法存根 String username=request.getParameter("username"); System.out.println(username); String password=request.getParameter("password"); System.out.println(password); StudentService ss=new StudentService(); boolean flag=ss.login(username, password); System.out.println("2:"); System.out.println(flag); if(flag){ request.getRequestDispatcher("demo.jsp").forward(request, response); } else{ request.getRequestDispatcher("login.jsp").forward(request, response); } } private void insert(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{ Student stu=new Student(); try{ BeanUtils.populate(stu,request.getParameterMap()); }catch(IllegalAccessException | InvocationTargetException e){ e.printStackTrace(); } StudentService ss=new StudentService(); boolean flag=ss.insert(stu); if(flag){ request.setAttribute("msg", "成功！"); }else{ request.setAttribute("msg", "失败！"); } request.getRequestDispatcher("studentadd.jsp").forward(request, response); } private void show(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{ StudentService ss=new StudentService(); List<Student> students=ss.findAll(); request.setAttribute("students", students); request.getRequestDispatcher("show.jsp").forward(request, response); } private void save(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{ Student stu=new Student(); try{ BeanUtils.populate(stu, request.getParameterMap()); }catch(IllegalAccessException|InvocationTargetException e){ e.printStackTrace(); } StudentService ss=new StudentService(); boolean flag=ss.update(stu); if(flag){ request.setAttribute("msg","成功！"); }else{ request.setAttribute("msg","失败！"); } request.getRequestDispatcher("StudentServlet?action=show").forward(request, response); } private void update(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{ String sno=request.getParameter("sno"); StudentService ss=new StudentService(); Student stu=ss.findBySno(sno); request.setAttribute("stu", stu); request.getRequestDispatcher("studentupdate.jsp").forward(request, response); } private void del(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{ String sno=request.getParameter("sno"); StudentService ss=new StudentService(); boolean flag=ss.del(sno); if(flag){ request.setAttribute("msg","成功！"); }else{ request.setAttribute("msg","失败！"); } request.getRequestDispatcher("StudentServlet?action=show").forward(request, response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request,response); } }