三. SpringBoot项目初始化mybatis配置

用户8988577

发布于 2022-12-27 15:55:33

4540

发布于 2022-12-27 15:55:33

文章被收录于专栏：言云纪言云纪

前言

初始化创建Springboot项目结构如下图所示，本文将不叙述如何创建springboot。

配置mybatis-plus与逆向代码生成

pom依赖引入

在pom.xml文件中的dependencies标签内插入如下代码

        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.2</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>3.5.1</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.ibatis</groupId>
            <artifactId>ibatis-core</artifactId>
            <version>3.0</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>

在plugins标签内插入如下代码

<!--            mybatis逆向代码生成工具-->
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.7</version>
                <configuration>
                    <!--允许移动生成的文件 -->
                    <verbose>false</verbose>
                    <!--允许覆盖生成的文件 -->
                    <overwrite>false</overwrite>
                    <!--配置文件的路径 -->
                    <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
                </configuration>
                <dependencies>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <version>${mysql.version}</version>
                    </dependency>
                </dependencies>
            </plugin>
<!--            end-->

generatorConfig.xml文件的编写

在resources目录下创建generatorConfig.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">
<generatorConfiguration>
    <properties resource="application.properties"/>
    <!-- defaultModelType="flat" 设置复合主键时不单独为主键创建实体 -->
    <context id="MySql" defaultModelType="flat">
        <!-- 生成的POJO实现java.io.Serializable接口 -->
        <plugin type="org.mybatis.generator.plugins.SerializablePlugin" />

        <!--注释-->
        <commentGenerator>
            <!-- 将数据库中表的字段描述信息添加到注释 -->
            <property name="addRemarkComments" value="true"/>
            <!-- 注释里不添加日期 -->
            <property name="suppressDate" value="true"/>

        </commentGenerator>
        <!--<jdbcConnection>-->
            <!--<property name="nullCatalogMeansCurrent" value="true"/>-->
        <!--</jdbcConnection>-->


        <!-- 数据库连接，直接通过${}读取application.properties里的配置 -->
        <jdbcConnection
                driverClass="${spring.datasource.driver-class-name}"
                connectionURL="${spring.datasource.url}"
                userId="${spring.datasource.username}"
                password="${spring.datasource.password}">
            <!-- Tan -->
            <!-- 指定生成数据库表的实体类，避免生成user等表出现生成错误实体类的情况 -->
            <property name="nullCatalogMeansCurrent" value="true"/>
        </jdbcConnection>

        <!-- 生成POJO对象，并将类放到cc.tanblog.online.entity包下 -->
        <javaModelGenerator targetPackage="cc.tanblog.online.entity" targetProject="src/main/java"></javaModelGenerator>
        <!-- 生成mapper xml文件，并放到resources下的mapper文件夹下 -->
        <sqlMapGenerator targetPackage="cc.tanblog.online.mapper"  targetProject="src/main/resources"></sqlMapGenerator>
        <javaClientGenerator targetPackage="cc.tanblog.online.mapper" targetProject="src/main/java" type="XMLMAPPER">
        <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>

        <table tableName="create_room">
            <property name="modelOnly" value="false"/>
        </table>
        <table tableName="upload_video">
            <property name="modelOnly" value="false"/>
        </table>
        <table tableName="user">
            <property name="modelOnly" value="false"/>
        </table>
        <table tableName="video">
            <property name="modelOnly" value="false"/>
        </table>
        <table tableName="videoroom">
            <property name="modelOnly" value="false"/>
        </table>

    </context>
</generatorConfiguration>

配置application.properties

< 用于mybatis逆向生成代码链接数据库

spring.mvc.pathmatch.matching-strategy=ant-path-matcher
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/online?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false&allowPublicKeyRetrieval=true&testOnborrow =false
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

逆向生成POJO文件

maven>>mybatis-generator>>mybatis-generator:generate 生成的目录如下图

配置mybatis

在cc.tanblog.online.config目录下创建MybatisConfig.java

@Configuration
@MapperScan(basePackages = {"cc.tanblog.online.mapper"},sqlSessionFactoryRef = "sqlSessionFactory")
public class MybatisConfig {


    // 工厂生产要dataSource 由spring产生
    @Bean
    public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sessionFactoryBean = new SqlSessionFactoryBean();//工厂bean的对象是产品
        sessionFactoryBean.setDataSource(dataSource);
        PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        //扫描 数据库和java entity 对应的配置文件，所在包是哪里
        sessionFactoryBean.setMapperLocations(resolver.getResources("classpath:/cc/tanblog/online/mapper/*Mapper.xml"));       //mybatis的xml文件路径
        sessionFactoryBean.setTypeAliasesPackage("cc.tanblog.online.entiy");//生成的实体类映射在那个包
//        //将分页拦截器注册到插件中
        //PageInterceptor pageInterceptor = new PageInterceptor();
        //sessionFactoryBean.setPlugins(new Interceptor[]{pageInterceptor});
        return  sessionFactoryBean;
    }
}

配置application.yml

用于mybatis数据库操作的连接

spring:
  jackson:
    date-format: yyyy-MM-dd HH:mm:ss
    time-zone: GMT-8
    datasource:
      url: jdbc:mysql://127.0.0.1:3306/online_video?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false&allowPublicKeyRetrieval=true&testOnborrow =false
      username: root
      password: 123456
      driver-class-name: com.mysql.jdbc.Driver
    mybatis:
      configuration:
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    servlet:
      session:
        cookie:
          http-only: false

本文参与腾讯云自媒体分享计划，分享自作者个人站点/博客。

原始发表：2022-09-30，如有侵权请联系 cloudcommunity@tencent.com 删除

mybatis