SpringBoot整合MyBatis

最新推荐文章于 2024-10-02 06:14:43 发布

克利斯朵夫李伟

最新推荐文章于 2024-10-02 06:14:43 发布

阅读量97

点赞数

分类专栏： SpringBoot MySQL 文章标签： mybatis mysql spring boot spring

本文链接：https://blog.csdn.net/qq_37618154/article/details/116054445

版权

MySQL 同时被 2 个专栏收录

7 篇文章 0 订阅

订阅专栏

SpringBoot

2 篇文章 0 订阅

订阅专栏

该博客介绍了如何在SpringBoot项目中整合MyBatis，包括添加相关依赖、配置数据库连接、设置MyBatis属性，创建User实体类、UserMapper接口及对应的mapper.xml文件，最后展示了Service层的实现和测试类的编写，实现了数据的查询操作。

摘要由CSDN通过智能技术生成

SpringBoot整合MyBatis

1. 导入依赖

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>

<!--SprintBoot依赖-->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-devtools</artifactId>
    <scope>runtime</scope>
    <optional>true</optional>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
    <exclusions>
        <exclusion>
            <groupId>org.junit.vintage</groupId>
            <artifactId>junit-vintage-engine</artifactId>
        </exclusion>
    </exclusions>
</dependency>

<!--MySQL和MyBatis依赖-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.23</version>
</dependency>
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.0.1</version>
</dependency>

2. properties配置文件

# DataSourceProperties
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf-8&useSSL=false&serverTimezone=Hongkong
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.hikari.maximum-pool-size=15
spring.datasource.hikari.minimum-idle=5
spring.datasource.hikari.idle-timeout=30000

# MybatisProperties
mybatis.mapper-locations=classpath:mapper/*.xml
mybatis.type-aliases-package=com.example.springbootshiro.entity
# 自动生成主键id
mybatis.configuration.useGeneratedKeys=true
# 不区分大小写
mybatis.configuration.mapUnderscoreToCamelCase=true

3. 用户数据库和对应的实体类

public class User {
    int id;
    String username;
    String password;
}

4. 创建dao层

@Mapper
public interface UserMapper {
    List<User> selectAllUser();
}

5. 创建dao层对应的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.example.springbootshiro.dao.UserMapper">
    <select id="selectAllUser" resultType="User">
        select id,username,password
        from user
    </select>
</mapper>

6. 创建service层

@Service
public class UserService {

    @Autowired
    private UserMapper userMapper;

    public List<User> findAllUser(){
        List<User> users = userMapper.selectAllUser();
        return users;
    }
}

7. 创建测试类

@RunWith(SpringRunner.class)
@SpringBootTest
@ContextConfiguration(classes = SpringbootshiroApplication.class)
public class SQLTests {

    @Autowired
    private UserMapper userMapper;

    @Test
    public void testMyBatis(){
         List<User> allUser = userMapper.selectAllUser();
         allUser.forEach(System.out::println);
    }
}