SpringBoot学习笔记(三)——整合Mybatis实现增删改查

继续上一篇，Springboot整合Mybatis实现增删改查，配置及目录结构参考上一篇文章，本章只展示dao-service-controller三层的业务代码。

    select * from t_user


    insert into t_user (username,password) values (#{username},#{password})


    update t_user
    
        username=#{username} where id=#{id}
    



    delete from t_user where id=#{id}

List getAll();
Integer addUser(User user);
int updateUsername(String username, Integer id);
int deleteById(int id);

2.1 编写UserService接口

List getAll();
Integer addUser(User user);
int updateUsername(String username, Integer id);
int deleteById(int id);

2.2 编写UserServiceImpl实现类

@Override
public List getAll() {
    return userMapper.getAll();
}

@Override
public Integer addUser(User user) {
    return userMapper.addUser(user);
}

@Override
public int updateUsername(String username, Integer id) {
    return userMapper.updateUsername(username, id);
}

@Override
public int deleteById(int id) {
    return userMapper.deleteById(id);
}

@RequestMapping("/getall")
@ResponseBody
public List getAllUser() {
    return  userserviceImpl.getAll();
}

@RequestMapping("/del")
@ResponseBody
public int delById(Integer id) {
    return userserviceImpl.deleteById(id);
}

@PostMapping("/update")
@ResponseBody
public int updateUsername(String username, Integer id) {
    return userserviceImpl.updateUsername(username, id);
}

@PostMapping("/add")
@ResponseBody
public Integer addUser(User user) {
    return userserviceImpl.addUser(user);
}