使用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://www.w3.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.com/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