mybatis逆向工程

前提

本人对mybatis也不是很熟练，怕忘记了，提前来写个笔记

准备(1个jar包+1个配置文件+自定义1个生成类)

需要的jar包(百度)：

mybatis-generator-core-1.3.2.jar

需要的配置文件内容（generatorconfig.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:/cache/mysql-connector-java-5.1.21-bin.jar" /><context id="DB2Tables" targetRuntime="MyBatis3"><commentGenerator><property name="suppressDate" value="true" /><property name="suppressAllComments" value="true" /></commentGenerator><!--数据库链接地址账号密码 --><jdbcConnection driverClass="com.mysql.jdbc.Driver"connectionURL="jdbc:mysql://127.0.0.1:3306/bookshop" userId="root"password="123456"></jdbcConnection><javaTypeResolver><property name="forceBigDecimals" value="false" /></javaTypeResolver><!--生成实体类entity类存放位置 --><javaModelGenerator targetPackage="com.bookshop.xcl.entity"targetProject="src"><property name="enableSubPackages" value="true" /><property name="trimStrings" value="true" /></javaModelGenerator><!--生成xml映射文件存放位置 --><sqlMapGenerator targetPackage="com.bookshop.xcl.xml"targetProject="src"><property name="enableSubPackages" value="true" /></sqlMapGenerator><!--生成DaoMapper类存放位置 --><javaClientGenerator type="XMLMAPPER"targetPackage="com.bookshop.xcl.dao" targetProject="src"><property name="enableSubPackages" value="true" /></javaClientGenerator><!--生成对应表及类名,需要记住的一点是逆向工程无法生成关联关系,只能生成单表操作 --><table tableName="users" domainObjectName="Users"></table><table tableName="addresss" domainObjectName="Addresss"></table><table tableName="buyrecord" domainObjectName="Buyrecord"></table><table tableName="shopping" domainObjectName="Shopping"></table><table tableName="bookmanager" domainObjectName="Teacher"></table></context></generatorConfiguration>

自定义的生成类（比如我的是generatorconfig.java）

import java.io.File;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.internal.DefaultShellCallback;public class generatorconfig {public static void generator() throws Exception {List<String> warnings = new ArrayList<String>();boolean overwrite = true;// 获取绝对路径String relativelyPath = System.getProperty("user.dir");// 读取配置文件File configFile = new File(relativelyPath+ "/config/generatorconfig.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);}public static void main(String[] args) {try {generator();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}}