用mybatis-generator自动生成JAVA的实体类和mapping等
1.引入mybatis-generator-core jar包
在项目pom.xml文件下
<properties> </properties>中加入:
<!-- Java接口和实体类 --> <targetJavaProject>${basedir}/src/main/java</targetJavaProject> <targetMapperPackage>com.machbusiness.mapper</targetMapperPackage> <targetModelPackage>com.machbusiness.entity</targetModelPackage> <!-- XML生成路径 --> <targetResourcesProject>${basedir}/src/main/resources</targetResourcesProject> <targetXMLPackage>mybatis</targetXMLPackage> <!-- 依赖版本 --> <mapper.version>3.4.0</mapper.version> <mybatis.version>3.3.1</mybatis.version> <mybatis.spring.version>1.2.4</mybatis.spring.version> <pagehelper.version>4.1.1</pagehelper.version>
<plugins> </plugins>中加入
<!-- 此插件用来生成通用mapper的代码 --> <plugin> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.2</version> <configuration> <configurationFile>${basedir}/src/main/resources/generatorConfig.xml</configurationFile> <overwrite>true</overwrite> <verbose>true</verbose> </configuration> <dependencies> <dependency> <groupId>oracle</groupId> <artifactId>ojdbc14</artifactId> <version>11.2.0.4</version> </dependency> <dependency> <groupId>tk.mybatis</groupId> <artifactId>mapper</artifactId> <version>${mapper.version}</version> </dependency> </dependencies> </plugin>
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="D:\BankOfZhihui\.m2\repository\oracle\ojdbc14\11.2.0.4"/> <context id="Oracle" targetRuntime="MyBatis3Simple" defaultModelType="flat"> <property name="beginningDelimiter" value="`"/> <property name="endingDelimiter" value="`"/> <property name="mergeable" value="false"></property> <plugin type="tk.mybatis.mapper.generator.MapperPlugin"> <property name="mappers" value="tk.mybatis.mapper.common.Mapper"/> </plugin> <!--数据库链接地址账号密码--> <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@192.168.2.4:21521:orcl" userId="" password=""> </jdbcConnection> <!--生成Model类存放位置--> <javaModelGenerator targetPackage="${targetModelPackage}" targetProject="${targetJavaProject}"/> <!--生成映射文件存放位置--> <sqlMapGenerator targetPackage="${targetXMLPackage}" targetProject="${targetResourcesProject}"/> <!--生成Dao类存放位置--> <javaClientGenerator targetPackage="${targetMapperPackage}" targetProject="${targetJavaProject}" type="XMLMAPPER"/> <!-- 要生成的表 tableName是数据库中的表名或视图名 domainObjectName是实体类名--> <table tableName="" domainObjectName=""></table> </context> </generatorConfiguration>
3.双击下图指示的命令,生成实体类等。