原来配置:
1.数据库表
2.实体类
import com.baomidou.mybatisplus.annotation.*;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.util.Date;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
//对应数据库主键(uuid、自增id、雪花算法、redis、zookeeper!)
@TableId(type = IdType.AUTO)
private Long id;
private String name;
private Integer age;
@Version //乐观锁version
private Integer version;
@TableField(fill= FieldFill.INSERT)
private Date create_time;
@TableField(fill=FieldFill.INSERT_UPDATE)
private Date update_time;
}
3.查询测试最终结果
@Test
public void testSelectUser(){
User user = userMapper.selectById(3L);
System.out.println(user);
}
//控制台输出结果
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@720a1fd0] was not registered for synchronization because synchronization is not active
JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@7548e1fb] will not be managed by Spring
==> Preparing: SELECT id,name,age,version,create_time,update_time FROM user WHERE id=?
==> Parameters: 3(Long)
<== Columns: id, name, age, version, create_time, update_time
<== Row: 3, 1, 1, 1, 2021-05-27 15:50:16, 2021-05-27 15:50:16
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@720a1fd0]
User(id=3, name=1, age=1, version=1, create_time=null, update_time=null)
create_time、update_time 取值为null,是因为实体类中这两个属性未按照驼峰命名法命名,
实体类中需更改为createTime、updateTime即可