使用 maven 插件 generate 生成mybatis相关文件
在项目中增加 maven 依赖
- mybatis-spring-boot-starter - mysql-connector-java - mybatis-generator-maven-plugin 插件 自动读取 resources 下的generatorconfig.xml 文件
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 |
<?xml version= "1.0" encoding= "utf-8" ?> <project xmlns= "http://maven.apache.org/pom/4.0.0" xmlns:xsi= "http://HdhCmsTestw3.org/2001/xmlschema-instance" xsi:schemalocation= "http://maven.apache.org/pom/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" > <modelversion> 4.0 . 0 </modelversion> <groupid>com.wangspringboot</groupid> <artifactid>demo</artifactid> <version> 0.0 . 1 -snapshot</version> <packaging>jar</packaging> <name>demo</name> <description>demo project for spring boot</description> <parent> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-parent</artifactid> <version> 2.0 . 3 .release</version> <relativepath/> <!-- lookup parent from repository --> </parent> <properties> <project.build.sourceencoding>utf- 8 </project.build.sourceencoding> <project.reporting.outputencoding>utf- 8 </project.reporting.outputencoding> <java.version> 1.8 </java.version> </properties> <dependencies> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-web</artifactid> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-configuration-processor</artifactid> <optional> true </optional> </dependency> <!-- https: //mvnrepository测试数据/artifact/org.projectlombok/lombok --> <dependency> <groupid>org.projectlombok</groupid> <artifactid>lombok</artifactid> <version> 1.16 . 18 </version> <scope>provided</scope> </dependency> <!--热部署--> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-devtools</artifactid> <optional> true </optional> </dependency> <!--test--> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-test</artifactid> <scope>test</scope> </dependency> <!--mybatis--> <dependency> <groupid>org.mybatis.spring.boot</groupid> <artifactid>mybatis-spring-boot-starter</artifactid> <version> 1.3 . 1 </version> </dependency> <!--mysql jdbc驱动--> <dependency> <groupid>mysql</groupid> <artifactid>mysql-connector-java</artifactid> </dependency> </dependencies> <build> <plugins> <plugin> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-maven-plugin</artifactid> <configuration> <fork> true </fork> </configuration> </plugin> <plugin> <groupid>org.mybatis.generator</groupid> <artifactid>mybatis-generator-maven-plugin</artifactid> <version> 1.3 . 7 </version> <executions> <execution> <id>generate mybatis artifacts</id> <goals> <goal>generate</goal> </goals> </execution> </executions> <dependencies> <dependency> <groupid>org.hsqldb</groupid> <artifactid>hsqldb</artifactid> <version> 2.3 . 4 </version> </dependency> </dependencies> </plugin> </plugins> <resources> <resource> <directory>src/main/java</directory> <includes> <include>** /*.xml</include> </includes> </resource> <resource> <directory>src/main/resources</directory> <includes> <include>**/*.*</include> </includes> </resource> <resource> <directory>src/main/webapp</directory> <targetpath>meta-inf/resources</targetpath> <includes> <include>**/ *.*</include> </includes> </resource> </resources> </build> </project> |
springboot 项目中application.properties 配置
mybatis.mapper-locations 用来指定mapper 存放路径 spring.datasource.username 用来指定 用户名 spring.datasource.password 用来指定密码 spring.datasource.driver-class-name 用来指定链接驱动 spring.datasource.url 用来指定链接路由地址
|
1 2 3 4 5 |
mybatis.mapper-locations=classpath:com/wangspringboot/demo/mapper/*.xml spring.datasource.username=root spring.datasource.password=root spring.datasource.driver- class -name=com.mysql.jdbc.driver spring.datasource.url=jdbc:mysql: //localhost:3306/wt?useunicode=true&characterencoding=utf8&usessl=false |
resources 下配置 generatorconfig.xml
此项内容为直接修改相关配置即可
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
<?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> <!-- 本地数据库驱动程序jar包的全路径 --> <classpathentry location= "d:\program files\mavenrepository\mysql\mysql-connector-java\5.1.46\mysql-connector-java-5.1.46.jar" /> <context id= "context" targetruntime= "mybatis3" > <commentgenerator> <property name= "suppressallcomments" value= "false" /> <property name= "suppressdate" value= "true" /> </commentgenerator> <!-- 数据库的相关配置 --> <jdbcconnection driverclass= "com.mysql.jdbc.driver" connectionurl= "jdbc:mysql://localhost:3306/wt" userid= "root" password= "root" /> <javatyperesolver> <property name= "forcebigdecimals" value= "false" /> </javatyperesolver> <!-- 实体类生成的位置 --> <javamodelgenerator targetpackage= "com.wangspringboot.demo.model" targetproject= "src/main/java" > <property name= "enablesubpackages" value= "false" /> <property name= "trimstrings" value= "true" /> </javamodelgenerator> <!-- *mapper.xml 文件的位置 --> <sqlmapgenerator targetpackage= "com.wangspringboot.demo.mapper" targetproject= "src/main/java" > <property name= "enablesubpackages" value= "false" /> </sqlmapgenerator> <!-- mapper 接口文件的位置 --> <javaclientgenerator targetpackage= "com.wangspringboot.demo.mapper" targetproject= "src/main/java" type= "xmlmapper" > <property name= "enablesubpackages" value= "false" /> </javaclientgenerator> <!-- 相关表的配置--> <table tablename= "t" domainobjectname= "tq" enablecountbyexample= "false" enableupdatebyexample= "false" enabledeletebyexample= "false" enableselectbyexample= "false" selectbyexamplequeryid= "false" /> </context> </generatorconfiguration> |
创建相关目录
查看插件
执行
选中maven 下 generator 双击运行
springbootmybatis 使用
在 service 的实现类上添加 @service 注解
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
@service public class tqserviceimpl implements tqservice { @autowired private tqmapper tqmapper; @override public tq instq() { tq t = new tq(); t.setz( 12.0 ); t.sety( 12.0 ); t.setx( 12.0 ); tqmapper.insert(t); return t; } } |
相关调用
|
1 2 3 4 5 6 7 8 9 |
@restcontroller public class mybatiscontroller { @autowired private tqservice tqservice; @getmapping ( "/boot/tq" ) public object tq(){ return tqservice.instq(); } } |
启动springboot web项目后 访问
|
1 2 3 4 5 |
{ x: 12 , y: 12 , z: 12 } |
总结
以上就是这篇文章的全部内容了，希望本文的内容对大家的学习或者工作具有一定的参考学习价值，谢谢大家对的支持。如果你想了解更多相关内容请查看下面相关链接
原文链接：https://blog.csdn.net/staHuri/article/details/81097069
查看更多关于在SpringBoot项目中利用maven的generate插件的详细内容...