partOne:
pom.xml中:
除了创建springboot自带的依赖之外,我们还需要添加新的依赖:
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>3.0.3</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.33</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter-test</artifactId>
<version>3.0.3</version>
<scope>test</scope>
</dependency>
partTwo:
application.properties或者application.yml中:
(当然,如果是yml格式使用者可以自行更改格式)
对数据库以及mybatis的映射文件扫描路径进行配置:
spring.datasource.url=jdbc:mysql://localhost:3306/springboot
spring.datasource.username=root
spring.datasource.password=3121384913
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
//mapper.xml文件的映射路径
//需要先在resource文件夹下创建一个名为mapper的文件夹
//mapper.xml放在mapper文件夹内部
mybatis.mapper-locations=classpath:mapper/*.xml
partThree:
对于mapper.xml(mapper映射文件)的详细配置:
<?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">
//为userMapper接口的位置
<mapper namespace="com.duan.mybatis.UserMapper.UserMapper">
//getUserById要对应自己定义的方法
//resultType为方法执行返回的结果类型
//parameterType为参数类型
<select id="getUserById" resultType="com.duan.mybatis.entrity.User" parameterType="int">
SELECT * FROM tb_customer WHERE id = #{id}
</select>
</mapper>