mybatis plus 乐观锁

太过爱你忘了你带给我的痛 2024-04-19 08:16 42阅读 0赞

github地址[https://github.com/heng1234/mybatis\_plus][https_github.com_heng1234_mybatis_plus]

基于 [https://blog.csdn.net/qq\_39313596/article/details/100836664][https_blog.csdn.net_qq_39313596_article_details_100836664] 文章

在MybatisPlusConfig 加入乐观锁插件

/**
         * 乐观锁插件
         * @return
         */
        @Bean
        public OptimisticLockerInterceptor optimisticLockerInterceptor(){
            return new OptimisticLockerInterceptor();
        }

实体类 乐观锁字段加入@Version注解

/**
         * 版本
         */
        @Version
        private Integer version;

测试类

package com.hlvy.mybatis_plus.userTest;
    
    import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
    import com.baomidou.mybatisplus.core.toolkit.Wrappers;
    import com.hlvy.mybatis_plus.entity.User;
    import com.hlvy.mybatis_plus.mapper.UserMapper;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.test.context.junit4.SpringRunner;
    
    /**
     * UserTestNew
     * mp进阶 乐观锁
     * @author heng
     * @date 2019/4/11
     **/
    @RunWith(SpringRunner.class)
    @SpringBootTest
    public class OptTest {
    
        @Autowired
        private UserMapper userMapper;
    
    
        /**
         * 修改 乐观锁
         * 执行sql UPDATE User SET age=17, update_time='2019-09-15 11:35:01.144', version=2 WHERE id=5 AND version=1 AND deleted=0
         */
          @Test
        public void updateOne() {
            int vsrsion = 1;
            User user = new User();
            user.setId(5L);
            user.setAge(17);
            user.setVersion(vsrsion);
            System.out.println(userMapper.updateById(user));
        }
    
        /**
         * 乐观锁 queryWrapper对象不能复用 会导致条件出错
         * sql UPDATE User SET age=17, update_time='2019-09-15 11:42:33.317', version=3 WHERE deleted=0 AND id = 3 AND version = 2
         */
        @Test
        public void updateTwo() {
            int vsrsion = 2;
            User user = new User();
            user.setAge(17);
            user.setVersion(vsrsion);
            QueryWrapper<User> queryWrapper = Wrappers.<User>query();
            queryWrapper.eq("id",3);
            System.out.println(userMapper.update(user,queryWrapper));
            /**
             * 下面是复用代码示例  不能复用
             *  sql UPDATE User SET age=19, update_time='2019-09-15 11:42:33.317', version=4 WHERE deleted=0 AND id = 3 AND version = 2 AND id = 3 AND version = 3
             */
          /*  user.setVersion(3);
            user.setAge(19);
            queryWrapper.eq("id",3);
            System.out.println(userMapper.update(user,queryWrapper));*/
        }
    
    
    
    }

[https_github.com_heng1234_mybatis_plus]: https://github.com/heng1234/mybatis_plus
[https_blog.csdn.net_qq_39313596_article_details_100836664]: https://blog.csdn.net/qq_39313596/article/details/100836664