通过数据库自动生成代码

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:\D\java\spring\mbg\WebContent\WEB-INF\lib\mysql-connector-java-5.1.7-bin.jar" />

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

    <javaTypeResolver >
      <property name="forceBigDecimals" value="false" />
    </javaTypeResolver>

 <!-- 指定实体类生成 -->
    <javaModelGenerator targetPackage="cn.xdl.entity" targetProject=".\src">
      <property name="enableSubPackages" value="true" />
      <property name="trimStrings" value="true" />
    </javaModelGenerator>

 <!-- 指定sql定义文件生成 -->
    <sqlMapGenerator targetPackage="cn.xdl.sql"  targetProject=".\src">
      <property name="enableSubPackages" value="true" />
    </sqlMapGenerator>

 <!-- 指定Mapper映射器生成,type=XMLMAPPER指的是XML定义SQL；如果等于ANNOTATEDMAPPER指的是注解SQL -->
    <javaClientGenerator type="ANNOTATEDMAPPER" targetPackage="cn.xdl.dao"  targetProject=".\src">
      <property name="enableSubPackages" value="true" />
    </javaClientGenerator>

 <!-- 指定哪些表生成上述的实体类、sql文件、Mapper映射器 -->
 <!--
    <table tableName="user" domainObjectName="User"
     enableCountByExample="false" enableDeleteByExample="false"
     enableSelectByExample="false" enableUpdateByExample="false">
    </table>
  -->
  <table tableName="%"
     enableCountByExample="false" enableDeleteByExample="false"
     enableSelectByExample="false" enableUpdateByExample="false">
    </table>
  </context>
</generatorConfiguration>

启动类：

package cn.xdl;

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 MyGenerator {

 public static void main(String[] args) throws IOException, XMLParserException, SQLException, InterruptedException, InvalidConfigurationException {
  List<String> warnings = new ArrayList<String>();
  boolean overwrite = true;
  //加载项目根目录下的mbg.xml
  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);
 }

}