一、添加所需依賴，當前完整的pom文件如下：
|
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
|
<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> <parent> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-parent</artifactid> <version>1.5.6.release</version> </parent> <groupid>org.rcddup</groupid> <artifactid>rcddup-custom</artifactid> <version>1.0.0</version> <properties> <java.version>1.8</java.version> <mybatis.version>1.3.1</mybatis.version> <mapper.version>3.4.3</mapper.version> <mybatis-generator.version>1.3.3</mybatis-generator.version> <mybatis-tk.version>1.1.4</mybatis-tk.version> <pagehelper.version>1.2.1</pagehelper.version> </properties> <dependencies> <!-- springboot - web --> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-web</artifactid> </dependency> <!-- springboot - mybatis --> <dependency> <groupid>org.mybatis.spring.boot</groupid> <artifactid>mybatis-spring-boot-starter</artifactid> <version>${mybatis.version}</version> </dependency> <!-- springboot - mybatis 逆向工程 --> <dependency> <groupid>org.mybatis.generator</groupid> <artifactid>mybatis-generator-core</artifactid> <version>${mybatis-generator.version}</version> </dependency> <!-- mybatis 通用 mapper --> <dependency> <groupid>tk.mybatis</groupid> <artifactid>mapper-spring-boot-starter</artifactid> <version>${mybatis-tk.version}</version> </dependency> <!-- mysql --> <dependency> <groupid>mysql</groupid> <artifactid>mysql-connector-java</artifactid> </dependency> </dependencies> <build> <plugins> <!-- mybatis 逆向工程 插件 --> <plugin> <groupid>org.mybatis.generator</groupid> <artifactid>mybatis-generator-maven-plugin</artifactid> <version>${mybatis.generator.version}</version> <dependencies> <dependency> <groupid>mysql</groupid> <artifactid>mysql-connector-java</artifactid> <version>${mysql.version}</version> </dependency> <dependency> <groupid>tk.mybatis</groupid> <artifactid>mapper</artifactid> <version>${mapper.version}</version> </dependency> </dependencies> <configuration> <!-- 允許移動生成的文件 --> <verbose>true</verbose> <!-- 是否覆蓋 --> <overwrite>true</overwrite> <!-- 配置文件 --> <configurationfile> ${basedir}/src/main/resources/generator/generatorconfig.xml </configurationfile> </configuration> </plugin> </plugins> </build></project> |
mybtais 結合通用 mapper 非常好使，接下來看逆向工程的配置。
有關通用mapper的信息，請查看：https://github.com/abel533/mapper
二、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
|
<?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> <!-- 引入 application.properties --> <properties resource="application.properties" /> <!-- mybatis3simple：不生成 example相關類及方法 --> <context id="mysql" targetruntime="mybatis3simple" defaultmodeltype="flat"> <property name="beginningdelimiter" value="`" /> <property name="endingdelimiter" value="`" /> <!-- 指定生成 mapper 的繼承模板 --> <plugin type="tk.mybatis.mapper.generator.mapperplugin"> <property name="mappers" value="${generator.mappers}" /> </plugin> <!-- 生成 javabean 對象重寫 tostring方法 --> <plugin type="org.mybatis.generator.plugins.tostringplugin" /> <!-- 生成 javabean 對象繼承 serializable 類 --> <plugin type="org.mybatis.generator.plugins.serializableplugin" /> <!-- 生成 javabean 對象重寫 equals 和 hashcode 方法 --> <!-- <plugin type="org.mybatis.generator.plugins.equalshashcodeplugin" /> --> <!-- jdbc 連接配置 --> <jdbcconnection driverclass="${spring.datasource.driver-class-name}" connectionurl="${spring.datasource.url}" userid="${spring.datasource.username}" password="${spring.datasource.password}"> </jdbcconnection> <javamodelgenerator targetpackage="${generator.javamodel-targetpackage}" targetproject="${generator.targetproject}" /> <sqlmapgenerator targetpackage="${generator.sqlmap-targetpackage}" targetproject="${generator.targetproject}" /> <javaclientgenerator targetpackage="${generator.javaclient-targetpackage}" targetproject="${generator.targetproject}" type="xmlmapper" /> <!-- mysql 配置 --> <!-- <generatedkey column="id" sqlstatement="mysql" identity="true" /> --> <!-- oracle 配置 --> <!-- <generatedkey column="id" sqlstatement="select seq_{1}.nextval from dual" identity="false" type="pre"/> --> <!-- tablename：數據庫表名，domainobjectname：生成文件名 ，schema：數據源--> <table tablename="user"> <generatedkey column="id" sqlstatement="mysql" identity="true" /> </table> </context></generatorconfiguration> |
我們將對應的信息都在 application.properties 中定義好，在這直接使用，application.properties如下：
|
1
2
3
4
5
6
|
# generatorgenerator.targetproject=src/main/javagenerator.mappers=org.rcddup.app.common.base.ibasemappergenerator.javamodel-targetpackage=org.rcddup.app.domaingenerator.sqlmap-targetpackage=org.rcddup.app.daogenerator.javaclient-targetpackage=org.rcddup.app.dao |
三、編寫生成mapper的集成接口ibasemapper
|
1
2
3
4
5
|
package org.rcddup.app.common.base;import tk.mybatis.mapper.common.mapper;import tk.mybatis.mapper.common.mysqlmapper;public interface ibasemapper<t> extends mapper<t>, mysqlmapper<t> {} |
集成的 mapper 以及 mysqlmapper 幾乎包含了你所有的 crud方法。
四、使用逆向工程生成我們的第一個文件
右鍵項目 --> maven --> maven build --> goals: mybtais-generator:generate，點擊 run.....
我們的usermapper以及usermapper.xml就生成了。
（1）usermapper.java
|
1
2
3
4
5
|
package org.rcddup.app.dao;import org.rcddup.app.common.base.ibasemapper;import org.rcddup.app.domain.user;public interface usermapper extends ibasemapper<user> {} |
（2）usermapper.xml
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
<?xml version="1.0" encoding="utf-8"?><!doctype mapper public "-//mybatis.org//dtd mapper 3.0//en" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="org.rcddup.app.dao.usermapper"> <resultmap id="baseresultmap" type="org.rcddup.app.domain.user"> <!-- warning - @mbg.generated --> <id column="id" jdbctype="bigint" property="id" /> <result column="name" jdbctype="varchar" property="name" /> <result column="age" jdbctype="tinyint" property="age" /> <result column="status" jdbctype="tinyint" property="status" /> </resultmap></mapper> |
是不是發現xml中都沒有配置任何crud方法。
五、重新編寫 userservice.java
我們原先編寫的 userservice 現在我們用新生成的 usermapper 來重新編寫。
|
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
|
package org.rcddup.app.service.impl;import java.util.list;import org.rcddup.app.dao.usermapper;import org.rcddup.app.domain.user;import org.rcddup.app.service.iuserservice;import org.springframework.beans.factory.annotation.autowired;import org.springframework.stereotype.service;import tk.mybatis.mapper.entity.example;@servicepublic class userservice implements iuserservice{ @autowired private usermapper usermapper; @override public list<user> listuser() { return usermapper.selectall(); } @override public user getuserbyid(long id) { // 方法一：適用于任何字段的查詢// example example = new example(user.class);// example.createcriteria().andequalto("id", id);// list<user> list = usermapper.selectbyexample(example);// if (list != null && list.size() > 0) {// return list.get(0);// } else {// return null;// } // 方法二：只適用于主鍵字段 return usermapper.selectbyprimarykey(id); }} |
六、啟動 app.java
輸入：localhost:8080/user/get?id=1
輸入：localhost:8080/user/list
好了，到這我們整合了mybatis逆向工程以及通用mapper。
總結
以上所述是小編給大家介紹的springboot整合mybatis逆向工程及 mybatis通用mapper實例詳解 ，希望對大家有所幫助，如果大家有任何疑問歡迎給我留言，小編會及時回復大家的！
原文鏈接：http://www.cnblogs.com/rcddup/archive/2017/09/16/7530401.html
