gradle下mybatis自动生成框架的使用 - 好文

自动生成框架的意义

主要为了解决人为添加mapper,模型等工作，减少错误，提交效率！

添加引用build.gradle
configurations { mybatisGenerator } mybatisGenerator
'org.mybatis.generator:mybatis-generator-core:1.3.5' mybatisGenerator
'mysql:mysql-connector-java:5.1.40' mybatisGenerator 'tk.mybatis:mapper:3.3.9'
添加配置文件

sources/mybaits目录
config.properties
# JDBC 驱动类名 jdbc.driverClassName=com.mysql.jdbc.Driver # JDBC URL:
jdbc:mysql:// + 数据库主机地址 + :端口号 + /数据库名
jdbc.url=jdbc:mysql://rm-2ze54unnv814ng1wv3o.mysql.rds.aliyuncs.com:3306/customer_management
# JDBC 用户名及密码 jdbc.username=a jdbc.password=a123 # 生成实体类所在的包
package.model=cn.customer.entity # 生成 mapper 类所在的包
package.mapper=cn.customer.mapper # 生成 mapper xml 文件所在的包，默认存储在 resources 目录下
package.xml=mapper
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> <context id="Mysql" targetRuntime="MyBatis3Simple"
defaultModelType="flat"> <plugin
type="tk.mybatis.mapper.generator.MapperPlugin"> <property name="mappers"
value="cn.management.mapper"/>  <property
name="caseSensitive" value="true"/> </plugin> <commentGenerator> <property
name="suppressAllComments" value="true"/> </commentGenerator> <jdbcConnection
driverClass="${driverClass}" connectionURL="${connectionURL}"
userId="${userId}" password="${password}"> </jdbcConnection>
<javaModelGenerator targetPackage="${modelPackage}"
targetProject="${src_main_java}"/> <sqlMapGenerator
targetPackage="${sqlMapperPackage}" targetProject="${src_main_resources}"/>
<javaClientGenerator targetPackage="${mapperPackage}"
targetProject="${src_main_java}" type="XMLMAPPER"/> 
<table tableName="%"> <generatedKey column="epa_id" sqlStatement="Mysql"
identity="true" /> </table> </context> </generatorConfiguration>
在build.gradle添加脚本
def getDbProperties = { def properties = new Properties()
file("src/main/resources/mybatis/jdbc.properties").withInputStream {
inputStream -> properties.load(inputStream) } properties } task mybatisGenerate
<< { def properties = getDbProperties() ant.properties['targetProject'] =
projectDir.path ant.properties['driverClass'] =
properties.getProperty("jdbc.driverClassName") ant.properties['connectionURL']
= properties.getProperty("jdbc.url") ant.properties['userId'] =
properties.getProperty("jdbc.username") ant.properties['password'] =
properties.getProperty("jdbc.password") ant.properties['src_main_java'] =
sourceSets.main.java.srcDirs[0].path ant.properties['src_main_resources'] =
sourceSets.main.resources.srcDirs[0].path ant.properties['modelPackage'] =
properties.getProperty("package.model") ant.properties['mapperPackage'] =
properties.getProperty("package.mapper") ant.properties['sqlMapperPackage'] =
properties.getProperty("package.xml") ant.taskdef( name: 'mbgenerator',
classname: 'org.mybatis.generator.ant.GeneratorAntTask', classpath:
configurations.mybatisGenerator.asPath ) ant.mbgenerator(overwrite: true,
configfile: 'src/main/resources/mybatis/generatorConfig.xml', verbose: true) {
propertyset { propertyref(name: 'targetProject') propertyref(name: 'userId')
propertyref(name: 'driverClass') propertyref(name: 'connectionURL')
propertyref(name: 'password') propertyref(name: 'src_main_java')
propertyref(name: 'src_main_resources') propertyref(name: 'modelPackage')
propertyref(name: 'mapperPackage') propertyref(name: 'sqlMapperPackage') } } }
在左侧gradle工具栏里可以找到mybatisGenerate,然后点击发布即可。

热门工具换一换