47,Springboot-mybatis-maven-generator详解优雅的结合

1.导入jar pom.xml

<!-- mysql驱动所依赖的jar-->
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!--集成Mybatis所依赖的jar-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-maven-plugin -->
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.5</version>
<executions>
<execution>
<id>Generate MyBatis Artifacts</id>
<phase>deploy</phase>
<goals>
<goal>generate</goal>
</goals>
</execution>
</executions>
<!--工具配置类  -->
<configuration>
<configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
<verbose>true</verbose>
<overwrite>true</overwrite>
</configuration>
<dependencies>
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.5</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.12</version>
</dependency>
</dependencies>
</plugin>
    <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
</plugins>
</build>

2,yml配置

server:
  port: 8081
spring:
 datasource:
    driver-class-name: com.mysql.jdbc.Driver
       url: jdbc:mysql://127.0.0.1:3306/test
         username:  root 
         password: root

3,使用mybatisgenerator 自动生成代码:**

main.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="mybatis-generator/mybatisGeneratorinit.properties"/> -->
    <!--数据库驱动-->
    <!-- <classPathEntry    location="/Users/wangyingbo/eclipse-workspace/Interg/mysql-connector-java-8.0.12.jar"/> -->
<context id="DB2Tables"    targetRuntime="MyBatis3">
        <commentGenerator>
            <property name="suppressDate" value="true"/>
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>
 <!--数据库链接地址账号密码-->
 <!--需要改成自己的数据库链接地址账号密码-->
 <!--driverClass="  这里不能有空格-->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/test" userId="root" password="root">
        </jdbcConnection>
 <javaTypeResolver>
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>
    <!--生成pojo类存放位置-->
        <javaModelGenerator targetPackage="com.taotao.suanfa.pojo" targetProject="src/main/java">
            <property name="enableSubPackages" value="true"/>
            <property name="trimStrings" value="true"/>
 </javaModelGenerator>
        <!--生成映射文件存放位置 mapper如果不需要可不用-->
      <!--  <sqlMapGenerator targetPackage="com.taotao.suanfa.mapping" targetProject="src/main/java">
            <property name="enableSubPackages" value="true"/>
    </sqlMapGenerator>-->
        <!--生成Dao类存放位置 如果不需要可不用-->
        <!--<javaClientGenerator type="XMLMAPPER" targetPackage="com.taotao.suanfa.dao" targetProject="src/main/java">
            <property name="enableSubPackages" value="true"/>
   </javaClientGenerator>-->
        <!--生成对应表及类名  domainObjectName对应的表名-->
 <table tableName="apps_app" domainObjectName="AppsAppPojo" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
    </context>
</generatorConfiguration>

4,在数据库中建立表 apps_app

5,**点击run----》EditConfigurations **

image
image
image

6,右击项目工程名---》maven-àReimport--》运行

image
最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容