MybatisPlus的更新Update

先通过id值查询User对象

    @Test
    void TestUpdate() {
        tb_user user1 = userMapper.selectById(1);
        user1.setName("李四四");
        System.out.println(user1);
        int i = userMapper.updateById(user1);
        System.out.println(i);
        System.out.println(user1);
    }

查看日志通过日志信息，首先是根据id值查询出user对象，在根据id值作为 条件修改信息，所有的信息都会更新，只是和之前一样的相当于没有修改

2021-11-21 16:15:48.320  INFO 4504 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2021-11-21 16:15:50.048  INFO 4504 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
JDBC Connection [HikariProxyConnection@1413005690 wrapping com.mysql.cj.jdbc.ConnectionImpl@b9d018b] will not be managed by Spring
==>  Preparing: SELECT user_id,psw,name FROM tb_user WHERE user_id=? 
==> Parameters: 1(Integer)
<==    Columns: user_id, psw, name
<==        Row: 1, 123, 张三
<==      Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7a4d582c]
tb_user(userId=1, name=李四四, psw=123)
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@746c411c] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@528965756 wrapping com.mysql.cj.jdbc.ConnectionImpl@b9d018b] will not be managed by Spring
==>  Preparing: UPDATE tb_user SET psw=?, name=? WHERE user_id=? 
==> Parameters: 123(String), 李四四(String), 1(Long)
<==    Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@746c411c]
1
tb_user(userId=1, name=李四四, psw=123)
2021-11-21 16:15:50.158  INFO 4504 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
2021-11-21 16:15:50.161  INFO 4504 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.

看出更新的语句：UPDATE tb_user SET psw=?, name=? WHERE user_id=? MybatisPlus自动拼接SQL语句，
再次体验到MybatisPlus的方便、简化开发。