MyBaits Generator工具使用

源码下载
https://gitee.com/qq1350048638/lj_generator

新建 Dynamic web project 工程
目录结构
配置 mbg.xml MyBatisGeneratorRun.java 类 即可生成 dao 和 entity

3个驱动jar包

---

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="E:\java20182\213\lj_generator\WebContent\WEB-INF\lib\mysql-connector-java-5.1.7-bin.jar" />

  <!-- 指定数据库连接参数 -->
  <context id="MySQLTables" targetRuntime="MyBatis3">
    <jdbcConnection driverClass="com.mysql.jdbc.Driver"
        connectionURL="jdbc:mysql://localhost:3306/studyonline"
        userId="root"
        password="123456">
    </jdbcConnection>

    <!-- 指定对BigDecimal是否特殊处理 -->
    <javaTypeResolver >
      <property name="forceBigDecimals" value="false" />
    </javaTypeResolver>


    <!-- 指定实体类生成，位置和名称 -->
    <javaModelGenerator targetPackage="com.lj.ovls.entity" targetProject=".\src">
      <property name="enableSubPackages" value="true" />
      <property name="trimStrings" value="true" />
    </javaModelGenerator>

    <!-- 指定sql定义文件(XML文件)，位置和名称 -->
    <sqlMapGenerator targetPackage="com.lj.ovls.sql"  targetProject=".\src">
      <property name="enableSubPackages" value="true" />
    </sqlMapGenerator>

    <!-- 指定Mapper接口，的位置和名称 -->
    <javaClientGenerator type="ANNOTATEDMAPPER" targetPackage="com.lj.ovls.dao"  targetProject=".\src">
      <property name="enableSubPackages" value="true" />
    </javaClientGenerator>

    <!-- 指定哪些表生成 -->
    <table tableName="%" 
        enableCountByExample="false" enableDeleteByExample="false"
        enableSelectByExample="false" enableUpdateByExample="false">
    </table>

  </context>
</generatorConfiguration>

---

MyBatisGeneratorRun 类 运行即可

package com.lj;

import java.io.File;
import java.io.IOException;
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.XMLParserException;
import org.mybatis.generator.internal.DefaultShellCallback;

public class MyBatisGeneratorRun {

    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);
    }

}

---

注意：

jdbc:mysql://localhost:3306/studyonline
需要有 studyonline数据库，并且数据库里已经有对应的表
mybatis 根据数据库的表 生成对应的 entity 和 dao
如： Answer.java 和 AnswerMapper.java AnswerSqlProvider.java