Web项目(二十五)项目实现代码

package com.servlet; import com.entity.User; import javax.servlet.Servlet; import java.io.IOException; import java.sql.*; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; 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; @WebServlet("/user") public class UserServlet extends HttpServlet { private static final long serialVersionUID = 1L; UserOpertion userOpertion=new UserOpertion(); @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { doPost(req, resp); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8");//解决乱码 String type=request.getParameter("method"); //新增 if("insert".equals(type)){ insert(request, response); } //登录 if("login".equals(type)){ login(request, response); } //更新 else if("update".equals(type)){ update(request, response); } //跳转到更新页面 else if("toupdate".equals(type)){ toupdate(request, response); } //跳转到删除页面 else if("delete".equals(type)){ delete(request, response); } //跳转到查询页面 else if("queryAll".equals(type)){ queryAll(request, response); } } public void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //这里jsp中name专递过来的参数 String name=request.getParameter("name"); String password=request.getParameter("password"); //把获取到的这些值放到user里 User user =new User(); user.setName(name); user.setPassword(password); //最后调用服务来添加 String message=null; if (userOpertion.queryDataByUserLogin(user)==true) { queryAll(request, response); } else { message="登录失败!!!"; request.setAttribute("msg", message); request.getRequestDispatcher("/msg.jsp").forward(request, response); } } //新增 public void insert(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //这里jsp中name专递过来的参数 String name=request.getParameter("name"); String birthday=request.getParameter("birthday"); String password=request.getParameter("password"); String email=request.getParameter("email"); String sex=request.getParameter("sex"); //把获取到的这些值放到user里 User user =new User(); try { //下面两句是把 string 转换为 sql类型的 时间格式 SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd"); user.setBirthday(new Date(sdf.parse(birthday).getTime())); } catch (ParseException e1) { e1.printStackTrace(); } user.setEmail(email); user.setName(name) ; user.setPassword(password); if ("1".equals(sex)) { user.setSex(true); } else if ("0".equals(sex)) { user.setSex(false); } //最后调用服务来添加 String message=null; if (userOpertion.insertData(user)>0) { queryAll(request, response); } else { message="新增失败!!!"; request.setAttribute("msg", message); request.getRequestDispatcher("/msg.jsp").forward(request, response); } } //修改 public void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String name=request.getParameter("name"); String birthday=request.getParameter("birthday"); String password=request.getParameter("password"); // String email=request.getParameter("email"); String sex=request.getParameter("sex"); String id=request.getParameter("id"); //把获取到的这些值放到user里 User user =new User(); try { //下面两句是把 string 转换为 sql类型的 时间格式 SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd"); user.setBirthday(new Date(sdf.parse(birthday).getTime())); } catch (ParseException e1) { e1.printStackTrace(); } user.setId(Integer.parseInt(id)); // user.setEmail(email); user.setName(name) ; user.setPassword(password); if ("1".equals(sex)) { user.setSex(true); } else if ("0".equals(sex)) { user.setSex(false); } int b= userOpertion.update(user); if (b>0) { queryAll(request, response); } else { request.setAttribute("msg", "修改失败!!"); request.getRequestDispatcher("/msg.jsp").forward(request, response); } } public void toupdate(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { User user=null; String id= request.getParameter("id"); System.out.println(id); user= userOpertion.queryDataById(Integer.parseInt(id) ); request.setAttribute("user", user); request.getRequestDispatcher("/update.jsp").forward(request, response); } //查询一条数据 public void queryById(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { User user=null; String id= request.getParameter("id"); System.out.println(id); user= userOpertion.queryDataById(Integer.parseInt(id) ); request.setAttribute("user", user); request.getRequestDispatcher("/user.jsp").forward(request, response); } //删除 public void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String id= request.getParameter("id"); System.out.println(id); int message=userOpertion.delete(Integer.parseInt(id)); if (message>0) { queryAll(request, response); } else { request.setAttribute("msg", "删除失败!!"); request.getRequestDispatcher("/msg.jsp").forward(request, response); } } //查询所有的数据 public void queryAll(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{ String username = request.getParameter("username"); List<User> list = new ArrayList<>(); if(username!=null&&!username.equals("")){ list=userOpertion.queryData(username); }else{ list=userOpertion.queryAllData(); } request.setAttribute("list", list); request.getRequestDispatcher("/user.jsp").forward(request, response); } }