SpringBoot整合mybatis

100 阅读1分钟

搭建框架

新建maven项目

image-20211029135141315

image-20211029135224681

添加框架支持

image-20211029135504593

image-20211029135554714

添加maven依赖

pom.xml 参考

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>cn.test</groupId>
    <artifactId>03_example</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <!-- 配置Java版本 -->
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <!-- 编码格式配置 -->
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <log4j.version>1.2.17</log4j.version>
        <mybatis.version>2.2.0</mybatis.version>
    </properties>

    <!-- 进行项目依赖版本经过一管理 -->
    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-dependencies</artifactId>
                <version>2.5.5</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>

    <dependencies>
        <!-- 支持全栈式Web开发,包括Tomcat和spring-webmvc -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!-- 支持Thymeleaf模板引擎,包括与Spring的集成 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <!-- Spring Boot的核心启动器,包含了自动配置、日志和YAML -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <!-- 数据库驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!-- 链接Spring Boot和MyBatis,构建基于Spring Boot的MyBatis应用程序。 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>${mybatis.version}</version>
        </dependency>
        <!-- 日志 -->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>${log4j.version}</version>
        </dependency>
    </dependencies>
</project>

创建包结构

image-20211029144720987

spring配置文件

resources --> application.yml

image-20211029144959182

spring:
  # ---------- 数据库配置 ----------
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/XXX?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    username: XXX
    password: XXX
# ---------- tomcat ----------
  server:
    # 服务http端口
    port: 18081
    # tomcat配置
    tomcat:
      # 最大线程数
      max-threads: 600
      # 最小线程数
      min-spare-threads: 300
      # 队列长度
      accept-count: 100
      # 最大链接数
      max-connections: 500
      #链接建立超时时间
      connection-timeout: 10000
# ---------- mybatis ----------
mybatis:
  mapper-locations:  classpath:mapper/*Mapper.xml

sql

代码

gitee.com/ban_sheng/s…

踩坑记录

  1. mapper数量要对等,不然会报错 :Caused by: java.lang.IllegalArgumentException