ssm列表,删除和增加实现

    技术2022-07-21  147

    在上次框架上修改UserMapper.xml,新增代码

    <delete id="deleteById" parameterType="Integer"> delete from user where id=#{id} </delete> <insert id="add" parameterType="User"> insert into user(name,password) values(#{name},#{password}) </insert> <select id="findAll" resultType="User"> select * from user </select>

    修改UserDao

    public interface UserDao { User findUserByName(String name); List<User> findAll(); int deleteById(Integer id); int add(User user); }

    修改UserService

    public interface UserService { boolean login(String name,String password); boolean delete(Integer id); List<User> findAll(); boolean add(String name, String password); }

    修改UserController

    package com.zr0707.controller; import com.zr0707.bean.User; import com.zr0707.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView; import java.util.List; @Controller @RequestMapping("/user") public class UserController { @Autowired private UserService userService; @RequestMapping("/login.do") public ModelAndView login(User user){ boolean flag=userService.login(user.getName(),user.getPassword()); ModelAndView modelAndView=new ModelAndView(); if(flag){ modelAndView.setViewName("../ok"); }else { modelAndView.setViewName("../failure"); } return modelAndView; } @RequestMapping("/findAll.do") public ModelAndView findAll(){ ModelAndView modelAndView=new ModelAndView(); List<User> userList=userService.findAll(); modelAndView.addObject("userList",userList); modelAndView.setViewName("../main"); return modelAndView; } @RequestMapping("/delete.do") public String delete(int id){ boolean del=userService.delete(id); if(del){ return "redirect:findAll.do"; } return "../failure"; } @RequestMapping("/insert.do") public ModelAndView insert(User user){ boolean flag=userService.add(user.getName(),user.getPassword()); ModelAndView modelAndView=new ModelAndView(); if (flag){ modelAndView.setViewName("../ok"); }else { modelAndView.setViewName("../failure"); } return modelAndView; } }

    修改UserServiceImpl

    package com.zr0707.service.Impl; import com.zr0707.bean.User; import com.zr0707.dao.UserDao; import com.zr0707.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Service public class UserServiceImpl implements UserService { @Autowired private UserDao userDao; @Override public boolean login(String name, String password) { User user=userDao.findUserByName(name); if (user!=null&&user.getPassword().equals(password)){ return true; } return false; } @Override public boolean delete(Integer id) { int del=userDao.deleteById(id); if (del>0){ return true; } return false; } @Override public List<User> findAll() { return userDao.findAll(); } @Override public boolean add(String name, String password) { User user=new User(); user.setName(name); user.setPassword(password); int insert=userDao.add(user); if (insert>0){ return true; } return false; } }

    新建main.jsp页面

    <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%-- Created by IntelliJ IDEA. User: 赵 Date: 2020/7/2 Time: 9:22 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>列表</title> </head> <body> <div> <table> <thead> <tr> <th>ID</th> <th>用户名</th> <th>密码</th> <th>操作</th> </tr> </thead> <tbody> <c:forEach items="${userList}" var="user"> <tr> <td>${user.id}</td> <td>${user.name}</td> <td>${user.password}</td> <td> <a href="${pageContext.request.contextPath}/user/delete.do?id=${user.id}">删除</a> </td> </tr> </c:forEach> </tbody> </table> </div> </body> </html>

    新建add.jsp页面

    <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>添加</title> </head> <body> <form action="/user/insert.do" method="post"> name:<input name="name" type="text"> password:<input name="password" type="text"> <input type="submit" value="add"> </form> </body> </html>

    数据库内容 实现效果 点击删除

    添加功能 添加成功跳转到成功页面,数据库信息增加

    Processed: 0.015, SQL: 9