SpringBoot + MyBatis 整合 和 Maven多模块运行、打包

avatar 2018年07月24日13:12:42 6 10887 views
博主分享免费Java教学视频，B站账号：Java刘哥 ，长期提供技术问题解决、项目定制：本站商品点此
以前我们都是将各个层放在一个项目里，后期维护可能不太方便，代码结构也不清晰。

本文先如何使用 Maven 多模块开发，然后再讲一下 SpringBoot 和 MyBatis 整合

文件结构如下





其中 summer 是父项目，summer-dao、summer-service、summer-web 是子项目。

summer-web 依赖 summer-service，summer-service 依赖 summer-dao


一、新建项目


1、新建 Maven 项目，作为父项目，然后删除掉 src 之类的目录，只需要保留一个 pom.xml





pom.xml 内容如下
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0"
  3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  5.     <modelVersion>4.0.0</modelVersion>
  7.     <groupId>com.liuyanzhao.summer</groupId>
  8.     <artifactId>summer</artifactId>
  9.     <packaging>pom</packaging>
  10.     <version>1.0-SNAPSHOT</version>
  12.     <!--关键-->
  13.     <modules>
  14.         <module>summer-service</module>
  15.         <module>summer-web</module>
  16.         <module>summer-dao</module>
  17.     </modules>
  19.     <parent>
  20.         <groupId>org.springframework.boot</groupId>
  21.         <artifactId>spring-boot-starter-parent</artifactId>
  22.         <version>1.5.9.RELEASE</version>
  23.         <relativePath/> <!-- lookup parent from repository -->
  24.     </parent>
  26.     <properties>
  27.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  28.         <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
  29.         <java.version>1.8</java.version>
  30.         <kotlin.version>1.0.6</kotlin.version>
  31.     </properties>
  33.     <dependencies>
  34.         <dependency>
  35.             <groupId>org.springframework.boot</groupId>
  36.             <artifactId>spring-boot-starter-web</artifactId>
  37.         </dependency>
  38.         <dependency>
  39.             <groupId>org.springframework.boot</groupId>
  40.             <artifactId>spring-boot-starter-test</artifactId>
  41.             <scope>test</scope>
  42.         </dependency>
  43.         <dependency>
  44.             <groupId>junit</groupId>
  45.             <artifactId>junit</artifactId>
  46.             <version>4.12</version>
  47.         </dependency>
  48.         <dependency>
  49.             <groupId>com.alibaba</groupId>
  50.             <artifactId>fastjson</artifactId>
  51.             <version>1.1.23</version>
  52.         </dependency>
  53.         <dependency>
  54.             <groupId>org.springframework.boot</groupId>
  55.             <artifactId>spring-boot-devtools</artifactId>
  56.             <optional>true</optional>
  57.         </dependency>
  58.         <dependency>
  59.             <groupId>org.projectlombok</groupId>
  60.             <artifactId>lombok</artifactId>
  61.             <optional>true</optional>
  62.         </dependency>
  63.     </dependencies>
  66.     <build>
  67.         <resources>
  68.             <resource>
  69.                 <directory>src/main/resource</directory>
  70.                 <includes>
  71.                     <include>**/*.properties</include>
  72.                     <include>**/*.xml</include>
  73.                 </includes>
  74.                 <filtering>false</filtering>
  75.             </resource>
  76.         </resources>
  78.         <!--spring boot打包的话需要指定一个唯一的入门-->
  79.         <plugins>
  80.             <plugin>
  81.                 <groupId>org.springframework.boot</groupId>
  82.                 <artifactId>spring-boot-maven-plugin</artifactId>
  83.                 <configuration>
  84.                     <!-- 指定该Main Class为全局的唯一入口 -->
  85.                     <mainClass>com.liuyanzhao.summer.SummerApplication</mainClass>
  86.                     <layout>ZIP</layout>
  87.                 </configuration>
  88.                 <executions>
  89.                     <execution>
  90.                         <goals>
  91.                             <goal>repackage</goal><!--可以把依赖的包都打包到生成的Jar包中-->
  92.                         </goals>
  93.                     </execution>
  94.                 </executions>
  95.             </plugin>
  96.         </plugins>
  97.     </build>
  98. </project>



2、summer-dao 的 pom.xml
  1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  2.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  4.     <!--关键-->
  5.     <parent>
  6.         <artifactId>summer</artifactId>
  7.         <groupId>com.liuyanzhao.summer</groupId>
  8.         <version>1.0-SNAPSHOT</version>
  9.     </parent>
  10.     <modelVersion>4.0.0</modelVersion>
  13.     <artifactId>summer-dao</artifactId>
  14.     <packaging>jar</packaging>
  15.     <version>1.0-SNAPSHOT</version>
  17.     <name>dao</name>
  18.     <url>http://maven.apache.org</url>
  20.     <properties>
  21.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  22.     </properties>
  24.     <dependencies>
  25.         <dependency>
  26.             <groupId>mysql</groupId>
  27.             <artifactId>mysql-connector-java</artifactId>
  28.             <version>5.1.30</version>
  29.         </dependency>
  31.         <!--mybatis-->
  32.         <dependency>
  33.             <groupId>org.mybatis.spring.boot</groupId>
  34.             <artifactId>mybatis-spring-boot-starter</artifactId>
  35.             <version>1.3.0</version>
  36.         </dependency>
  38.         <dependency>
  39.             <groupId>org.mybatis.generator</groupId>
  40.             <artifactId>mybatis-generator-core</artifactId>
  41.             <version>1.3.5</version>
  42.         </dependency>
  44.     </dependencies>
  47.     <build>
  48.         <finalName>summer-dao</finalName>
  50.         <resources>
  51.             <resource>
  52.                 <directory>src/main/resource</directory>
  53.                 <includes>
  54.                     <include>**/*.properties</include>
  55.                     <include>**/*.xml</include>
  56.                 </includes>
  57.                 <filtering>false</filtering>
  58.             </resource>
  59.         </resources>
  61.         <plugins>
  62.             <plugin>
  63.                 <groupId>org.springframework.boot</groupId>
  64.                 <artifactId>spring-boot-maven-plugin</artifactId>
  65.                 <configuration>
  66.                     <classifier>exec</classifier>
  67.                 </configuration>
  68.             </plugin>
  69.         </plugins>
  70.     </build>
  71. </project>



3、summer-service 的 pom.xml
  1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  2.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  3.     <!--关键-->
  4.     <parent>
  5.         <artifactId>summer</artifactId>
  6.         <groupId>com.liuyanzhao.summer</groupId>
  7.         <version>1.0-SNAPSHOT</version>
  8.     </parent>
  9.     <modelVersion>4.0.0</modelVersion>
  11.     <artifactId>summer-service</artifactId>
  12.     <packaging>jar</packaging>
  13.     <version>1.0-SNAPSHOT</version>
  14.     <name>service</name>
  15.     <url>http://maven.apache.org</url>
  17.     <properties>
  18.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  19.     </properties>
  21.     <dependencies>
  22.         <!--依赖summer-dao-->
  23.         <dependency>
  24.             <groupId>com.liuyanzhao.summer</groupId>
  25.             <artifactId>summer-dao</artifactId>
  26.             <version>1.0-SNAPSHOT</version>
  27.         </dependency>
  29.         <dependency>
  30.             <groupId>org.springframework.boot</groupId>
  31.             <artifactId>spring-boot-starter-test</artifactId>
  32.             <scope>test</scope>
  33.         </dependency>
  34.         <dependency>
  35.             <groupId>junit</groupId>
  36.             <artifactId>junit</artifactId>
  37.             <version>4.12</version>
  38.         </dependency>
  39.     </dependencies>
  41.     <build>
  42.         <finalName>summer-service</finalName>
  44.         <plugins>
  45.             <plugin>
  46.                 <groupId>org.springframework.boot</groupId>
  47.                 <artifactId>spring-boot-maven-plugin</artifactId>
  48.                 <configuration>
  49.                     <classifier>exec</classifier>
  50.                 </configuration>
  51.             </plugin>
  52.         </plugins>
  53.     </build>
  54. </project>



4、summer-web 的 pom.xml
  1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  2.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  4.     <!--关键-->
  5.     <parent>
  6.         <artifactId>summer</artifactId>
  7.         <groupId>com.liuyanzhao.summer</groupId>
  8.         <version>1.0-SNAPSHOT</version>
  9.     </parent>
  11.     <modelVersion>4.0.0</modelVersion>
  12.     <artifactId>summer-web</artifactId>
  13.     <version>1.0-SNAPSHOT</version>
  14.     <packaging>jar</packaging>
  15.     <name>web</name>
  16.     <url>http://maven.apache.org</url>
  18.     <dependencies>
  20.         <!--依赖summer-dao-->
  21.         <dependency>
  22.             <groupId>com.liuyanzhao.summer</groupId>
  23.             <artifactId>summer-dao</artifactId>
  24.             <version>1.0-SNAPSHOT</version>
  25.         </dependency>
  27.         <!--依赖summer-service-->
  28.         <dependency>
  29.             <groupId>com.liuyanzhao.summer</groupId>
  30.             <artifactId>summer-service</artifactId>
  31.             <version>1.0-SNAPSHOT</version>
  32.         </dependency>
  33.         <dependency>
  34.             <groupId>junit</groupId>
  35.             <artifactId>junit</artifactId>
  36.             <version>3.8.1</version>
  37.             <scope>test</scope>
  38.         </dependency>
  40.         <dependency>
  41.             <groupId>org.springframework.boot</groupId>
  42.             <artifactId>spring-boot-starter-thymeleaf</artifactId>
  43.         </dependency>
  44.         <!--启用不严格检查html-->
  45.         <dependency>
  46.             <groupId>net.sourceforge.nekohtml</groupId>
  47.             <artifactId>nekohtml</artifactId>
  48.             <version>1.9.22</version>
  49.         </dependency>
  51.     </dependencies>
  53.     <build>
  54.         <finalName>summer-web</finalName>
  56.         <plugins>
  57.             <plugin>
  58.                 <groupId>org.springframework.boot</groupId>
  59.                 <artifactId>spring-boot-maven-plugin</artifactId>
  60.             </plugin>
  61.         </plugins>
  62.     </build>
  64. </project>


二、Maven 打包几点注意


1、父项目里的 pom.xml 打包类型是 pom

2、父项目需要在 modules 里加入子项目名

3、子模块项目里的 pom.xml 的 parent  相等于继承，写 summer

4、打包的时候可以使用在 maven 中选择父项目的 package 打包，然后将三个 jar 放到一起，解压合并部署

命令是：

unzip -q summer-dao-exec.jar

unzip -q summer-service-exec.jar

unzip -q summer-web.jar

问有重复文件是否覆盖，选择 A 全部覆盖，不覆盖也行，没影响

然后一行命令启动项目

nohup java org.springframework.boot.loader.JarLauncher >output.txt &




5、在被依赖的模块(如 summer-dao)的pom.xml 中需要加下面代码，可以解决当依赖它(如 summer-service)的模块无法打包问题
  1. <configuration>
  2.     <classifier>exec</classifier>
  3. </configuration>



6、打包后没有 xml 文件解决办法

在 pom.xml 的 build 标签里添加如下代码
  1. <resources>
  2.     <resource>
  3.         <directory>src/main/resource</directory>
  4.         <includes>
  5.             <include>**/*.properties</include>
  6.             <include>**/*.xml</include>
  7.         </includes>
  8.         <filtering>false</filtering>
  9.     </resource>
  10. </resources>


三、MyBatis 和 SpringBoot 整合


文件结构如下



1、pom.xml
  1. <!--mysql 驱动-->
  2.      <dependency>
  3.          <groupId>mysql</groupId>
  4.          <artifactId>mysql-connector-java</artifactId>
  5.          <version>5.1.30</version>
  6.      </dependency>
  8.      <!--mybatis-->
  9.      <dependency>
  10.          <groupId>org.mybatis.spring.boot</groupId>
  11.          <artifactId>mybatis-spring-boot-starter</artifactId>
  12.          <version>1.3.0</version>
  13.      </dependency>
  15.      <!--mybatis-generator 插件-->
  16.      <dependency>
  17.          <groupId>org.mybatis.generator</groupId>
  18.          <artifactId>mybatis-generator-core</artifactId>
  19.          <version>1.3.5</version>
  20.      </dependency>

其中，前两个必选，后面那个 mybatis-generator 插件如果你用逆向工程生成 MyBatis 的实体和 mapper 的话，可选



2、application.properties
  1. server.port=8080
  2. debug=true
  4. spring.datasource.driver-class-name=com.mysql.jdbc.Driver
  5. spring.datasource.url=jdbc:mysql://localhost:3306/summer?useSSL=false&useUnicode=true&characterEncoding=utf-8
  6. spring.datasource.username=root
  7. spring.datasource.password=123456
  9. mybatis.type-aliases-package=com.liuyanzhao.summer.entity
  10. mybatis.mapper-locations=classpath:mapper/*.xml



3、实体 User.java
  1. package com.liuyanzhao.summer.entity;
  4. public class User {
  5.     private Integer id;
  7.     private String nickname;
  9.     private String password;
  11.     private String status;
  13.     private String username;
  15.     public Integer getId() {
  16.         return id;
  17.     }
  19.     public void setId(Integer id) {
  20.         this.id = id;
  21.     }
  23.     public String getNickname() {
  24.         return nickname;
  25.     }
  27.     public void setNickname(String nickname) {
  28.         this.nickname = nickname == null ? null : nickname.trim();
  29.     }
  31.     public String getPassword() {
  32.         return password;
  33.     }
  35.     public void setPassword(String password) {
  36.         this.password = password == null ? null : password.trim();
  37.     }
  39.     public String getStatus() {
  40.         return status;
  41.     }
  43.     public void setStatus(String status) {
  44.         this.status = status == null ? null : status.trim();
  45.     }
  47.     public String getUsername() {
  48.         return username;
  49.     }
  51.     public void setUsername(String username) {
  52.         this.username = username == null ? null : username.trim();
  53.     }
  54. }



4、UserMapper.java
  1. package com.liuyanzhao.summer.mapper;
  3. import com.liuyanzhao.summer.entity.User;
  4. import org.apache.ibatis.annotations.Mapper;
  5. import org.apache.ibatis.annotations.Param;
  6. import org.springframework.stereotype.Component;
  8. import java.util.List;
  10. @Mapper
  11. @Component("userMapper")
  12. public interface UserMapper {
  14.     int deleteByPrimaryKey(Integer id);
  16.     int insert(User record);
  18.     int insertSelective(User record);
  20.     User selectByPrimaryKey(Integer id);
  22.     int updateByPrimaryKeySelective(User record);
  24.     int updateByPrimaryKey(User record);
  26.     List<User> selectAllUser();
  28.     User selectByUsername(@Param("username") String username);
  29. }



5、UserMapper.xml
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="com.liuyanzhao.summer.mapper.UserMapper">
  5.   <resultMap id="BaseResultMap" type="com.liuyanzhao.summer.entity.User">
  6.     <id column="id" jdbcType="INTEGER" property="id" />
  7.     <result column="nickname" jdbcType="VARCHAR" property="nickname" />
  8.     <result column="password" jdbcType="VARCHAR" property="password" />
  9.     <result column="status" jdbcType="VARCHAR" property="status" />
  10.     <result column="username" jdbcType="VARCHAR" property="username" />
  11.   </resultMap>
  13.   <sql id="Base_Column_List">
  14.     id, nickname, password, status, username
  15.   </sql>
  18.   <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
  19.     select
  20.     <include refid="Base_Column_List" />
  21.     from user
  22.     where id = #{id,jdbcType=INTEGER}
  23.   </select>
  25.   <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
  26.     delete from user
  27.     where id = #{id,jdbcType=INTEGER}
  28.   </delete>
  30.   <insert id="insert" parameterType="com.liuyanzhao.summer.entity.User">
  31.     insert into user (id, nickname, password,
  32.       status, username)
  33.     values (#{id,jdbcType=INTEGER}, #{nickname,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},
  34.       #{status,jdbcType=VARCHAR}, #{username,jdbcType=VARCHAR})
  35.   </insert>
  37.   <insert id="insertSelective" parameterType="com.liuyanzhao.summer.entity.User">
  38.     insert into user
  39.     <trim prefix="(" suffix=")" suffixOverrides=",">
  40.       <if test="id != null">
  41.         id,
  42.       </if>
  43.       <if test="nickname != null">
  44.         nickname,
  45.       </if>
  46.       <if test="password != null">
  47.         password,
  48.       </if>
  49.       <if test="status != null">
  50.         status,
  51.       </if>
  52.       <if test="username != null">
  53.         username,
  54.       </if>
  55.     </trim>
  56.     <trim prefix="values (" suffix=")" suffixOverrides=",">
  57.       <if test="id != null">
  58.         #{id,jdbcType=INTEGER},
  59.       </if>
  60.       <if test="nickname != null">
  61.         #{nickname,jdbcType=VARCHAR},
  62.       </if>
  63.       <if test="password != null">
  64.         #{password,jdbcType=VARCHAR},
  65.       </if>
  66.       <if test="status != null">
  67.         #{status,jdbcType=VARCHAR},
  68.       </if>
  69.       <if test="username != null">
  70.         #{username,jdbcType=VARCHAR},
  71.       </if>
  72.     </trim>
  73.   </insert>
  75.   <update id="updateByPrimaryKeySelective" parameterType="com.liuyanzhao.summer.entity.User">
  76.     update user
  77.     <set>
  78.       <if test="nickname != null">
  79.         nickname = #{nickname,jdbcType=VARCHAR},
  80.       </if>
  81.       <if test="password != null">
  82.         password = #{password,jdbcType=VARCHAR},
  83.       </if>
  84.       <if test="status != null">
  85.         status = #{status,jdbcType=VARCHAR},
  86.       </if>
  87.       <if test="username != null">
  88.         username = #{username,jdbcType=VARCHAR},
  89.       </if>
  90.     </set>
  91.     where id = #{id,jdbcType=INTEGER}
  92.   </update>
  94.   <update id="updateByPrimaryKey" parameterType="com.liuyanzhao.summer.entity.User">
  95.     update user
  96.     set nickname = #{nickname,jdbcType=VARCHAR},
  97.       password = #{password,jdbcType=VARCHAR},
  98.       status = #{status,jdbcType=VARCHAR},
  99.       username = #{username,jdbcType=VARCHAR}
  100.     where id = #{id,jdbcType=INTEGER}
  101.   </update>
  103.   <!--查询所有的用户-->
  104.   <select id="selectAllUser"  resultMap="BaseResultMap">
  105.     select
  106.     <include refid="Base_Column_List" />
  107.     from user
  108.   </select>
  110.   <!--根据用户名查询-->
  111.   <select id="selectByUsername"  parameterType="string" resultMap="BaseResultMap">
  112.     select
  113.     <include refid="Base_Column_List" />
  114.     from user
  115.     WHERE username = #{username}
  116.   </select>
  118. </mapper>




四、RestFul 风格URL 的测试


本文主要介绍的是 Maven 多模块开发和 SpringBoot + MyBatis 整合，service 层写的很简单不要过分在意，下面来使用 PostMan 测试一下请求

1、获得一个用户





2、获得多个用户





3、添加用户





4、更新用户





5、删除用户




五、源码地址


源码：https://github.com/saysky/maven-multi-modules















历史上的今天
七月
24日
  • 微信
  • 交流学习，资料分享
  • weinxin
  • 个人淘宝
  • 店铺名：言曌博客咨询部

  • (部分商品未及时上架淘宝)
avatar

发表评论

avatar 登录者：匿名
匿名评论，评论回复后会有邮件通知

  

已通过评论：0   待审核评论数：0