Spring Boot与MyBatis的整合可以通过以下步骤实现:
1-添加MyBatis依赖
在pom.xml文件中添加MyBatis的依赖,例如:
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.4</version>
</dependency>
2-配置数据源
在application.properties或application.yml文件中配置数据源,例如:
spring.datasource.url=jdbc:mysql://localhost:3306/mydb?useSSL=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
3-创建实体类和Mapper接口
根据数据库表结构创建实体类,例如:
public class User {
private Long id;
private String name;
private Integer age;
// getters and setters
}
4-创建对应的Mapper接口,例如:
public interface UserMapper {
User getUser(Long id);
List<User> getUsers();
void insertUser(User user);
void updateUser(User user);
void deleteUser(Long id);
}
5-配置Mapper扫描路径和命名空间
在application.properties或application.yml文件中配置Mapper扫描路径和命名空间,例如:
mybatis-spring.mapper-locations=classpath:mapper/*.xml
mybatis-spring.type-aliases-package=com.example.demo.entity
6-创建Mapper XML文件和映射关系
在mapper文件夹下创建对应的XML文件,例如:userMapper.xml,并在其中定义SQL语句和映射关系,例如
<mapper namespace="com.example.demo.mapper.UserMapper">
<select id="getUser" resultType="com.example.demo.entity.User">
SELECT * FROM user WHERE id = #{id}
</select>
<select id="getUsers" resultType="com.example.demo.entity.User">
SELECT * FROM user
</select>
<insert id="insertUser">
INSERT INTO user (name, age) VALUES (#{name}, #{age})
</insert>
<update id="updateUser">
UPDATE user SET name = #{name}, age = #{age} WHERE id = #{id}
</update>
<delete id="deleteUser">
DELETE FROM user WHERE id = #{id}
</delete>
</mapper>