mybatis配置(XML方式)
导入依赖
<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 {
public List<Account> queryList();
}
在mapper中配置xml信息(查询语句、对应方法、返回类型)
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.MyController.mapper.UserMapper">
<select id = "queryList" resultType = "account">
select * from account where id =1;
</select>
</mapper>
在配置文件中配置环境扫描包
mybatis.type-aliases-package=com.MyController.entity
mybatis.mapper-locations=classpath:mapper/*Mapper.xml
创建类测试
@Autowired
private UserMapper userMapper;
@RequestMapping("/query")
@ResponseBody
public List<Account> queryList(){
List<Account> accounts = userMapper.queryList();
return accounts;
}