mybatis配置 (注解版)
导入依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
在配置文件中配置数据库信息
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/spring?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=983626hu
创建对应的实体类
创建对应的方法接口 注:标注 @Mapper
@Mapper
public interface UserMapper {
@Select("此处填写sql语句")
public List<Account> queryList();
}
创建类测试
@Autowired
private UserMapper userMapper;
@RequestMapping("/query")
@ResponseBody
public List<Account> queryList(){
List<Account> accounts = userMapper.queryList();
return accounts;
}