SpringBoot整合Mybatis最全教程

拼搏现实的明天。 2022-02-03 11:39 334阅读 0赞

### 前言：自从Spring推出Boot，Cloud系列之后，一度成为热门的框架，现在大部分的招聘要求都要有相关的开发经验，借此我在这里就给大家分享一下如何玩转SpringBoot跟Mybatis。 ###

源码地址：[https://github.com/xiatengGG/SpringBoot-Mybatis][https_github.com_xiatengGG_SpringBoot-Mybatis]

废话就不多说了，代码撸起来。

开发工具跟环境：IntelliJ IDEA  ，JDK1.8，MySql数据库

所用技术：SpringBoot ，Mybatis，apache-maven-3.2.5，thymeleaf模板

### 一、创建一个maven项目 File-->New-->Project ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMDM3NDc4_size_16_color_FFFFFF_t_70][]

这里我们选择Maven，JDK1.8

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMDM3NDc4_size_16_color_FFFFFF_t_70 1][]

然后填写项目坐标，这个自己命名，写好后Next-->Finish

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMDM3NDc4_size_16_color_FFFFFF_t_70 2][]

### 二、编写pom.xml文件 ###

<parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.0.0.RELEASE</version>
        </parent>
    
        <dependencies>
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.1</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>com.yeepay.g3.yop</groupId>
                <artifactId>yop-java-sdk</artifactId>
                <version>3.1.3</version>
                <classifier>jdk17</classifier>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.mybatis.generator</groupId>
             <artifactId>mybatis-generator-core</artifactId>
            <version>1.3.6</version>
            </dependency>
        </dependencies>
    
    
        <build>
            <plugins>
                
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
    
                
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.3</version>
                    <configuration>
                        <verbose>true</verbose>
                        <overwrite>true</overwrite>
                    </configuration>
                </plugin>
            </plugins>
    
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <excludes>
                        <exclude>**/*.java</exclude>
                    </excludes>
                </resource>
                <resource>
                    
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.*</include>
                    </includes>
                </resource>
            </resources>
        </build>

### 三、在resources下新建配置文件:applocation.yml ###

spring:
    # 配置thymeleaf模板引擎
      thymeleaf:
        # 模板的字符集
        encoding: UTF-8
        # 使用的是什么类型模板
        mode: HTML5
        # 是否使用缓存，开发阶段最填false，方便使用ctrl+shift+F9 进行重新编译，无需重启服务
        cache: false
        #启动 MVC 对 thymeleaf 视图解析
        enabled: true
        # 在构建URL时附加到视图名称的后缀。就是我们用rest风格，不同加文件后缀名。自己加上去
        suffix: .html
        # 在构建URL时可以预览查看名称的前缀。就是路径在哪
        prefix: classpath:/templates/
        # 检查该模板是否存在
        check-template-location: true
        # 模板中内容的类型
        servlet:
          content-type: text/html
    
      datasource:
        url: jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF-8&useSSL=false
        username: root
        password: 123456
        # 可省略驱动配置, sprin-boot 会由url检测出驱动类型
        # driver-class-name: com.mysql.jdbc.Driver
        hikari:
          connection-timeout: 60000
    mybatis:
    #mapper扫描地址
      mapperLocations: classpath:/com/xiateng/mapper/*.xml
      typeAliasesPackage: com.xiateng.entity
    # spring-boot默认打印输出info级别以上的，可在此处修改输出级别
    logging:
      level:
        root: info

### 四、创建Controller文件 ###

package com.xiateng.controller.test;
    
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    @Controller
    public class TestController {
    
        @RequestMapping(value = "/index")
        @ResponseBody
        public String index(){
            return "Hello SpringBoot！";
        }
    }

### 五、创建启动类Application.java ###

package com.xiateng;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.context.annotation.ComponentScan;
    
    @SpringBootApplication
    @ComponentScan(basePackages = {"com.xiateng"})
    @MapperScan("com.xiateng.dao")
    public class Application{
    
        public static void main(String[] args) {
            SpringApplication.run(Application.class,args);
        }
    }

点击main方法--》右键--》run Application

浏览器输入：[http://localhost:8080/index][http_localhost_8080_index]    页面看到结果：

![2019050914325922.png][]

接下来我们从数据库查询数据返回前端页面

1.创建一个表：

CREATE TABLE `t_user` (
      `USER_ID` int(11) NOT NULL AUTO_INCREMENT,
      `USER_NAME` char(30) NOT NULL,
      `USER_PASSWORD` char(10) NOT NULL,
      `USER_EMAIL` char(30) NOT NULL,
      PRIMARY KEY (`USER_ID`),
      KEY `IDX_NAME` (`USER_NAME`)
    );

2.创建实体类

package com.xiateng.entity;
    
    public class TUser {
        private Integer userId;
    
        private String userName;
    
        private String userPassword;
    
        private String userEmail;
    
        public Integer getUserId() {
            return userId;
        }
    
        public void setUserId(Integer userId) {
            this.userId = userId;
        }
    
        public String getUserName() {
            return userName;
        }
    
        public void setUserName(String userName) {
            this.userName = userName == null ? null : userName.trim();
        }
    
        public String getUserPassword() {
            return userPassword;
        }
    
        public void setUserPassword(String userPassword) {
            this.userPassword = userPassword == null ? null : userPassword.trim();
        }
    
        public String getUserEmail() {
            return userEmail;
        }
    
        public void setUserEmail(String userEmail) {
            this.userEmail = userEmail == null ? null : userEmail.trim();
        }
    }

3.创建一个dao方法

package com.xiateng.dao;
    
    import com.xiateng.entity.TUser;
    import org.apache.ibatis.annotations.Mapper;
    
    import java.util.List;
    
    @Mapper
    public interface TUserMapper {
        int deleteByPrimaryKey(Integer userId);
    
        int insertSelective(TUser record);
    
        TUser selectByPrimaryKey(Integer userId);
    
        int updateByPrimaryKeySelective(TUser record);
    
        List<TUser> selectByTUser(TUser record);
    }

4.创建mapper.xml文件

<?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="com.xiateng.dao.TUserMapper">
      <resultMap id="BaseResultMap" type="com.xiateng.entity.TUser">
        <id column="USER_ID" jdbcType="INTEGER" property="userId" />
        <result column="USER_NAME" jdbcType="CHAR" property="userName" />
        <result column="USER_PASSWORD" jdbcType="CHAR" property="userPassword" />
        <result column="USER_EMAIL" jdbcType="CHAR" property="userEmail" />
      </resultMap>
      <sql id="Base_Column_List">
        USER_ID, USER_NAME, USER_PASSWORD, USER_EMAIL
      </sql>
      <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
        select 
        <include refid="Base_Column_List" />
        from t_user
        where USER_ID = #{userId,jdbcType=INTEGER}
      </select>
      <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
        delete from t_user
        where USER_ID = #{userId,jdbcType=INTEGER}
      </delete>
      <insert id="insertSelective" parameterType="com.xiateng.entity.TUser">
        insert into t_user
        <trim prefix="(" suffix=")" suffixOverrides=",">
          <if test="userId != null">
            USER_ID,
          </if>
          <if test="userName != null">
            USER_NAME,
          </if>
          <if test="userPassword != null">
            USER_PASSWORD,
          </if>
          <if test="userEmail != null">
            USER_EMAIL,
          </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
          <if test="userId != null">
            #{userId,jdbcType=INTEGER},
          </if>
          <if test="userName != null">
            #{userName,jdbcType=CHAR},
          </if>
          <if test="userPassword != null">
            #{userPassword,jdbcType=CHAR},
          </if>
          <if test="userEmail != null">
            #{userEmail,jdbcType=CHAR},
          </if>
        </trim>
      </insert>
      <update id="updateByPrimaryKeySelective" parameterType="com.xiateng.entity.TUser">
        update t_user
        <set>
          <if test="userName != null">
            USER_NAME = #{userName,jdbcType=CHAR},
          </if>
          <if test="userPassword != null">
            USER_PASSWORD = #{userPassword,jdbcType=CHAR},
          </if>
          <if test="userEmail != null">
            USER_EMAIL = #{userEmail,jdbcType=CHAR},
          </if>
        </set>
        where USER_ID = #{userId,jdbcType=INTEGER}
      </update>
    
      <select id="selectByTUser" parameterType="com.xiateng.entity.TUser" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from t_user
        WHERE 1=1
        <if test="userName != null and userName != ''">
          and USER_NAME = #{userName,jdbcType=VARCHAR}
        </if>
        <if test="userId != null and userId != ''">
          and USER_ID = #{userId,jdbcType=INTEGER}
        </if>
        <if test="userEmail != null and userEmail != ''">
          and USER_EMAIL = #{userEmail,jdbcType=VARCHAR}
        </if>
      </select>
    </mapper>

5.创建TUserService.java

package com.xiateng.service;
    
    import com.xiateng.entity.TUser;
    
    import java.util.List;
    
    public interface TUserService {
    
        List<TUser> selectByUserList(TUser example);
    
        int deleteByPrimaryKey(Integer userId);
    
        int insertSelective(TUser record);
    
        TUser selectByPrimaryKey(Integer userId);
    
        int updateByPrimaryKeySelective(TUser record);
    
        List<TUser> selectByTUser(TUser record);
    }

6.创建TUserServiceImpl.java

package com.xiateng.service.impl;
    
    import com.xiateng.dao.TUserMapper;
    import com.xiateng.entity.TUser;
    import com.xiateng.service.TUserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    @Service
    public class TUserServiceImpl implements TUserService{
        @Autowired
        private TUserMapper tUserMapper;
    
        @Override
        public List<TUser> selectByUserList(TUser example) {
            return null;
        }
    
        @Override
        public int deleteByPrimaryKey(Integer userId) {
            return tUserMapper.deleteByPrimaryKey(userId);
        }
    
        @Override
        public int insertSelective(TUser record) {
            return tUserMapper.insertSelective(record);
        }
    
        @Override
        public TUser selectByPrimaryKey(Integer userId) {
            return tUserMapper.selectByPrimaryKey(userId);
        }
    
        @Override
        public int updateByPrimaryKeySelective(TUser record) {
            return tUserMapper.updateByPrimaryKeySelective(record);
        }
    
        @Override
        public List<TUser> selectByTUser(TUser record) {
            return tUserMapper.selectByTUser(record);
        }
    }

7.创建Controller类

package com.xiateng.controller.test;
    
    import com.xiateng.entity.TUser;
    import com.xiateng.service.TUserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import java.util.HashMap;
    import java.util.Map;
    
    @Controller
    @RequestMapping("/user")
    public class StarterController {
    
        @Autowired
        private TUserService tUserService;
    
        @RequestMapping(value = "/detail")
        public String index(Model model){
            Map<String, Object> map = new HashMap<>();
            TUser tUser = tUserService.selectByPrimaryKey(1);
            model.addAttribute("tUsers",tUser);
            return "index";
        }
    }

8.创建html文件index.html

<!DOCTYPE html>
    <html xmlns:th="http://www.thymeleaf.org">
    <head>
        <meta content="text/html;charset=UTF-8"/>
        <meta name="viewport" content="width=device-width,initial-scale=1"/>
        <link th:href="@{/res/js/jquery-1.11.3.min.js}" rel="stylesheet"/>
    </head>
    <body>
    <div>Hello  <span style="color: red;" th:text="${tUsers.userName}"></span>  !</div>
    
    
    
    
    </body>
    </html>

访问地址：[http://localhost:8080/user/detail][http_localhost_8080_user_detail]

![20190509145806185.png][]

[https_github.com_xiatengGG_SpringBoot-Mybatis]: https://github.com/xiatengGG/SpringBoot-Mybatis
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMDM3NDc4_size_16_color_FFFFFF_t_70]: /images/20220203/067ba84535f34b8aaf5f9e1ff7891e2f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMDM3NDc4_size_16_color_FFFFFF_t_70 1]: /images/20220203/c46366e22c0a4325b12918107037ec95.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMDM3NDc4_size_16_color_FFFFFF_t_70 2]: /images/20220203/6f5011fb8a7e446eb90178fc4771a5b0.png
[http_localhost_8080_index]: http://localhost:8080/index
[2019050914325922.png]: /images/20220203/ba5b7a7773224d28bc166b6596d5d67e.png
[http_localhost_8080_user_detail]: http://localhost:8080/user/detail
[20190509145806185.png]: /images/20220203/83de7e97f3764c40ba1e36e2e4487c58.png