1.引入依赖
<!-- mybatis-plus--> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.4.0</version> </dependency>
2.编写配置文件
# 数据源环境
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql:///javatest?serverTimezone=UTC
username: root
password: 123456
# profiles:
# active: dev # 分支配置
mybatis:
mapper-locations: classpath:mapper/*.xml # mapper文件位置设置
type-aliases-package: cn.kgc.springboot.springboot.entity #类的别名设置
configuration:
map-underscore-to-camel-case: true # 开启驼峰命名
logging:
level:
root: info # 全局的日志级别
cn.kgc.springboot.mapper: debug # 设置包的日志等级 debug
3.编写Mapper 文件 继承BaseMapper类
package cn.kgc.springboot.springboot.mapper;
import cn.kgc.springboot.springboot.entity.SysUser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.catalina.User;
/*
@author peng
@date20/7/2022
*/
public interface UserMapper extends BaseMapper<SysUser> {
}
4.测试
package cn.kgc.springboot.springboot;
import cn.kgc.springboot.springboot.entity.SysUser;
import cn.kgc.springboot.springboot.mapper.UserMapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.util.List;
@SpringBootTest
class Springboot02ApplicationTests {
@Autowired
private UserMapper userMapper;
@Test
void contextLoads() {
List<SysUser> sysUsers = userMapper.selectList(null);
sysUsers.forEach(sysUser -> System.out.println("sysUser = " + sysUser));
}
}
5.运行结果