10.14

@Controller
public class UserController {
    @Autowired
    private IUserService userService;
    @RequestMapping("/findAll.do")
    public ModelAndView findAll(){
        List<User> users = userService.findAll();
        ModelAndView modelAndView =new ModelAndView();
        modelAndView.setViewName("allUser.jsp");
        modelAndView.addObject("users",users);
        return modelAndView;
    }
    @RequestMapping("/login1.do")
    public String login(User user){
        Boolean flag = userService.login(user.getUsername(),user.getPassword());
        if (flag){
            return "redirect:/findAll.do";
        }else {
            return "faillogin.jsp";
        }
    }
    @RequestMapping("/delete.do")
    public String delete(User user){
        userService.delete(user.getId());
        return "redirect:/findAll.do";
    }
    @RequestMapping("/update.do")
    public ModelAndView findUserById(int id){
        User user = userService.findUserById(id);
        ModelAndView modelAndView =new ModelAndView();
        modelAndView.setViewName("updateUser.jsp");
        modelAndView.addObject("user",user);
        return modelAndView;
    }
    @RequestMapping("/update2.do")
    public String update(User user){
        userService.update(user);
        return "redirect:/findAll.do";
    }
    @RequestMapping("/add.do")
    public String insert(User user){
        userService.insert(user);
        return "redirect:/findAll.do";
    }
}

@Service
public class UserService implements IUserService {
    @Autowired
    private IUserDao userDao;
    @Override
    public List<User> findAll() {
        return userDao.findAll();
    }

    @Override
    public Boolean login(String username, String password) {
        User user = userDao.Login(username);
        if (user != null && password.equals(user.getPassword())) {
            return true;
        }else {
            return false;
        }
    }

    @Override
    public void delete(int id) {
        userDao.delete(id);
    }

    @Override
    public void update(User user) {
        userDao.update(user);
    }

    @Override
    public User findUserById(int id) {
        User user = userDao.findUserById(id);
        return user;
    }

    @Override
    public void insert(User user) {
        userDao.insert(user);
    }


}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.zhongruan.dao.IUserDao">
    <select id="findAll" resultType="com.zhongruan.bean.User">
        select * from fuser
    </select>
    <select id="delete" parameterType="int">
            delete from fuser where id=#{id}
    </select>
    <select id="update" parameterType="com.zhongruan.bean.User">
        update fuser set username=#{username},password=#{password} where id=#{id}
    </select>
    <select id="insert" parameterType="com.zhongruan.bean.User">
        insert into fuser(username,password) value(#{username},#{password})
    </select>
    <select id="Login" parameterType="String" resultType="com.zhongruan.bean.User">
        select * from fuser where username=#{username}
    </select>
    <select id="findUserById" parameterType="int" resultType="com.zhongruan.bean.User">
        select * from fuser where id=#{id}
    </select>
</mapper>