使用maven 插件 generate生成mybatis相關(guān)文件
在項目中增加 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驅(qū)動--> <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 用來指定鏈接驅(qū)動
- spring.datasource.url 用來指定鏈接路由地址
|
1
2
3
4
5
|
mybatis.mapper-locations=classpath:com/wangspringboot/demo/mapper/*.xmlspring.datasource.username=rootspring.datasource.password=rootspring.datasource.driver-class-name=com.mysql.jdbc.driverspring.datasource.url=jdbc:mysql://localhost:3306/wt?useunicode=true&characterencoding=utf8&usessl=false |
resources 下配置 generatorconfig.xml
此項內(nèi)容為直接修改相關(guān)配置即可
|
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> <!-- 本地數(shù)據(jù)庫驅(qū)動程序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> <!-- 數(shù)據(jù)庫的相關(guān)配置 --> <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> <!-- 相關(guān)表的配置--> <table tablename="t" domainobjectname="tq" enablecountbyexample="false" enableupdatebyexample="false" enabledeletebyexample="false" enableselectbyexample="false" selectbyexamplequeryid="false" /> </context></generatorconfiguration> |
創(chuàng)建相關(guān)目錄
查看插件
執(zhí)行
選中maven 下 generator 雙擊運行
springbootmybatis 使用
在 service 的實現(xiàn)類上添加 @service 注解
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
@servicepublic 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; }} |
相關(guān)調(diào)用
|
1
2
3
4
5
6
7
8
9
|
@restcontrollerpublic 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} |
總結(jié)
以上就是這篇文章的全部內(nèi)容了，希望本文的內(nèi)容對大家的學習或者工作具有一定的參考學習價值，謝謝大家對服務器之家的支持。如果你想了解更多相關(guān)內(nèi)容請查看下面相關(guān)鏈接
原文鏈接：https://blog.csdn.net/staHuri/article/details/81097069
