1、pom.xml配置依赖
<!--mysql数据库驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<!-- mybatis -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.0.5</version>
</dependency>
2、链接数据库配置
#数据库账号
spring.datasource.username=root
#数据库密码
spring.datasource.password=root
#mysql驱动 aaa为数据库名称
spring.datasource.url=jdbc:mysql://localhost:3306/aaa?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
3、编写实体类对应的mapper接口
@Repository //持久层注解
public interface UserMapper extends BaseMapper<User> {
}
4、 测试
@Autowired
private UserMapper userMapper;
@Test
void contextLoads() {
List<User> userList = userMapper.selectList(null);//查询全部的用户
userList.forEach(System.out::println);
}