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

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

1、dao层

1.1 编写UserMapper.xml

<select id="getAll" resultType="com.galago.demo_web.entry.User">
    select * from t_user
</select>
<insert id="addUser" parameterType="com.galago.demo_web.entry.User">
    insert into t_user (username,password) values (#{username},#{password})
</insert>
<update id="updateUsername">
    update t_user
    <set>
        username=#{username} where id=#{id}
    </set>
</update>

<delete id="deleteById">
    delete from t_user where id=#{id}
</delete>

1.2 编写UserMapper接口

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

2、service层

2.1 编写UserService接口

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

2.2 编写UserServiceImpl实现类

@Override
public List<User> 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);
}

3、controller层

@RequestMapping("/getall")
@ResponseBody
public List<User> 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);
}

4、测试