利用MyBatis-Generator工具根据现有数据库生成实体类和Mapper接口

淩亂°似流年 2022-05-12 08:28 199阅读 0赞

**第一步：在pom.xml中导入mybatis-generator工具包**

<dependencies>
        <dependency>
          <groupId>org.mybatis.generator</groupId>
          <artifactId>mybatis-generator-core</artifactId>
          <version>1.3.6</version>
        </dependency>
    
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>5.1.8</version>
        </dependency>
    
    </dependencies>

**第二步:在project下创建一个mbg.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>
        
      <classPathEntry location="C:\Users\Administrator\.m2\repository\mysql\mysql-connector-Java\5.1.8\mysql-connector-java-5.1.8.jar" />
    
        
      <context id="MySQLTables" targetRuntime="MyBatis3">
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
            connectionURL="jdbc:mysql://localhost:3306/studyonline"
            userId="root"
            password="1234">
        </jdbcConnection>
    
        
        <javaModelGenerator targetPackage="cn.xdl.ovls.entity" targetProject=".\src\main\java">
          <property name="enableSubPackages" value="true" />
          <property name="trimStrings" value="true" />
        </javaModelGenerator>
    
        
        <sqlMapGenerator targetPackage="cn.xdl.ovls.sql"  targetProject=".\src\main\java">
          <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
    
        
        
        <javaClientGenerator type="ANNOTATEDMAPPER" targetPackage="cn.xdl.ovls.dao"  targetProject=".\src\main\java">
          <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
    
        
        <table tableName="%" 
            enableCountByExample="false" enableSelectByExample="false"
            enableDeleteByExample="false" enableUpdateByExample="false">
        </table>
    
      </context>
    </generatorConfiguration>

**第三步：定义一个启动类，加载mbg.xml执行生成工具**

public class MyBatisRunner {
    
        public static void main(String[] args) throws Exception{
            List<String> warnings = new ArrayList<String>();
            boolean overwrite = true;
            File configFile = new File("mbg.xml");
            ConfigurationParser cp = new ConfigurationParser(warnings);
            Configuration config = cp.parseConfiguration(configFile);
            DefaultShellCallback callback = new DefaultShellCallback(overwrite);
            MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
            myBatisGenerator.generate(null);
        }
    
    }