用SSM架构实现删除，更新，模糊查询功能

用SSM架构实现删除，更新，模糊查询功能

注：所有List后面都要加<User>

删除

Dao
//删除用户
void deleteUser(int id);

Service
//删除用户
void deleteUser(int id);

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

Control
@RequestMapping("/deleteUser")
public String deleteUser(int id){
userService.deleteUser(id);
return “redirect:findAllUser.do”;
}

Mapper

delete from tb_user where id=#{id}

更新

Dao
//更新前的查询
User findUpdUser(int id);
//更新
void updateUser(User user);

Service
//更新前的查询
User findUpdUser(int id);
//更新
void updateUser(User user);

ServiceImpl
@Override
public User findUpdUser(int id) {
return userDao.findUpdUser(id);
}

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

Control
@RequestMapping("/findUpdUser")
public ModelAndView findUpdUser(int id){
User user=userService.findUpdUser(id);
ModelAndView mv=new ModelAndView();
mv.addObject(“user”,user);
mv.setViewName(“user-update”);
return mv;
}
@RequestMapping("/updateUser")
public String updateUser(User user){
userService.updateUser(user);
return “redirect:findAllUser.do”;
}

Mapper

select * from tb_user where id=#{id}


update tb_user set username=#{username},password=#{password} where id=#{id}

模糊查询

Dao
//模糊查询
List searchUser(String username);

Service
//模糊查询
List searchUser(String username);

ServiceImpl
@Override
public List searchUser(String username) {
return userDao.searchUser(username);
}

Control
@RequestMapping("/searchUser")
public ModelAndView searchUser(String username){
List users=userService.searchUser(username);
ModelAndView mv=new ModelAndView();
mv.addObject(“userList”,users);
mv.setViewName(“user-list”);
return mv;
}

Mapper

select * from tb_user where username like CONCAT(CONCAT(’%’, #{username}), ‘%’)