springmvc框架------增删改查

1、增删改查

        1.1、写一个User实体类如下所示：

@Data
public class User {
    private Integer id;
    private String name;
    private Double money;

    public User(Integer id, String name, Double money) {
        this.id = id;
        this.name = name;
        this.money = money;
    }

    public User(Integer id) {
        this.id = id;
    }

    public User() {
    }
}

1.2、在mapper文件夹下创建一个UserMapper类

代码如下所示：

@Repository("userMapper")
public interface UserMapper {
    /**
     * 查询所有
     * @return
     */
    List<User> getAllUser();

    /**
     * 删除
     * @param id
     * @return
     */
    int deleteUser(Integer id);

    /**
     * 新增
     * @param user
     * @return
     */
    int addUser(User user);

    /**
     * 修改
     * @param user
     * @return
     */
    int updateUser(User user);

    /**
     * 根据id查询
     * @param id
     * @return
     */
    User selectById(Integer id);

}

在如下图所示创建一个UserMapper.xml映射文件

关键代码如下所示：

<?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="mapper.UserMapper">
    <select id="getAllUser" resultType="User">
        select * from user
    </select>

    <delete id="deleteUser">
        delete from `user` where id=#{id}
    </delete>

    <insert id="addUser">
        insert into `user` (id,`name`,money)
        values (#{id},#{name},#{money})
    </insert>

    <update id="updateUser">
        update user set name=#{name},money=#{money}
        where id=#{id}
    </update>

    <select id="selectById" resultType="domain.User">
        select * from user where id=#{id}
    </select>
</mapper>

 1.3、在service文件夹下创建一个UserService接口和UserServiceImpl类（实现类）

代码如下所示

UserService接口：

public interface UserService {
    //查询
    List<User> getAllUser();

    //删除
    int deleteUser(Integer id);

    //新增
    int addUser(User user);

    //修改
    int updateUser(User user);

    //Id查询
    User selectById(Integer id);
}

 UserServiceImpl类：

@Service("userService")
public class UserServiceImpl implements UserService{
    @Autowired
    private UserMapper userMapper;

    @Transactional(rollbackFor = Exception.class)
    @Override
    public List<User> getAllUser() {
        return userMapper.getAllUser();
    }

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

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

    @Override
    public int updateUser(User user) {
        return userMapper.