微服务 day7

Thymeleaf与Mybatis集成教程

最新推荐文章于 2025-07-31 12:54:26 发布

原创最新推荐文章于 2025-07-31 12:54:26 发布 · 264 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Spring Boot

微服务专栏收录该内容

5 篇文章

订阅专栏

thymeleaf模板

在这里插入图片描述
这样就可以创建，打开pom.xml,增加一个依赖,可以使用非严格的html格式

        <dependency>
            <groupId>net.sourceforge.nekohtml</groupId>
            <artifactId>nekohtml</artifactId>
            <version>1.9.22</version>
        </dependency>

然后创建一个Controller，在创建一个类
在这里插入图片描述

package com.mysheep.spring.boot.thymeleaf.controller;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

@Controller
public class MainController {
    @RequestMapping(value = {"","index"})
    public String main(Model model){
        return "index";
    }
}

再创建一个index.html
在这里插入图片描述

<html>
<head>
    <title></title>
</head>

<body>

    <table>
        <tr>
            <td>张三</td>
            <td>23</td>
            <td>男</td>
        </tr>
        <tr>
            <td>李四</td>
            <td>25</td>
            <td>男</td>
        </tr>
    </table>
</body>
</html>

编写application.yml

spring: 
  thymeleaf: 
    cache: false
    mode: LEGACYHTML5
    encoding: UTF-8
    content-type: text/html

访问localhost：8080就能访问到index.html

集成Mybatis

继承Druid，注入依赖

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.20</version>
        </dependency>

修改application.yml

spring:
  datasource:
    druid:
      url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
      username: root
      password:
      initial-size: 1
      min-idle: 1
      max-active: 20
      test-on-borrow: true
      driver-class-name: com.mysql.jdbc.Driver

集成tk.mybatis

注入依赖

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>1.1.5</version>
        </dependency>

修改application.yml

spring:
  datasource:
    druid:
      url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
      username: root
      password:
      initial-size: 1
      min-idle: 1
      max-active: 20
      test-on-borrow: true
      driver-class-name: com.mysql.jdbc.Driver

mybatis:
  type-aliases-package: com.mysheep.spring.boot.thymeleaf.domain
  mapper-locations: classpath:mapper/*.xml

创建一个MyMapper.java
在这里插入图片描述

package com.mysheep.spring.boot.utils;

import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.common.MySqlMapper;

public interface MyMapper<T> extends Mapper<T>, MySqlMapper<T> {
}

集成pageHelper

注入依赖

        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.3</version>
        </dependency>

Mybatis Maven Plugin自动生成代码

修改pom.xml

            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.5</version>
                <configuration>
                    <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
                    <overwrite>true</overwrite>
                    <verbose>true</verbose>
                </configuration>
                <dependencies>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>${mysql.version}</version>
                    </dependency>
                    <dependency>
                        <groupId>tk.mybatis</groupId>
                        <artifactId>mapper</artifactId>
                        <version>3.4.4</version>
                    </dependency>
                </dependencies>
            </plugin>

新建配置文件，generatorConfig.xml
在这里插入图片描述

<!DOCTYPE generatorConfiguration
        PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
    <properties resource="jdbc.properties"/>

    <context id="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat">
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>

        <plugin type="tk.mybatis.mapper.generator.MapperPlugin">
            <property name="mappers" value="com.mysheep.spring.boot.utils.MyMapper"/>
        </plugin>

        <jdbcConnection
            driverClass="${jdbc.driverClass}"
            connectionURL="${jdbc.connectionURL}"
            userId="${jdbc.username}"
            password="${jdbc.password}">
        </jdbcConnection>

        <javaModelGenerator targetPackage="com.mysheep.spring.boot.thymeleaf.domain" targetProject="src/main/java"/>

        <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/>

        <javaClientGenerator
            targetPackage="com.mysheep.spring.boot.thymeleaf.mapper"
            targetProject="src/main/java"
            type="XMLMAPPER"/>

        <table tableName="%">
            <generatedKey column="id" sqlStatement="Mysql" identity="true"/>
        </table>
    </context>
</generatorConfiguration>

然后配置数据源，jdbc.properties

jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.connectionURL=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
jdbc.username=root
jdbc.password=

然后自动生成代码
在这里插入图片描述