通过mvc三层写出来的查询、添加、删除、修改

最新推荐文章于 2022-12-09 15:52:07 发布

liuxiangjiayou

最新推荐文章于 2022-12-09 15:52:07 发布

阅读量109

点赞数

文章标签： mvc servlet java

本文链接：https://blog.csdn.net/liuxiangjiayou/article/details/126059618

版权

该博客内容展示了如何使用Java Servlet处理HTTP请求，包括查询所有用户、删除用户、查询指定用户、更新用户信息和添加新用户的功能实现。通过HttpServletRequest和HttpServletResponse进行交互，利用ObjectMapper进行JSON转换，实现了CRUD操作。

摘要由CSDN通过智能技术生成

//查询全部
    public void queryUserAll(HttpServletRequest req, HttpServletResponse resp) throws IOException {
        List<User> users = us.findUsers();
        resp.setContentType("text/html;charset=UTF-8");
        ObjectMapper mapper = new ObjectMapper();
        String json = mapper.writeValueAsString(users);
        resp.getWriter().write(json);
    }
//删除
    public void deleteUserById(HttpServletRequest req, HttpServletResponse resp) throws IOException {
        String id = req.getParameter("id");
        int id1 = Integer.parseInt(id);
        String s = us.removeUserByID(id1);
        resp.setContentType("text/html;charset=UTF-8");
//        ObjectMapper mapper = new ObjectMapper();
//        String json = mapper.writeValueAsString(s);
        resp.getWriter().write(s);
    }

//查询
    public void queryUserById(HttpServletRequest req, HttpServletResponse resp) throws IOException {
        String id = req.getParameter("id");
        int id1 = Integer.parseInt(id);
        User user = us.findUserById(id1);
        resp.setContentType("text/html;charset=UTF-8");
        ObjectMapper mapper = new ObjectMapper();
        String json = mapper.writeValueAsString(user);
        resp.getWriter().write(json);
    }

//修改
    public void updataUserById(HttpServletRequest req, HttpServletResponse resp) throws IOException {
        String id = req.getParameter("id");
        int id1 = Integer.parseInt(id);
        String userName = req.getParameter("userName");
        String userAge = req.getParameter("userAge");
        String userSex = req.getParameter("userSex");
        String userTel = req.getParameter("userTel");
        User u = new User(id1,userName,userAge,userSex,userTel);
        System.out.println(u);
        String s = us.updateUser(u);
        resp.setContentType("text/html;charset=UTF-8");
        resp.getWriter().write(s);
    }
//添加
    public void addUser(HttpServletRequest req, HttpServletResponse resp) throws IOException {
        String userName = req.getParameter("userName");
        String userAge = req.getParameter("userAge");
        String userSex = req.getParameter("userSex");
        String userTel = req.getParameter("userTel");
        User u = new User(null,userName,userAge,userSex,userTel);
        System.out.println(u);
        String s = us.addUser(u);
        resp.setContentType("text/html;charset=UTF-8");
        resp.getWriter().write(s);
    }

    public void searchUser(HttpServletRequest req, HttpServletResponse resp) throws IOException {
        String userName = req.getParameter("userName");
        String userTel = req.getParameter("userTel");
        User u = new User();
        u.setUserTel(userTel);
        u.setUserName(userName);
        List<User> users = us.selectUsers(u);
        resp.setContentType("text/html;charset=UTF-8");
        ObjectMapper mapper = new ObjectMapper();
        String json = mapper.writeValueAsString(users);
        resp.getWriter().write(json);
    }