1、驱动准备
sqlserver驱动包:mssql-jdbc-6.2.2.jre8.jar
生成代码基础驱动包:mybatis-generator-core-1.3.7.jar
关于Mybatis-Generator的下载可以到这个地址:https://github.com/mybatis/generator/releases
2、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="mssql-jdbc-6.2.2.jre8.jar"/>
<context id="DB2Tables" targetRuntime="MyBatis3">
<commentGenerator>
<property name="suppressDate" value="true"/>
<property name="suppressAllComments" value="true"/>
</commentGenerator>
<!--数据库链接地址账号密码-->
<jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver" connectionURL="jdbc:sqlserver://192.168.1.1:1433;DatabaseName=WaterPage" userId="USER" password="PASSWORD">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false"/>
</javaTypeResolver>
<!--生成Model类存放位置-->
<javaModelGenerator targetPackage="com.swj.entity" targetProject="D:\mybatis gen\waterpage\scr">
<property name="enableSubPackages" value="true"/>
<property name="trimStrings" value="true"/>
</javaModelGenerator>
<!--生成映射文件存放位置-->
<sqlMapGenerator targetPackage="mybatis.mapping" targetProject="D:\mybatis gen\waterpage\scr">
<property name="enableSubPackages" value="true"/>
</sqlMapGenerator>
<!--生成Dao类存放位置-->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.swj.dao" targetProject="D:\mybatis gen\waterpage\scr">
<property name="enableSubPackages" value="true"/>
</javaClientGenerator>
<!--生成对应表及类名-->
<table tableName="WP_Data_Source" domainObjectName="DataSource" enableCountByExample="false"
enableUpdateByExample="false" enableDeleteByExample="false"
enableSelectByExample="false" selectByExampleQueryId="false"></table>
</context>
</generatorConfiguration>
3、生成文件
1)以上三个文件放在同一个文件夹
2)打开cmd,cd到文件夹地址下
3)输入命令
java -jar mybatis-generator-core-1.3.7.jar -configfile generatorConfig.xml -overwrite