欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

MyBatis:由数据库自动生成实体类

程序员文章站 2022-06-15 13:40:19
...

需要的工具jar包

mybatis-generator-core-1.3.2.jar

mysql-connector-java-5.0.4.jar

第一步:编写一个MybatisGeneratorUtil类

package com.test.utils;
import java.io.File;  
import java.io.IOException;  
import java.sql.SQLException;  
import java.util.ArrayList;  
import java.util.List;  
  
import org.mybatis.generator.api.MyBatisGenerator;  
import org.mybatis.generator.config.Configuration;  
import org.mybatis.generator.config.xml.ConfigurationParser;  
import org.mybatis.generator.exception.InvalidConfigurationException;  
import org.mybatis.generator.exception.XMLParserException;  
import org.mybatis.generator.internal.DefaultShellCallback;  
  
public class MybatisGeneratorUtil {  
  
    public static void main(String[] args) {  
        try {  
            System.out.println("start generator ...");  
            List<String> warnings = new ArrayList<String>();  
            boolean overwrite = true;  
            File configFile = new File(MybatisGeneratorUtil.class.getResource("/generator.xml").getFile());  
            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);  
            System.out.println("end generator!");  
        } catch (IOException e) {  
            e.printStackTrace();  
        } catch (XMLParserException e) {  
            e.printStackTrace();  
        } catch (InvalidConfigurationException e) {  
            e.printStackTrace();  
        } catch (SQLException e) {  
            e.printStackTrace();  
        } catch (InterruptedException e) {  
            e.printStackTrace();  
        }  
    }  
      
}

第二步:编写一个generator.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="D:\mysql-connector-java-5.0.4.jar" />    
    
  <context id="Mysql2Tables" targetRuntime="MyBatis3">    
    <jdbcConnection driverClass="com.mysql.jdbc.Driver"    
        connectionURL="jdbc:mysql://localhost:3306/datebase"    
        userId="root"    
        password="root">    
    </jdbcConnection>    
    
    <javaTypeResolver >    
      <property name="forceBigDecimals" value="false" />    
    </javaTypeResolver>    
    
    <javaModelGenerator targetPackage="com.test.model" targetProject="src">    
      <property name="enableSubPackages" value="true" />    
      <property name="trimStrings" value="true" />    
    </javaModelGenerator>    
    
    <sqlMapGenerator targetPackage="com.test.mapper"  targetProject="src">    
      <property name="enableSubPackages" value="true" />    
    </sqlMapGenerator>    
    
    <javaClientGenerator type="XMLMAPPER" targetPackage="com.test.dao"  targetProject="src">    
      <property name="enableSubPackages" value="true" />    
    </javaClientGenerator>    
    <table schema="test" tableName="t_student" domainObjectName="Tstudent" enableCountByExample="false" enableUpdateByExample="false"    
           enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">    
    </table>    
    <table schema="test" tableName="t_class" domainObjectName="Tclass" enableCountByExample="false" enableUpdateByExample="false"    
       enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">    
   </table>    
   <table schema="test" tableName="t_stu_class" domainObjectName="Tstclass" enableCountByExample="false" enableUpdateByExample="false"    
       enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">    
   </table>  
  </context>    
</generatorConfiguration> 

其中<table>中的tableName代表数据库中的表名、domainObjectName表示你要生成的实体类的名字;
<classPathEntry>中的location代表你的mysql-connector-java-5.0.4.jar地址;

targetPackage便是你要生成的文件的路径.

最后:执行MybatisGeneratorUtil类生成

 

转载于:https://my.oschina.net/milu6852/blog/3007658