1.引入Maven 配置
<dependencies>
<dependency>
<groupId>com.mybatis-flex</groupId>
<artifactId>mybatis-flex-spring-boot-starter</artifactId>
<version>1.9.7</version>
</dependency>
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP</artifactId>
</dependency>
<!-- for test only -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
2.对 Spring Boot 项目进行配置
在 application.yml 中配置数据源:
# DataSource Config
spring:
datasource:
url: jdbc:mysql://具体数据库ip地址:3306/flex_test
username: 数据库账号
password: 数据库密码
3.使用MapperScan 扫描mapper类
@SpringBootApplication
@MapperScan("com.cat.book.mapper")
public class BookAppApplication {
public static void main(String[] args) {
SpringApplication.run(BookAppApplication.class,args);
}
}
4.进行测试 新建一个实体类
@Data
@Table("users")
public class Users{
/**
*
*/
private String username;
/**
*
*/
private String password;
/**
*
*/
private Integer enabled;
}
新建mapper类
public interface UsersMapper extends BaseMapper<Users> {
}
测试类
@SpringBootTest
public class MybatisFlexTestApplicationTests {
@Resource
private UsersMapper usersMapper;
@Test
public void contextLoads() {
QueryWrapper wrapper = new QueryWrapper().eq(Users::getUsername, "zhangsan");
Users users = usersMapper.selectOneByQuery(wrapper);
System.out.println(users);
}
}