记一次使用mybatis生成工具生成mapper层代码

1. 首先要下载好两个jar包

下载地址
链接：https://pan.baidu.com/s/10lUtaODB8AOjdQAgXMUUFQ
提取码：c3a2

2. 在数据库中建立好表格

CREATE TABLE ASSETSTATUS(
	ID INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
	OWNER VARCHAR(20) NOT NULL,
	DATASTARTTIME TIMESTAMP NOT NULL,
	DATATHEME VARCHAR(20) NOT NULL,
	DATASIZE VARCHAR(20) NOT NULL,
	BLOCKVERSION VARCHAR(20) NOT NULL,
	DATAINBLOACKID VARCHAR(20) NOT NULL,
	ISONLINE BOOLEAN  NOT NULL
) DEFAULT CHARSET=UTF8;

CREATE TABLE ASSETTRADING (
	ID INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
	OWNER VARCHAR(20) NOT NULL,
	USERS VARCHAR(20) NOT NULL,
	TRADETIME VARCHAR(20) NOT NULL,
	DATATHEME VARCHAR(20) NOT NULL,
	DATAVALUE VARCHAR(20) NOT NULL,
	DATASIZE VARCHAR(20) NOT NULL,
	ISONLINE BOOLEAN NOT NULL
	

) DEFAULT CHARSET=UTF8;


CREATE TABLE ASSETPRICING(
	ID INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
	DATACHEACKER VARCHAR(20) NOT NULL,
	DATAPRICEDECIDETIME TIMESTAMP NOT NULL,
	DATASIZE VARCHAR(20) NOT NULL,
	DATAVALUE VARCHAR(20) NOT NULL,
	ISONLINE BOOLEAN NOT NULL
)  DEFAULT CHARSET=UTF8;


CREATE TABLE USERS(
	 ID INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
	 USERNAME VARCHAR(20) NOT NULL,
	 PASSWORD VARCHAR(20) NOT NULL
) DEFAULT CHARSET=UTF8;

3. 在项目目录中创建一个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:\programe\eclipse-java\myworkspace\DataSharePlatform-java\src\main\resources\mysql-connector-java-5.0.8-bin .jar" />   
    <!-- <classPathEntry location="C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar" />-->  
    <context id="DB2Tables" targetRuntime="MyBatis3">  
        <commentGenerator>  
            <property name="suppressAllComments" value="true" />  
        </commentGenerator>  
        <!-- 数据库链接URL、用户名、密码 -->  
         <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://127.0.0.1:8000/datashare-platform?characterEncoding=UTF-8" userId="root" password="root">   
        <!--<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@localhost:1521:orcl" userId="msa" password="msa">-->  
        </jdbcConnection>  
        <javaTypeResolver>  
            <property name="forceBigDecimals" value="false" />  
        </javaTypeResolver>  
        <!-- 生成模型的包名和位置 -->  
        <javaModelGenerator targetPackage="com.dreamcold.dreamcold.entity" targetProject="D:\programe\eclipse-java\myworkspace\DataSharePlatform-java\src\main\java">
            <property name="enableSubPackages" value="true" />  
            <property name="trimStrings" value="true" />  
        </javaModelGenerator>  
        <!-- 生成的映射文件包名和位置 -->  
        <sqlMapGenerator targetPackage="com.dreamcold.dreamcold.mapper" targetProject="D:\programe\eclipse-java\myworkspace\DataSharePlatform-java\src\main\java">
            <property name="enableSubPackages" value="true" />  
        </sqlMapGenerator>  
        <!-- 生成DAO的包名和位置 -->  
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.dreamcold.dreamcold.mapper" targetProject="D:\programe\eclipse-java\myworkspace\DataSharePlatform-java\src\main\java">
            <property name="enableSubPackages" value="true" />  
        </javaClientGenerator>  
		
		<table tableName="users"
               domainObjectName="User"
               enableCountByExample="false"
               enableUpdateByExample="false"
               enableDeleteByExample="false"
               enableSelectByExample="false"
               selectByExampleQueryId="false">

        </table>
		
				
		<table tableName="assetstatus"
               domainObjectName="AssetStatus"
               enableCountByExample="false"
               enableUpdateByExample="false"
               enableDeleteByExample="false"
               enableSelectByExample="false"
               selectByExampleQueryId="false">

        </table>
		
				
		<table tableName="assetpricing"
               domainObjectName="AssetPricing"
               enableCountByExample="false"
               enableUpdateByExample="false"
               enableDeleteByExample="false"
               enableSelectByExample="false"
               selectByExampleQueryId="false">

        </table>
		
				
		<table tableName="assettrading"
               domainObjectName="AssetTrading"
               enableCountByExample="false"
               enableUpdateByExample="false"
               enableDeleteByExample="false"
               enableSelectByExample="false"
               selectByExampleQueryId="false">

        </table>

    </context>  
</generatorConfiguration>

4. 进入该目录

cd dirname
cd /d d: #注意换盘啊，我放在d盘要切盘
java -jar mybatis-generator-core-1.4.0.jar -configfile generator.xml -overwrite

5. 生成成功