springboot 集成 mybaits+ H2 DaTaBase

博主： literature
发布时间：2023 年 10 月 05 日
149 次浏览
关闭评论
4346字数
分类：主机教程

记录一次 `springboot` 集成 `mybaits` + `H2 DaTaBase`

　pom.xml



    4.0.0

    com.dnslin
    dnslin_bot
    1.0-SNAPSHOT

    
    
        org.springframework.boot
        spring-boot-starter-parent
        2.5.0
         
    


    
        8
        8
        1.8
    

    

        
            
            
                love.forte.simple-robot
                parent
                2.2.1
                import
                pom
            
        
    


    
        
        
            love.forte.simple-robot
            component-mirai-spring-boot-starter

        


        
        
            org.springframework.boot
            spring-boot-starter-logging
        


        
        
        
        
        
        
        
        
            org.springframework.boot
            spring-boot-devtools
            
            true
        

        
        
            org.springframework.boot
            spring-boot-starter-test
            test
            
                
                    org.junit.vintage
                    junit-vintage-engine
                
            
        

        
        
            com.h2database
            h2
            1.4.200
        


        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.1.0
        

        
        
            org.projectlombok
            lombok
            1.18.2
        

        
        
            cn.hutool
            hutool-all
            5.7.13
        

        
        
            org.jsoup
            jsoup
            1.11.3
        

        
        
            com.fasterxml.jackson.core
            jackson-databind
            2.12.3
        

        
        
            org.apache.httpcomponents
            httpclient
            4.5.13
        

        
        
            org.apache.poi
            poi-ooxml
            4.1.2
        

        
            org.springframework.boot
            spring-boot-starter-web
        
    

    
        
            
            
                org.springframework.boot
                spring-boot-maven-plugin
                
                    
                        
                            org.project.lombok
                            lombok
                        
                    
                
            
            
                org.mybatis.generator
                mybatis-generator-maven-plugin
                1.3.2
                
                    
                    
                        com.h2database
                        h2
                        1.4.200
                    
                
                
                    
                    ${basedir}/src/main/resources/generatorConfig.xml
                    true

config.properties

jdbc.driverClass=org.h2.Driver
jdbc.url=jdbc:h2:mem:address;MODE=MySQL
jdbc.user=root
jdbc.password=root123

group.package=com.dnslin.dnslin_bot
catalog.name=address

generatorConfig.xml

　application.yml

simbot:
  core:
    # 扫描 simbot-bots目录下的所有 .bot 文件。
    bot-resource-type: RESOURCE_FIRST
  component:
    mirai:
      # 如果不为空，此处代表指定一个 deviceInfo 的 json文件路径。
      deviceInfo-file: src/main/resources/device.json
spring:
  # 热部署
  devtools:
    restart:
      additional-paths: src/main/java
  # 数据源
  datasource:
    driver-class-name: org.h2.Driver
    schema: classpath:db/schema.sql
#    data: classpath:db/addressAll.sql
    url: jdbc:h2:mem:address;MODE=MySQL
    username: root
    password: root123
  h2:
    console:
      enabled: true
      path: /h2
      settings:
        trace: true
        web-allow-others: true
#  配置mybatis:
mybatis:
  mapper-locations: classpath:mapper/*.xml
  configuration:
    map-underscore-to-camel-case: true

# 日志
logging:
  level:
    love.forte.simbot: debug
    com.dnslin.dnslin_bot: debug

最后修改：2023 年 10 月 05 日

如果觉得我的文章对你有用，请随意赞赏

此处评论已关闭

springboot 集成 mybaits+ H2 DaTaBase

literature • 2023 年 10 月 05 日

<div class="tip share">请注意，本文编写于 307 天前，最后修改于 307 天前，其中某些信息可能已经过时。</div><h3>记录一次<code> springboot </code>集成 <code>mybaits</code> + <code>H2 DaTaBase</code></h3><h5>　pom.xml</h5><pre><code class="lang-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>com.dnslin</groupId>
    <artifactId>dnslin_bot</artifactId>
    <version>1.0-SNAPSHOT</version>

<parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.5.0</version>
        <relativePath/> 
    </parent>

<dependencies>
            
            <dependency>
                <groupId>love.forte.simple-robot</groupId>
                <artifactId>parent</artifactId>
                <version>2.2.1</version>
                <scope>import</scope>
                <type>pom</type>
            </dependency>
        </dependencies>
    </dependencyManagement>

<dependencies>
        
        <dependency>
            <groupId>love.forte.simple-robot</groupId>
            <artifactId>component-mirai-spring-boot-starter</artifactId>

</dependency>

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

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            
            <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>

<dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</artifactId>
            <version>1.4.200</version>
        </dependency>

<dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.0</version>
        </dependency>

<dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.2</version>
        </dependency>

<dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-all</artifactId>
            <version>5.7.13</version>
        </dependency>

<dependency>
            <groupId>org.jsoup</groupId>
            <artifactId>jsoup</artifactId>
            <version>1.11.3</version>
        </dependency>

<dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>2.12.3</version>
        </dependency>

<dependency>
            <groupId>org.apache.httpcomponents</groupId>
            <artifactId>httpclient</artifactId>
            <version>4.5.13</version>
        </dependency>

<dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>4.1.2</version>
        </dependency>

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

<build>
        <plugins>
            
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <excludes>
                        <exclude>
                            <groupId>org.project.lombok</groupId>
                            <artifactId>lombok</artifactId>
                        </exclude>
                    </excludes>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <dependencies>
                    
                    <dependency>
                        <groupId>com.h2database</groupId>
                        <artifactId>h2</artifactId>
                        <version>1.4.200</version>
                    </dependency>
                </dependencies>
                <configuration>
                    
                    <configurationFile>${basedir}/src/main/resources/generatorConfig.xml</configurationFile>
                    <overwrite>true</overwrite>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project></code></pre><h5>config.properties</h5><pre><code class="lang-properties">jdbc.driverClass=org.h2.Driver
jdbc.url=jdbc:h2:mem:address;MODE=MySQL
jdbc.user=root
jdbc.password=root123

group.package=com.dnslin.dnslin_bot
catalog.name=address</code></pre><h5>generatorConfig.xml</h5><pre><code class="lang-xml"><?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
  PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">

<javaModelGenerator targetPackage="${group.package}.pojo"
            targetProject="src/main/java">
            
            <property name="enableSubPackages" value="false" />
            
            <property name="trimStrings" value="true" />
        </javaModelGenerator>
        
        <sqlMapGenerator targetPackage="mapper"
            targetProject="src/main/resources">
            
            <property name="enableSubPackages" value="false" />
        </sqlMapGenerator>
        
        <javaClientGenerator type="XMLMAPPER"
            targetPackage="${group.package}.mapper"
            targetProject="src/main/java">
            
            <property name="enableSubPackages" value="false" />
        </javaClientGenerator>
        
        <table schema="" tableName="address_all"></table>
    </context>
</generatorConfiguration>
</code></pre><h5>　application.yml</h5><pre><code class="lang-yaml">simbot:
  core:
    # 扫描 simbot-bots目录下的所有 .bot 文件。
    bot-resource-type: RESOURCE_FIRST
  component:
    mirai:
      # 如果不为空，此处代表指定一个 deviceInfo 的 json文件路径。
      deviceInfo-file: src/main/resources/device.json
spring:
  # 热部署
  devtools:
    restart:
      additional-paths: src/main/java
  # 数据源
  datasource:
    driver-class-name: org.h2.Driver
    schema: classpath:db/schema.sql
#    data: classpath:db/addressAll.sql
    url: jdbc:h2:mem:address;MODE=MySQL
    username: root
    password: root123
  h2:
    console:
      enabled: true
      path: /h2
      settings:
        trace: true
        web-allow-others: true
#  配置mybatis:
mybatis:
  mapper-locations: classpath:mapper/*.xml
  configuration:
    map-underscore-to-camel-case: true

# 日志
logging:
  level:
    love.forte.simbot: debug
    com.dnslin.dnslin_bot: debug
</code></pre>

springboot 集成 mybaits+ H2 DaTaBase

记录一次 `springboot` 集成 `mybaits` + `H2 DaTaBase`

pom.xml

config.properties

generatorConfig.xml

application.yml

live/msn等微软绝版邮箱详细的注册教程

欢迎使用 Typecho

一个功能强大又好用的RSS订阅器：FreshRSS安装教程

VPS使用BaiduPCS-Go高速下载百度网盘的文件，支持上传/离线下载等操作

使用Caddy申请免费的Let’s Encrypt泛域名SSL证书

远程文件包含漏洞（pikachu）

毛玻璃拟态UI - 个人主页开源版

中间人恶搞替换图片

修复官方Dplayer-Typecho插件不能连接弹幕API后端的方法

AWS Lightsail简便管理脚本（可创建管理实例、IP、端口等）

springboot 集成 mybaits+ H2 DaTaBase

记录一次 springboot 集成 mybaits + H2 DaTaBase

pom.xml

config.properties

generatorConfig.xml

application.yml

springboot 集成 mybaits+ H2 DaTaBase

记录一次 `springboot` 集成 `mybaits` + `H2 DaTaBase`

　pom.xml

　application.yml