UserController
package com.zhongruan.controller;
import com.zhongruan.bean.User; import com.zhongruan.service.IUserService; 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 IUserService userService; @RequestMapping("/login.do") public ModelAndView login(User user){ boolean flag = userService.login(user.getUsername(), user.getPassword()); ModelAndView modelAndView=new ModelAndView(); if(flag){ modelAndView.setViewName("main"); }else { modelAndView.setViewName("../failer"); } return modelAndView; } @RequestMapping("/findAll.do") public ModelAndView findAll(){ List<User> userList=userService.findAll(); ModelAndView modelAndView=new ModelAndView(); modelAndView.addObject("userList",userList); modelAndView.setViewName("user-list"); return modelAndView; } @RequestMapping("/deleteById.do") public String delete(int id){ userService.deleteById(id); return "redirect:findAll.do"; } @RequestMapping("/add.do") public String add(User user){ userService.add(user); return "redirect:findAll.do"; } @RequestMapping("/toUpdate.do") public ModelAndView toUpdate(int id){ User user=userService.selectUserById(id); ModelAndView modelAndView=new ModelAndView(); modelAndView.setViewName("user-update"); modelAndView.addObject("user",user); return modelAndView; } @RequestMapping("/Update.do") public String Update(User user){ userService.Update(user); return "redirect:findAll.do"; }}
userservlet
package com.zhongruan.service.impl;
import com.zhongruan.bean.User; import com.zhongruan.dao.UserDao; import com.zhongruan.service.IUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;
import java.util.List;
@Service public class UserService implements IUserService {
@Autowired private UserDao userDao; @Override public boolean login(String username, String password) { User user = userDao.findUserByUserName(username); if (user!=null && user.getPassword().equals(password)){ return true; } return false; } @Override public List<User> findAll() { return userDao.findAll(); } @Override public void deleteById(int id) { userDao.deleteById(id); } @Override public void add(User user) { userDao.add(user); } @Override public User selectUserById(int id) { return userDao.selectById(id); } @Override public void Update(User user) { userDao.Update(user); }}
userdao
package com.zhongruan.dao;
import com.zhongruan.bean.User;
import java.util.List;
public interface UserDao { User findUserByUserName(String username);
List<User> findAll(); void deleteById(int id); void add(User user); User selectById(int id); void Update(User user);}
usermapper.xml
<?xml version="1.0" encoding="UTF-8" ?> select * from tb_user where username=#{username} select * from tb_user delete from tb_user where id = #{id} <insert id="add" parameterType="user"> insert into tb_user(username,password) values (#{username},#{password}) </insert> <select id="selectById" parameterType="int" resultType="user"> select *from tb_user where id=#{id} </select> update tb_user set username=#{username}, password=#{password} where id= #{id}