devbox
我家自动化
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

IDEA基于gradle项目使用mybatis-generator自动生成代码(实例)_idea gradel项目使用mybatis插件

作者：我家自动化 | 2024-03-25 06:07:47

赞

踩

idea gradel项目使用mybatis插件

Mybatis Generator是一个mybatis工具项目，用于生成mybatis的model,mapper,dao持久层代码。MybatisGenerator提供了maven plugin,ant target，java三种方式启动。现在主流的构建工具是gradle,虽然mybatisgenerator没有提供gradle的插件，但gradle可以调用ant任务，因此，gradle也能启动MybatisGenerator。

环境说明

· 数据库:mysql

· 数据库配置文件:src/main/resources/mybatis/db-mysql.properties

· 项目中使用了mybatistk.mybatis:mapper:3.3.2插件


一、数据库准备

  1. /*
  2. Navicat MySQL Data Transfer
  4. Source Server         : aaaa
  5. Source Server Version : 50045
  6. Source Host           : localhost:3306
  7. Source Database       : studentdb
  9. Target Server Type    : MYSQL
  10. Target Server Version : 50045
  11. File Encoding         : 65001
  13. Date: 2015-09-28 16:57:18
  14. */
  15.  
  16. SET FOREIGN_KEY_CHECKS=0;
  17.  
  18. -- ----------------------------
  19. -- Table structure for `admin`
  20. -- ----------------------------
  21. DROP TABLE IF EXISTS `admin`;
  22. CREATE TABLE `admin` (
  23.   `Id` int(11) NOT NULL auto_increment,
  24.   `username` varchar(20) default NULL,
  25.   `password` varchar(20) default NULL,
  26.   `name` varchar(20) default NULL,
  27.   PRIMARY KEY  (`Id`)
  28. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  29.  
  30. -- ----------------------------
  31. -- Records of admin
  32. -- ----------------------------
  33. INSERT INTO `admin` VALUES ('1', 'admin', 'admin', '超级管理员');
  34.  
  35. -- ----------------------------
  36. -- Table structure for `course`
  37. -- ----------------------------
  38. DROP TABLE IF EXISTS `course`;
  39. CREATE TABLE `course` (
  40.   `Id` int(11) NOT NULL,
  41.   `name` varchar(20) default NULL,
  42.   `teacher_id` int(11) default NULL,
  43.   PRIMARY KEY  (`Id`),
  44.   KEY `teacher_course` (`teacher_id`),
  45.   CONSTRAINT `teacher_course` FOREIGN KEY (`teacher_id`) REFERENCES `teacher` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE
  46. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  47.  
  48. -- ----------------------------
  49. -- Records of course
  50. -- ----------------------------
  51. INSERT INTO `course` VALUES ('1', '面向对象程序设计', '201');
  52. INSERT INTO `course` VALUES ('2', '软件项目管理', '202');
  53. INSERT INTO `course` VALUES ('3', '基于ssh框架项目开发', '203');
  54.  
  55. -- ----------------------------
  56. -- Table structure for `score`
  57. -- ----------------------------
  58. DROP TABLE IF EXISTS `score`;
  59. CREATE TABLE `score` (
  60.   `Id` int(11) NOT NULL auto_increment,
  61.   `student_id` int(11) default NULL,
  62.   `course_id` int(11) default NULL,
  63.   `score` double(6,1) default NULL,
  64.   PRIMARY KEY  (`Id`),
  65.   KEY `stu_score` (`student_id`),
  66.   KEY `course_score` (`course_id`),
  67.   CONSTRAINT `course_score` FOREIGN KEY (`course_id`) REFERENCES `course` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE,
  68.   CONSTRAINT `stu_score` FOREIGN KEY (`student_id`) REFERENCES `student` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE
  69. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
  70.  
  71. -- ----------------------------
  72. -- Records of score
  73. -- ----------------------------
  74. INSERT INTO `score` VALUES ('1', '101', '1', '100.0');
  75. INSERT INTO `score` VALUES ('2', '102', '1', '99.0');
  76. INSERT INTO `score` VALUES ('4', '101', '3', '222.0');
  77.  
  78. -- ----------------------------
  79. -- Table structure for `student`
  80. -- ----------------------------
  81. DROP TABLE IF EXISTS `student`;
  82. CREATE TABLE `student` (
  83.   `Id` int(11) NOT NULL,
  84.   `name` varchar(20) default NULL,
  85.   `password` varchar(20) default NULL,
  86.   `sex` int(20) default NULL,
  87.   `clazz` varchar(20) default NULL,
  88.   `birthday` varchar(20) default NULL,
  89.   PRIMARY KEY  (`Id`)
  90. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  91.  
  92. -- ----------------------------
  93. -- Records of student
  94. -- ----------------------------
  95. INSERT INTO `student` VALUES ('101', '林大雷', '1111', '1', '13软件2', '1996-03-24');
  96. INSERT INTO `student` VALUES ('102', '萧炎亮', '0000', '0', '13软件1', '1995-08-01');
  97. INSERT INTO `student` VALUES ('103', '叶凡凯', '0000', '1', '13软件1', '1994-01-23');
  98. INSERT INTO `student` VALUES ('104', '李牧尘', '1111', '0', '13软件1', '1997-12-05');
  99. INSERT INTO `student` VALUES ('105', '刘红枫', '0000', '1', '13软件2', '1995-11-15');
  100.  
  101. -- ----------------------------
  102. -- Table structure for `teacher`
  103. -- ----------------------------
  104. DROP TABLE IF EXISTS `teacher`;
  105. CREATE TABLE `teacher` (
  106.   `Id` int(11) NOT NULL,
  107.   `name` varchar(20) default NULL,
  108.   `password` varchar(20) default NULL,
  109.   `sex` int(11) default NULL,
  110.   `birthday` varchar(20) default NULL,
  111.   `course_id` int(11) default NULL,
  112.   `professional` varchar(20) default NULL,
  113.   PRIMARY KEY  (`Id`),
  114.   KEY `course_teacher` (`course_id`),
  115.   CONSTRAINT `course_teacher` FOREIGN KEY (`course_id`) REFERENCES `course` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE
  116. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  117.  
  118. -- ----------------------------
  119. -- Records of teacher
  120. -- ----------------------------
  121. INSERT INTO `teacher` VALUES ('201', '李青山', '0000', '1', '1965-01-01', '1', '教授');
  122. INSERT INTO `teacher` VALUES ('202', '唐嫣然', '0000', '1', '1968-01-01', '2', '教授');
  123. INSERT INTO `teacher` VALUES ('203', '萧玄茂', '0000', '1', '1978-01-01', '3', '高级教师');


二、db-mysql.properties内容

  1. # JDBC 驱动类名
  2.  
  3. # JDBC URL: jdbc:mysql:// + 数据库主机地址 + 端口号 + 数据库名
  4. jdbc.url=jdbc:mysql://localhost:3306/test
  5. # JDBC 用户名及密码
  6. jdbc.user=root
  7. jdbc.pass=123
  8. jdbc.driverClassName=com.mysql.jdbc.Driver
  9. # 生成实体类所在的包
  10. package.model=com.ssm.model
  11. # 生成 mapper 类所在的包
  12. package.mapper=com.ssm.dao
  13. # 生成 mapper xml 文件所在的包，默认存储在 resources 目录下
  14. package.xml=mapper

三、generatorConfig.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE generatorConfiguration
  3.         PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
  5. <generatorConfiguration>
  6.     <context id="MysqlContext" targetRuntime="MyBatis3" defaultModelType="flat">
  7.         <property name="beginningDelimiter" value="`"/>
  8.         <property name="endingDelimiter" value="`"/>
  9.  
  10.         <commentGenerator>
  11.             <property name="suppressDate" value="true"/>
  12.         </commentGenerator>
  13.         <jdbcConnection driverClass="${driverClass}"
  14.                         connectionURL="${connectionURL}"
  15.                         userId="${userId}"
  16.                         password="${password}">
  17.         </jdbcConnection>
  18.         <javaModelGenerator targetPackage="${modelPackage}" targetProject="${src_main_java}"/>
  19.         <sqlMapGenerator targetPackage="${sqlMapperPackage}" targetProject="${src_main_resources}"/>
  20.         <javaClientGenerator targetPackage="${mapperPackage}" targetProject="${src_main_java}" type="XMLMAPPER"/>
  21.         <!-- sql占位符，表示所有的表 -->
  22.         
  23. <table tableName="%" enableCountByExample="false" enableUpdateByExample="false"
  24.        enableDeleteByExample="false" enableSelectByExample="false"
  25.        selectByExampleQueryId="false">
  26.  
  27. </table>
  28.  
  29.     </context>
  30. </generatorConfiguration>

四、build.gradle的配置

    1.步骤说明 
  1. 1、添加
  2. configurations {
  3.     mybatisGenerator
  4. }
  5. 2、添加依赖
  6. mybatisGenerator 'org.mybatis.generator:mybatis-generator-core:1.3.2'
  7. mybatisGenerator 'mysql:mysql-connector-java:5.1.38'
  8. mybatisGenerator 'tk.mybatis:mapper:3.3.1'
  9. 3、添加任务
  10. def getDbProperties = {
  11.     def properties = new Properties()
  12.     file("src/main/resources/mybatis/db-mysql.properties").withInputStream { inputStream ->
  13.         properties.load(inputStream)
  14.     }
  15.     properties;
  16. }
  17. task mybatisGenerate << {
  18.     def properties = getDbProperties()
  19.     ant.properties['targetProject'] = projectDir.path
  20.     ant.properties['driverClass'] = properties.getProperty("jdbc.driverClassName")
  21.     ant.properties['connectionURL'] = properties.getProperty("jdbc.url")
  22.     ant.properties['userId'] = properties.getProperty("jdbc.user")
  23.     ant.properties['password'] = properties.getProperty("jdbc.pass")
  24.     ant.properties['src_main_java'] = sourceSets.main.java.srcDirs[0].path
  25.     ant.properties['src_main_resources'] = sourceSets.main.resources.srcDirs[0].path
  26.     ant.properties['modelPackage'] = properties.getProperty("package.model")
  27.     ant.properties['mapperPackage'] = properties.getProperty("package.mapper")
  28.     ant.properties['sqlMapperPackage'] =properties.getProperty("package.xml")
  29.     ant.taskdef(
  30.             name: 'mbgenerator',
  31.             classname: 'org.mybatis.generator.ant.GeneratorAntTask',
  32.             classpath: configurations.mybatisGenerator.asPath
  33.     )
  34.     ant.mbgenerator(overwrite: true,
  35.             configfile: 'src/main/resources/mybatis/generatorConfig.xml', verbose: true) {
  36.         propertyset {
  37.             propertyref(name: 'targetProject')
  38.             propertyref(name: 'userId')
  39.             propertyref(name: 'driverClass')
  40.             propertyref(name: 'connectionURL')
  41.             propertyref(name: 'password')
  42.             propertyref(name: 'src_main_java')
  43.             propertyref(name: 'src_main_resources')
  44.             propertyref(name: 'modelPackage')
  45.             propertyref(name: 'mapperPackage')
  46.             propertyref(name: 'sqlMapperPackage')
  47.         }
  48.     }
  49. }

    2.完整build.gradle配置

  1. group 'person.xjl'
  2. version '1.0-SNAPSHOT'
  3.  
  4. apply plugin: 'java'
  5. apply plugin: 'war'
  6.  
  7. sourceCompatibility = 1.8
  8. ext {
  9.     spring_version = "4.3.14.RELEASE"
  10. }
  11. repositories {
  12.     maven {
  13.         url 'http://maven.aliyun.com/nexus/content/groups/public/'
  14.     }
  15.     mavenCentral()
  16. }
  17.  
  18. //1、添加
  19. configurations {
  20.     mybatisGenerator
  21. }
  22.  
  23. dependencies {
  24.     testCompile group: 'junit', name: 'junit', version: '4.11'
  25.     // https://mvnrepository.com/artifact/org.springframework/spring-webmvc
  26. //springmvc + Spring Configuration
  27.     compile "org.springframework:spring-web:$spring_version"
  28.     compile "org.springframework:spring-webmvc:$spring_version"
  29.     compile "org.springframework:spring-aop:$spring_version"
  30.     compile "org.springframework:spring-aspects:$spring_version"
  31.     compile "org.springframework:spring-beans:$spring_version"
  32.     compile "org.springframework:spring-context:$spring_version"
  33.     compile "org.springframework:spring-context-support:$spring_version"
  34.     compile "org.springframework:spring-core:$spring_version"
  35.     compile "org.springframework:spring-expression:$spring_version"
  36.     compile "org.springframework:spring-jdbc:$spring_version"
  37.     compile "org.springframework:spring-messaging:$spring_version"
  38.     compile "org.springframework:spring-orm:$spring_version"
  39.     compile "org.springframework:spring-tx:$spring_version"
  40.     compile "org.springframework:spring-test:$spring_version"
  41.  
  42. //MyBatis
  43.     compile "org.mybatis:mybatis:3.4.1"
  44. //mybatis spring 插件
  45.     compile "org.mybatis:mybatis-spring:1.3.1"// https://mvnrepository.com/artifact/javax.servlet/jstl
  46.     compile group: 'javax.servlet', name: 'jstl', version: '1.2'
  47. // https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api
  48.     compile group: 'javax.servlet', name: 'javax.servlet-api', version: '3.1.0'
  49. // https://mvnrepository.com/artifact/javax/javaee-api
  50.     compile group: 'javax', name: 'javaee-api', version: '7.0'
  51. // https://mvnrepository.com/artifact/mysql/mysql-connector-java
  52.     compile group: 'mysql', name: 'mysql-connector-java', version: '5.1.21'
  53.  
  54.  
  55. //公共资源包
  56.     compile "commons-logging:commons-logging:1.2"
  57.     compile "commons-lang:commons-lang:2.6"
  58.     compile "org.apache.commons:commons-collections4:4.0"
  59.     compile "commons-beanutils:commons-beanutils:1.8.3"
  60.     compile "commons-dbcp:commons-dbcp:1.4"
  61.     compile "commons-pool:commons-pool:1.6"
  62.  
  63.     compile group: 'log4j', name: 'log4j', version: '1.2.17'
  64.  
  65.     //2、添加依赖
  66.     mybatisGenerator 'org.mybatis.generator:mybatis-generator-core:1.3.2'
  67.     mybatisGenerator 'mysql:mysql-connector-java:5.1.21'
  68.     mybatisGenerator 'tk.mybatis:mapper:3.3.1'
  69.  
  70. }
  71.  
  72. //3、添加任务
  73. def getDbProperties = {
  74.     def properties = new Properties()
  75.     file("src/main/resources/mybatis/db-mysql.properties").withInputStream { inputStream ->
  76.         properties.load(inputStream)
  77.     }
  78.     properties;
  79. }
  80. task mybatisGenerate << {
  81.     def properties = getDbProperties()
  82.     ant.properties['targetProject'] = projectDir.path
  83.     ant.properties['driverClass'] = properties.getProperty("jdbc.driverClassName")
  84.     ant.properties['connectionURL'] = properties.getProperty("jdbc.url")
  85.     ant.properties['userId'] = properties.getProperty("jdbc.user")
  86.     ant.properties['password'] = properties.getProperty("jdbc.pass")
  87.     ant.properties['src_main_java'] = sourceSets.main.java.srcDirs[0].path
  88.     ant.properties['src_main_resources'] = sourceSets.main.resources.srcDirs[0].path
  89.     ant.properties['modelPackage'] = properties.getProperty("package.model")
  90.     ant.properties['mapperPackage'] = properties.getProperty("package.mapper")
  91.     ant.properties['sqlMapperPackage'] =properties.getProperty("package.xml")
  92.     ant.taskdef(
  93.             name: 'mbgenerator',
  94.             classname: 'org.mybatis.generator.ant.GeneratorAntTask',
  95.             classpath: configurations.mybatisGenerator.asPath
  96.     )
  97.     ant.mbgenerator(overwrite: true,
  98.             configfile: 'src/main/resources/mybatis/generatorConfig.xml', verbose: true) {
  99.         propertyset {
  100.             propertyref(name: 'targetProject')
  101.             propertyref(name: 'userId')
  102.             propertyref(name: 'driverClass')
  103.             propertyref(name: 'connectionURL')
  104.             propertyref(name: 'password')
  105.             propertyref(name: 'src_main_java')
  106.             propertyref(name: 'src_main_resources')
  107.             propertyref(name: 'modelPackage')
  108.             propertyref(name: 'mapperPackage')
  109.             propertyref(name: 'sqlMapperPackage')
  110.         }
  111.     }
  112. }


 五、运行

在gradle中刷新，点开module下的other,里找到mybatisGenarate，双击



声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/我家自动化/article/detail/307489
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号