Springboot+MyBatis 整合

JDK:1.8

开发工具:IDEA

数据库：MySQL

首先创建

 

选中 “Web”

选中 "JPA"，“MySQL”,"MyNatis"

点击 “Next”

点击 “Finish” 完成创建

最初项目结构：

在 pom.xml中加入以下依赖：

<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.0</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-test</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.1.3.RELEASE</version>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
        </dependency>

 最终的 pom.xml内容如下：

<?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>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.1.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.example</groupId>
    <artifactId>demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>demo</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>


        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.0</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-test</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.1.3.RELEASE</version>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

</project>

最终结构：

配置application.yml：

#默认使用配置
spring:
  profiles:
    active: dev
#公共配置与profiles选择无关
mybatis:
  typeAliasesPackage: com.example.demo.entity
  mapperLocations: classpath:mapper/*.xml
---
#开发配置
spring:
  profiles: dev
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/root?characterEncoding=utf8&useSSL=false&serverTimezone=UTC
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver

在 application.properties 中 配置Tomcat ：

#配置程序端口，默认为8080
server.port= 9090
#IP
server.address=127.0.0.1
#编码格式
server.tomcat.uri-encoding=UTF-8

创建 Users.java

package com.example.demo.entity;

public class Users {
    private Integer id;

    private String userName;

    private String password;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }


}

创建 UsersMapper.java

package com.example.demo.Mapper;

import com.example.demo.entity.Users;
public interface UsersMapper {
    Users selectUsers(int id);
}

创建UsersMapper.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.example.demo.Mapper.UsersMapper" >
    <resultMap id="UsersMap" type="com.example.demo.entity.Users" >
        <id column="id" property="id" jdbcType="INTEGER" />
        <result column="userName" property="userName" jdbcType="VARCHAR" />
        <result column="password" property="password" jdbcType="VARCHAR" />
    </resultMap>


    <select id="selectUsers" resultMap="UsersMap" parameterType="java.lang.Integer">
        select   id, userName, password from users   where id = #{id,jdbcType=INTEGER}
    </select>


</mapper>

创建 UsersService.java

package com.example.demo.service;

import com.example.demo.entity.Users;

public interface UsersService {
     Users selectUsers(int usesId);
}

创建 UsersSericeImpl.java 实现 UsesService

package com.example.demo.service.impl;


import com.example.demo.Mapper.UsersMapper;
import com.example.demo.entity.Users;
import com.example.demo.service.UsersService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

@Service
public class UsersServiceImpl implements UsersService {
    @Resource
    private UsersMapper dao;

    @Override
    public Users selectUsers(int usesId) {
        return dao.selectUsers(usesId);
    }
}

创建测试类 TestSboot.java

package com.example.demo.controller;



import com.example.demo.entity.Users;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@EnableAutoConfiguration
@RequestMapping("/sboot")
public class TestSboot {

    @RequestMapping("getusers")
    public Users getUser() {
        Users users = new Users();
        users.setId(1);
        users.setUserName("test");
        users.setPassword("123456");
        return users;
    }
}

创建 UsersController.java

package com.example.demo.controller;


import com.example.demo.entity.Users;
import com.example.demo.service.UsersService;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.List;

@Controller
@RequestMapping("users")
public class UsersController {
    @Resource
    private UsersService service;

    @ResponseBody
    @RequestMapping("/selectUser")
    public Users toIndex(HttpServletRequest request, Model model){
        int usersId = Integer.parseInt(request.getParameter("id"));
        return service.selectUsers(usersId);
    }
}

在DemoApplication.java 中加注解

package com.example.demo;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.example.demo.Mapper")
public class DemoApplication {
    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }
}

Run  ”DemoApplication“ 

访问 地址 ：http://127.0.0.1:9090/sboot/getusers  测试是否配置成功

配置成功会出现以下结果:

访问 地址：http://127.0.0.1:9090/users/getUsers?id=1 连接数据库查询

结果如下：