mybatis+mysql获取新增后数据的id值

最新推荐文章于 2023-12-16 21:15:12 发布

该用户已被封禁无法显示

最新推荐文章于 2023-12-16 21:15:12 发布

阅读量296

点赞数

文章标签： mybatis mysql java

本文链接：https://blog.csdn.net/weixin_45810161/article/details/130098190

版权

1.xml配置

    <insert id="insertIdTest" useGeneratedKeys="true" keyProperty="id" parameterType="com.xiaoantimes.dto.User">
        INSERT INTO tb_vedio
            (`user_id`,`play_time`)
        VALUES
            (#{userId},#{playTime})
    </insert>

2.user配置

public class User {

    private Integer id;
    private String userId;
    private String playTime;

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", userId='" + userId + '\'' +
                ", playTime='" + playTime + '\'' +
                '}';
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUserId() {
        return userId;
    }

    public void setUserId(String userId) {
        this.userId = userId;
    }

    public String getPlayTime() {
        return playTime;
    }

    public void setPlayTime(String playTime) {
        this.playTime = playTime;
    }
}

3.mapper配置

int insertIdTest(User user);

4.service配置

@Override
    public int addPlayTime(String userId, String playTime) {
        User user = new User();
        user.setUserId(userId);
        user.setPlayTime(playTime);
//        int addFlag = testMapper.addPlayTime(user);
//        Integer id = user.getId();

        //testMapper.insert(user);

        //int id = testMapper.insertOnePlayer2(user);
        //Integer id = user.getId();
        /*Integer id1 = user.getId();
        System.out.println(id1);*/
        int id = testMapper.insertIdTest(user);
        System.out.println("新增后的id:"+user.getId());
        return id;
    }

5.controller配置

  @RequestMapping("/addPlayTime")
    public String addPlayTime(String userId,String playTime){
        if (userId == null){
            return "userId为空";
        }
        if (playTime == null){
            return "playTime为空";
        }
        int addFlag = testService.addPlayTime(userId,playTime);
        System.out.println("添加标志:"+addFlag);
        return "添加成功:"+addFlag;
    }