逆向工程 sql_SpringBoot+Mybatis逆向工程

什么是逆向工程

分析数据库中数据表，自动生成Pojo(与数据库表对应的实体类)、dao 接口(数据访问层接口，定义了访问数据的方法)、mapper (sql 语句映射文件，与dao层接口类一一对应)

新建SpringBoot项目

注意：这里使用springboot进行新建项目，pom文件见下文。

Step1: 编写pom文件

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
 <modelVersion>4.0.0modelVersion>
 <parent>
  <groupId>org.springframework.bootgroupId>
  <artifactId>spring-boot-starter-parentartifactId>
  <version>2.1.11.RELEASEversion>
  <relativePath/> 
 parent>
 <groupId>cn.henugroupId>
 <artifactId>henuartifactId>
 <version>0.0.1-SNAPSHOTversion>
 <name>cnname>
 <description>Demo project for Spring Bootdescription>
 <properties>
  <java.version>1.8java.version>
 properties>
 <dependencies>
  <dependency>
   <groupId>org.mybatis.spring.bootgroupId>
   <artifactId>mybatis-spring-boot-starterartifactId>
   <version>1.3.2version>
  dependency>
  <dependency>
   <groupId>org.projectlombokgroupId>
   <artifactId>lombokartifactId>
   <optional>trueoptional>
  dependency>
  <dependency>
   <groupId>org.springframework.bootgroupId>
   <artifactId>spring-boot-starter-testartifactId>
   <scope>testscope>
   <exclusions>
    <exclusion>
     <groupId>org.junit.vintagegroupId>
     <artifactId>junit-vintage-engineartifactId>
    exclusion>
   exclusions>
  dependency>
  
  <dependency>
   <groupId>org.mybatis.generatorgroupId>
   <artifactId>mybatis-generator-coreartifactId>
   <version>1.3.2version>
  dependency>
  <dependency>
   <groupId>org.junit.jupitergroupId>
   <artifactId>junit-jupiterartifactId>
   <version>RELEASEversion>
   <scope>testscope>
  dependency>
 dependencies>
 <build>
  <resources>
   <resource>
    <directory>src/main/resourcesdirectory>
    <includes>
     
     <include>**/*.xmlinclude>
     
     <include>**/*.propertiesinclude>
    includes>
   resource>
  resources>
  <plugins>
   <plugin>
    <groupId>org.springframework.bootgroupId>
    <artifactId>spring-boot-maven-pluginartifactId>
   plugin>
   
   <plugin>
    <groupId>org.mybatis.generatorgroupId>
    <artifactId>mybatis-generator-maven-pluginartifactId>
    <version>1.3.2version>
    <configuration>
     
     <verbose>trueverbose>
     
     <overwrite>trueoverwrite>
     
     <configurationFile>
      src/main/resources/generatorConfig.xml
     configurationFile>
    configuration>
    <dependencies>
     <dependency>
      <groupId>mysqlgroupId>
      <artifactId>mysql-connector-javaartifactId>
      <version>8.0.11version>
     dependency>
    dependencies>
   plugin>
  plugins>
 build>
project>

step2：编写XML配置文件

自动生成代码的xml，这里命名为：generatorConfig.xml

<?xml  version="1.0" encoding="UTF-8"?>
generatorConfigurationPUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN""http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
    <context id="faceRec" targetRuntime="MyBatis3">
        
        <plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin">plugin>
        
        <plugin type="org.mybatis.generator.plugins.SerializablePlugin">plugin>
        
        <plugin type="org.mybatis.generator.plugins.ToStringPlugin">plugin>
        <commentGenerator>
            
            <property name="suppressAllComments" value="true" />
        commentGenerator>
        
        <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"connectionURL="jdbc:mysql://127.0.0.1:3306/faceRec?serverTimezone=Hongkong"userId="root"password="******">
        jdbcConnection>
        
        <javaTypeResolver>
            <property name="forceBigDecimals" value="false" />
        javaTypeResolver>

        
        <javaModelGenerator targetPackage="cn.henu.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="cn.henu.dao"targetProject="src/main/java">
            
            <property name="enableSubPackages" value="false" />
        javaClientGenerator>
        
        
        <table schema="" tableName="faceAdmin">table>
        <table schema="" tableName="faceUser">table>
        <table schema="" tableName="Movie">table>
    context>
generatorConfiguration>

step3：生成文件

双击下图所示的地方

整体目录结构

所有步骤均文本人亲自测试完成,如有疑问可联系我哦。

- END -

温暖提示

• Linux下安装Redis
• CentOS7中安装Mysql

最后别忘了点 在看 给我一个鼓励哦！