springboot整合mybatis

最新推荐文章于 2024-04-16 18:05:26 发布

屎壳郎推球球

最新推荐文章于 2024-04-16 18:05:26 发布

阅读量135

点赞数

分类专栏： web框架

本文链接：https://blog.csdn.net/weixin_42304484/article/details/115529472

版权

web框架专栏收录该内容

8 篇文章 0 订阅

订阅专栏

本文介绍了如何在Spring Boot应用中整合MyBatis和Druid数据源，包括配置YAML文件、启动类、数据源配置、DAO层以及测试用例。详细展示了Druid数据源的配置参数，以及Mapper接口和XML映射文件的使用。

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

工程结构

在这里插入图片描述

引入依赖

 <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.4.4</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
 <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.16</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.9</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <excludes>
                        <exclude>
                            <groupId>org.projectlombok</groupId>
                            <artifactId>lombok</artifactId>
                        </exclude>
                    </excludes>
                </configuration>
            </plugin>
        </plugins>
    </build>

启动类

启动类必须添加@MapperScan注解

@MapperScan("com.syx.dao")//接口所在的包路径
@SpringBootApplication
public class SyxwebApplication {
    public static void main(String[] args) {
        SpringApplication.run(SyxwebApplication.class, args);
    }
}

yml配置文件

server:
  port: 8080

spring:
  datasource:
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/mydb?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver

mybatis:
  mapper-locations: classpath:mapper/*Mapper.xml  #mapper文件的路径
  type-aliases-package: com.syx.syxweb.entity   #实体类的包路径

#showSql
logging:
  level:
    com:
      syx:
        dao: debug

数据源配置

package com.bpmn.config;

import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.TransactionDefinition;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import org.springframework.transaction.support.DefaultTransactionDefinition;

import javax.sql.DataSource;
import java.sql.SQLException;

@Configuration
@EnableTransactionManagement
public class DatasourceConfig{

    private Logger logger = LoggerFactory.getLogger(getClass());

    @Value("${spring.datasource.url}")
    private String dbUrl;

    @Value("${spring.datasource.username}")
    private String username;

    @Value("${spring.datasource.password}")
    private String password;

    @Value("${spring.datasource.driver-class-name}")
    private String driverClassName;
    @Bean
    @Primary
    public DataSource druidDataSource() {
        DruidDataSource datasource = new DruidDataSource();
        datasource.setUrl(dbUrl);
        datasource.setUsername(username);
        datasource.setPassword(password);
        datasource.setDriverClassName(driverClassName);
        datasource.setInitialSize(5);
        datasource.setMinIdle(5);
        datasource.setMaxActive(200);
        datasource.setMaxWait(60000);
        datasource.setTimeBetweenEvictionRunsMillis(45000);
        datasource.setValidationQuery("SELECT 1");
        datasource.setTestWhileIdle(true);
        datasource.setTestOnBorrow(true);
        datasource.setTestOnReturn(false);
        datasource.setRemoveAbandonedTimeout(3600);
        try {
            datasource.setFilters("stat");
            datasource.init();
        } catch (SQLException e) {
            logger.error("druid configuration initialization filter", e);
        }
        return datasource;
    }



    @Bean
    public SqlSessionFactory sqlSessionFactory(@Autowired DataSource datasource) throws Exception {
        final SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(datasource);
        sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/*Mapper.xml"));
        sqlSessionFactoryBean.setTypeAliasesPackage("com.bpmn.entity");

        return sqlSessionFactoryBean.getObject();
    }


    /**
     * SqlSessionTemplate类似于jdbcTemplate
     * @param sqlSessionFactory
     * @return
     */
    @Bean
    public SqlSessionTemplate sqlSessionTemplate(@Autowired SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }


    /**
     * 编程式事务
     */
    @Bean(name="transactionManager")
    public DataSourceTransactionManager dataSourceTransactionManager(@Autowired DataSource dataSource){
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name="transactionDefinition")
    public DefaultTransactionDefinition  transactionDefinition(){
        DefaultTransactionDefinition definition = new DefaultTransactionDefinition();
        definition.setName("transactionDefinition");
        //如果当前存在事务，则加入该事务；如果当前没有事务，则创建一个新的事务。这是默认值。
        definition.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
        return definition;
    }

}

dao层

package com.syx.dao;

import com.syx.entity.User;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface UserDao {
    List<User> findAll();

    User findById(@Param("id") String id);
}

dao对应的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">
<mapper namespace="com.syx.dao.UserDao">

    <resultMap id="UserResultMap" type="com.syx.entity.User">
        <result column="id" jdbcType="VARCHAR" property="id" />
        <result column="username" jdbcType="VARCHAR" property="username" />
        <result column="sex" jdbcType="VARCHAR" property="sex" />
    </resultMap>
    <select id="findAll" resultMap="UserResultMap">
        select * from user
    </select>


    <select id="findById"  resultMap="UserResultMap">
        SELECT id,username,sex FROM user
        <where>
            id =#{id}
        </where>
    </select>

</mapper>

测试

package com.syx;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidPooledConnection;
import com.syx.dao.UserDao;
import com.syx.entity.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.context.ApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.TransactionCallback;
import org.springframework.transaction.support.TransactionTemplate;

import javax.sql.DataSource;
import javax.sql.PooledConnection;
import java.sql.SQLException;
import java.util.Set;

@SpringBootTest
class SyxwebApplicationTests {

    @Autowired
    UserDao userDao;

    @Test
    public void contextLoads() {
        userDao.findAll().forEach(System.out::println);
    }


    @Test
    public void fun1() {
        User user = userDao.findById("1");

        System.out.println(user);

    }


/**
*下面是测试jdbcTemplate的事务是否成功（可以不用管）
*/

    @Autowired
    JdbcTemplate jdbcTemplate;

    @Test
    public void fun2() throws SQLException {
        jdbcTemplate.queryForList("select * from user").forEach(e -> {
            System.out.println(e);
        });
    }


    @Autowired
    TransactionTemplate transactionTemplate;

    @Test
    public void fun3() {
        String sql1 = "INSERT INTO USER(id,username,sex) VALUES ('1','張三','男')";

        String sql2 = "INSERT INTO USER(id,username,sex) VALUES ('1','里斯','男')";


        String sql3 = "update user set sex = '女' where id = '2'";

        String sql4 = "delete from user";
        transactionTemplate.execute((transactionStatus) -> {
            try {
                transactionStatus.createSavepoint();
                jdbcTemplate.update(sql4);
                jdbcTemplate.batchUpdate(new String[]{sql1,sql2});
            } catch (Throwable e) {
                e.printStackTrace();
                transactionStatus.setRollbackOnly();
            }
            return null;
        });
//        for (int i = 0; i < 10000; i++) {
//
//        }



        jdbcTemplate.queryForList("select * from USER ").forEach(e->{
            System.out.println(e);
        });

    }
}