spring boot mybatis自动生成实体

2020-04-10  本文已影响0人  深夜程序员_

1.引入Mysql

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-configuration-processor</artifactId>

            <optional>true</optional>

        </dependency>

        <dependency>

            <groupId>mysql</groupId>

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

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.mybatis.generator</groupId>

            <artifactId>mybatis-generator-core</artifactId>

            <version>1.3.6</version>

        </dependency>

        <dependency>

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis</artifactId>

            <version>3.4.6</version>

        </dependency>

        <!-- 分页 -->

        <dependency>

            <groupId>com.github.pagehelper</groupId>

            <artifactId>pagehelper</artifactId>

            <version>4.1.6</version>

        </dependency>

2.配置application.yml

spring:

  datasource:

    driver-class-name: com.mysql.jdbc.Driver

    url: jdbc:mysql://127.0.0.1:3306/ordershop

    username: root

    password: 123456

    tomcat:

      initial-size: 5

      max-active: 30

  aop:

    auto: true

    proxy-target-class: false

  jpa:

    hibernate:

      ddl-auto: update

    show-sql: true

mybatis:

    mapperLocations: classpath:mybatis/mapper*.xml

    typeAliasesPackage: com.lz.ordershop.*.model

pageHelper:

  reasonable: "true"

  supportMethodsArguments: "true"

  returnPageInfo: check

  params: count=countSql

3.配置一个数据库链接的配置文件 config.properties

# Mybatis Generator configuration

# MySQL Connector Jar

classPath=C:/Users/user/.m2/repository/mysql/mysql-connector-java/8.0.13/mysql-connector-java-8.0.13.jar

# MySQL

jdbc_driver=com.mysql.cj.jdbc.Driver

jdbc_url=jdbc:mysql://127.0.0.1:3306/ordershop?useUnicode=true&nullCatalogMeansCurrent=true

jdbc_user=root

jdbc_password=123456

4.配置自动生成的配置文件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="mybatis/config.properties"/>

    <classPathEntry location="${classPath}"/>

    <context id="context1" targetRuntime="MyBatis3">

        <jdbcConnection driverClass="${jdbc_driver}" connectionURL="${jdbc_url}" userId="${jdbc_user}"

                        password="${jdbc_password}"/>

        <javaModelGenerator targetPackage="com.lz.ordershop.sys.model" targetProject="src-gen\java"/>

        <sqlMapGenerator targetPackage="com.lz.ordershop.sys.dao" targetProject="src-gen\resources"/>

        <javaClientGenerator targetPackage="com.lz.ordershop.sys.dao" targetProject="src-gen\java"

                             type="ANNOTATEDMAPPER"/>

        <table tableName="sys_authority"/>

        <table tableName="sys_authority_copy"/>

    </context>

</generatorConfiguration>

5.使用mavn命令进行生成

mvn antrun:run

mvn mybatis-generator:generate

上一篇下一篇

猜你喜欢

热点阅读