使用代码生成器能够大大加快开发效率,它能够完成基本的模型、接口、xml文件的自动生成
java -jar mybatis-generator-core-1.3.2.jar -configfile generator.xml -overwrite 这是执行语句。输入的其实是这两个文件的位置。由于是在这两个文件按shift执行语句,所以这样写。
重点:
1.从此处可以看出mybatis-generator-core-1.3.2.jar和generator.xml两个文件是并列的目录。
2.还有个数据库驱动包,这个可以随便放哪个文件夹。在generator.xml里<classPathEntry location="F:\01mybatis-generator\generator\lib\sqljdbc4-4.0.jar" />这句话是引入数据库驱动包,<jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver" connectionURL="jdbc:sqlserver://rds7147zc63d33p5ii6p.sqlserver.rds.aliyuncs.com:3433;DatabaseName=tagen_020test" userId="tagentest" password="tagen_020test2017"></jdbcConnection> 这句话是输入数据库驱动和地址以及用户名和密码等信息。
3.下面是三种数据库的写法:
<!-- 数据库驱动包位置 -->
<classPathEntry
location="F:\01mybatis-generator\generator\lib\sqljdbc4-4.0.jar" />
<!-- <classPathEntry location="D:\software\lib\mysql-connector-java-5.1.21.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://localhost:3306/sy" userId="sypro" password="sypro"> </jdbcConnection>-->
<!--<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@localhost:1521:orcl" userId="msa" password="msa">
</jdbcConnection>-->
<jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver"connectionURL="jdbc:sqlserver://rds7147zc63d33p5ii6p.sqlserver.rds.aliyuncs.com:3433;DatabaseName=tagen_020test"userId="tagentest"
password="tagen_020test2017"></jdbcConnection>
4.<!-- 生成模型的包名和位置 -->
<javaModelGenerator targetPackage="com.property.parksanddoors.entity" targetProject="E:\study\mybatis\src">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- 生成的映射文件包名和位置 -->
<sqlMapGenerator targetPackage="com.property.parksanddoors.mapping" targetProject="E:\study\mybatis\src">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!-- 生成DAO的包名和位置 -->
<javaClientGenerator type="XMLMAPPER"
targetPackage="com.property.parksanddoors.dao"
targetProject="E:\study\mybatis\src">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
5.<!-- 要生成那些表(更改tableName和domainObjectName就可以) -->
<table tableName="td_DoorOpen"domainObjectName="DoorOpen" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
selectByExampleQueryId="false" />
进入有generator.xml的目录,按住shift然后鼠标右按键,在此处打开命令窗口。
输入java -jar mybatis-generator-core-1.3.2.jar -configfile generator.xml -overwrite回车。
注意点:生成模型的包名和生成的映射文件包名和生成DAO的包名要根据项目的实际文件夹来写
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="F:\01mybatis-generator\generator\lib\sqljdbc4-4.0.jar" />
<!-- <classPathEntry location="D:\software\lib\mysql-connector-java-5.1.21.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://localhost:3306/sy" userId="sypro" password="sypro"> </jdbcConnection>-->
<!--<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@localhost:1521:orcl" userId="msa" password="msa">
</jdbcConnection>-->
<jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver" connectionURL="jdbc:sqlserver://rds7147zc63d33p5ii6p.sqlserver.rds.aliyuncs.com:3433;DatabaseName=tagen_020test" userId="tagentest" password="tagen_020test2017"></jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- 生成模型的包名和位置 -->
<javaModelGenerator targetPackage="com.property.parksanddoors.entity" targetProject="E:\study\mybatis\src">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- 生成的映射文件包名和位置 -->
<sqlMapGenerator targetPackage="com.property.parksanddoors.mapping" targetProject="E:\study\mybatis\src">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!-- 生成DAO的包名和位置 -->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.property.parksanddoors.dao" targetProject="E:\study\mybatis\src">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<!-- 要生成那些表(更改tableName和domainObjectName就可以) -->
<table tableName="td_DoorOpen" domainObjectName="DoorOpen" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="td_DoorResult" domainObjectName="DoorResult" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="td_DoorUser" domainObjectName="DoorUser" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="td_DoorUserList" domainObjectName="DoorUserList" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_Valetpayresult" domainObjectName="Role" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_Valetpayment" domainObjectName="RoleResource" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_UserMessage" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_UserCarNO" domainObjectName="UserRole" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_User" domainObjectName="ParkUser" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_SubScribeid" domainObjectName="ParkSubScribeid" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_SubOrder" domainObjectName="ParkSubOrder" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_SpaceResult" domainObjectName="ParkSpaceResult" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_Space" domainObjectName="ParkSpace" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_Requestresult" domainObjectName="ParkRequestresult" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_RequestRemoveResult" domainObjectName="ParkRequestRemoveResult" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_RequestRemove" domainObjectName="ParkRequestRemove" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_Request" domainObjectName="ParkRequest" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_PayResult" domainObjectName="ParkPayResult" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_PayOrderList" domainObjectName="ParkPayOrderList" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_PayOrder" domainObjectName="ParkPayOrder" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_Paynotify" domainObjectName="ParkPaynotify" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_ParkCodes" domainObjectName="ParkParkCodes" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_monthcardResult" domainObjectName="ParkmonthcardResult" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_monthcard" domainObjectName="Parkmonthcard" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_lockCarResult" domainObjectName="ParklockCarResult" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_lockCar" domainObjectName="ParklockCar" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
<table tableName="Park_CarArea" domainObjectName="ParkCarArea" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
</context>
</generatorConfiguration>