- 导入mybatis官方starter
- 编写mapper接口。标准@Mapper注解com.liang.webadmin.mapper.AccountMapper
- 编写实现接口类。com.liang.webadmin.service.AccountService
- 编写sql映射文件并绑定mapper接口mybatis/mapper/AccountMapper.xml
- 在application.yaml中指定Mapper配置文件的位置,以及指定全局配置文件的信息 (建议;配置在mybatis.configuration)resources\application.yaml
1.导入mybatis官方starter
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.4</version>
</dependency>
- 编写mapper接口。标准@Mapper注解[^2]com.liang.webadmin.mapper.AccountMapper
import com.liang.webadmin.bean.Account;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface AccountMapper {
public Account getAcct(Long id);
}
- 编写实现接口类。[^3]com.liang.webadmin.service.AccountService
import com.liang.webadmin.bean.Account;
import com.liang.webadmin.mapper.AccountMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class AccountService {
@Autowired
AccountMapper accountMapper;
public Account getAcctByid(Long id){
return accountMapper.getAcct(id);
};
}
- 编写sql映射文件并绑定mapper接口[^4]mybatis/mapper/AccountMapper.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.liang.webadmin.mapper.AccountMapper">
<!-- public Account getAcct(Long id); -->
<select id="getAcct" resultType="com.liang.webadmin.bean.Account">
select * from user where id=#{id}
</select>
<!-- -->
</mapper>
- 在application.yaml中指定Mapper配置文件的位置,以及指定全局配置文件的信息 (建议;配置在mybatis.configuration)[^5]resources\application.yaml
# 配置mybatis规则
mybatis:
# config-location: classpath:mybatis/mybatis-config.xml
mapper-locations: classpath:mybatis/mapper/*.xml
configuration:
map-underscore-to-camel-case: true
#可以不写全局;配置文件,所有全局配置文件的配置都放在configuration配置项中即可