<dependencies> <!--web功能的springboot --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!--数据库驱动 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <!--JavaBean的属性get.set生成器 --> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </dependency> <!--SpringBoot自动配置mybatis-plus的默认配置 --> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.3.2</version> </dependency> <!--SpringBoot热加载 --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-devtools</artifactId> </dependency> <!--SpringBoot单元测试 --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> <exclusions> <exclusion> <groupId>org.junit.vintage</groupId> <artifactId>junit-vintage-engine</artifactId> </exclusion> </exclusions> </dependency> </dependencies>
spring:
application:
name: mybatisplusStudy
datasource:
data-password: root
password: root
username: 123456
url: jdbc:mysql://localhost:3306/interview?serverTimezone=UTC&useSSL=false
driver-class-name: com.mysql.cj.jdbc.Driver
server:
servlet:
context-path: /mybatisplus
port: 80
mybatis-plus:
# mapper文件的位置
mapper-locations: classpath:/mappers/*Mapper.xml
# 哪个包下的类名可以在mapper文件中不用写全限定名，写类名即可
type-aliases-package: top.linruchang.mybatisplusstudy.dto
configuration:
# 默认true - 数据库字段名 与 JavaBean属性名的对应关系
# 查询数据库时
# 1. true 数据库字段名中的下划线去掉并toUpperCase = JavaBean属性名.toUpperCase
# 2. false 数据库字段名.toUpperCase = JavaBean属性名.toUpperCase
# update、set数据库时
# 1. true 只要是驼峰的JavaBean字段，会将驼峰的大写字母 变成 _小写字母
# 2. false 数据库字段 = JavaBean属性字段
map-underscore-to-camel-case: false
#打印SQL日志
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
global-config:
db-config:
# @FieldId 默认类型为自增长
id-type: auto
# @TableName如果要使用需要设置@TableName的属性是keepGlobalPrefix为true
table-prefix: test_
@Configuration
public class MyConfig {
@Bean
public PaginationInterceptor getPaginationInterceptor() {
return new PaginationInterceptor();
}
}
@Data
public class BaseDTO {
@TableId(type=IdType.AUTO)
Integer id;
}
@TableName("class_type")
@Data
@Builder
public class ClassType extends BaseDTO {
@TableField("classNo")
Integer classNo;
@TableField("description")
String description;
}
@Mapper
public interface ClassTypeDao extends BaseMapper<ClassType>{
}
@SpringBootTest
class SpringbootMybatisplusApplicationTests {
@Autowired
ClassTypeDao classTypeDao;
@Test
public void test2() {
IPage<ClassType> classTypeIPage = classTypeDao.selectPage(new Page<>(1, 1), new QueryWrapper<ClassType>().gt("id", 0));
List<ClassType> records = classTypeIPage.getRecords();
records.forEach(System.out::println);
}
}
@Component
@Slf4j
public class MyMetaObjectHandler implements MetaObjectHandler {
@Override
public void insertFill(MetaObject metaObject) {
log.info("插入操作。。。。。。。。。。。。");
this.setInsertFieldValByName("updateTime", new Date(), metaObject);
this.setInsertFieldValByName("createTime", new Date(), metaObject);
}
@Override
public void updateFill(MetaObject metaObject) {
log.info("更新操作。。。。。。。。。。。。");
this.setInsertFieldValByName("updateTime", new Date(), metaObject);
}
}
@TableName("student")
@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class Student extends BaseDTO {
@TableField("name")
String name;
@TableField("sport")
String sport;
//FieldFill.DEFAULT默认填充不进行处理
@TableField(value="create_time", fill = FieldFill.INSERT)
Date createTime;
@TableField(value="update_time", fill = FieldFill.INSERT_UPDATE)
Date updateTime;
}
@Test
public void test7() {
Student student = new Student();
student.setId("fbc629c6703f0d8188476feb33c1f41f");
student.setName("ewoi");
student.setSport("8764431");
int flag = studentDao.updateById(student);
System.out.println(flag);
}
@Configuration
@EnableTransactionManagement
public class MyConfig {
@Bean
public OptimisticLockerInterceptor getOptimisticLockerInterceptor() {
return new OptimisticLockerInterceptor();
}
}
@Data
public class BaseDTO {
@TableId(type=IdType.UUID)
String id;
//乐观锁注解开启
@Version
Integer version;
}
@TableName("student")
@Data
@ToString(callSuper=true)
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class Student extends BaseDTO {
@TableField("name")
String name;
@TableField("sport")
String sport;
@TableField(value="create_time", fill = FieldFill.INSERT)
Date createTime;
@TableField(value="update_time", fill = FieldFill.INSERT_UPDATE)
Date updateTime;
}
@Test
public void test8() {
Student student = studentDao.selectById("fsfsd");
System.out.println(student);
student.setSport("做爱做的侍寝111");
studentDao.updateById(student);
student = studentDao.selectById("fsfsd");
System.out.println(student);
}