Mybatis插件自动生成类

 

 

1. 通过maven添加Mybatis插件

在pom中配置

<build>		 
      <plugin>  
         <groupId>org.mybatis.generator</groupId>  
         <artifactId>mybatis-generator-maven-plugin</artifactId>  
         <version>1.3.2</version>  
         <configuration>  
          <verbose>true</verbose>  
         <overwrite>true</overwrite>  
        <configurationFile>
         /Java/MavenHotel/generatorConfig.xml
     </configurationFile>
     </configuration>  
            </plugin>  
		</plugins>
	</build>	

<dependencies>	
<dependency>
		<groupId>org.mybatis.generator</groupId>
		<artifactId>mybatis-generator-core</artifactId>
		<version>1.3.5</version>
</dependency>

</dependencies>

 

    2.  创建generatorConfig.xml 文件(放在根目录下或者放在src/main/resources目录下)

<?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>
	<properties resource="properties/jdbc.properties" />
	<classPathEntry
		location="D:\JAVA\jar\com\microsoft\sqlserver\sqljdbc4\4.0\sqljdbc4-4.0.jar" />


	<context id="DB2Tables" targetRuntime="MyBatis3">
		<commentGenerator>
			<!-- 是否去除自动生成的注释 true:是;false:否 -->
			<property name="suppressAllComments" value="true" />
		</commentGenerator>


		<!-- 配置数据库链接信息 -->

		<!-- mysql -->
		<jdbcConnection driverClass="${jdbc_driverClassName}"
			connectionURL="${jdbc_url}" userId="${jdbc_username}" password="${jdbc_password}">
		</jdbcConnection>


		<!-- sql server -->
		<!-- <jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver" 
			connectionURL="jdbc:sqlserver://192.168.1.104;DatabaseName=HotelDB" userId="HotelDBUser" 
			password="HOTEL789db&amp;*h"> </jdbcConnection> -->
		<!-- <jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver" 
			connectionURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=HotelDB" 
			userId="sa" password="sa123"> </jdbcConnection> -->

		<!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer true，把JDBC DECIMAL 和 
			NUMERIC 类型解析为java.math.BigDecimal -->
		<javaTypeResolver>
			<property name="forceBigDecimals" value="false" />
		</javaTypeResolver>

		<!-- 指定javabean生成的路径 -->
		<javaModelGenerator targetPackage="com.hotel.model"
			targetProject=".\src\main\java">
			<property name="enableSubPackages" value="true" />
			<!-- 从数据库返回的值被清理前后的空格 -->
			<property name="trimStrings" value="true" />
		</javaModelGenerator>

		<!-- 对应的mapper.xml文件 -->
		<sqlMapGenerator targetPackage="com.hotel.mapper"
			targetProject=".\src\main\java">
			<property name="enableSubPackages" value="true" />
		</sqlMapGenerator>

		<!-- 对应mapper接口类文件 -->
		<javaClientGenerator type="XMLMAPPER"
			targetPackage="com.hotel.dao" targetProject=".\src\main\java">
			<property name="enableSubPackages" value="true" />
		</javaClientGenerator>

		<!-- 指定每个表的生成策略 -->

		<!-- 指定每个表的生成策略 -->
		<table tableName="city" domainObjectName="city"
			enableCountByExample="false" enableUpdateByExample="false"
			enableDeleteByExample="false" enableSelectByExample="false"
			selectByExampleQueryId="false">
			<!-- <property name="useActualColumnNames" value="false" /> -->
		</table>

	</context>
</generatorConfiguration>

3.设置数据库配置文件

jdbc_driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc_url=jdbc\:sqlserver\://127.0.0.1\:1433;databaseName\=testdb
jdbc_username=sa
jdbc_password=sa123

4.编译执行

    右键Run As----Maven build ---输入 mybatis-generator:generate 

   

7.生成文件

City实体类

CityMapper.xml文件

CityMapper 接口