SpringBoot+Mybatis整合，简单的demo

     众所周知，现在SpringBoot已经是一款非常流行的框架。相较于Spring框架,SpringBoot省略了大量的配置文件。开发起来简单高效，好了，不多说了，直接开始编码。

1.先使用sql语句建立表格。

CREATE TABLE `users` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `age` int(16) DEFAULT NULL,
  `phone` varchar(16) DEFAULT NULL,
  `address` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

 添加测试数据：

1.创建新项目，项目结构如图所示：

 2.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>mybatis-demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>mybatis-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-jdbc</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>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </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>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <optional>true</optional>
        </dependency>
        <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>
            </plugin>
        </plugins>
    </build>

</project>

 

3.application.properties 配置如下：

mybatis.type-aliases-package=com.example.mybatisdemo.bean

spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/mybatis?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8
spring.datasource.username = root
spring.datasource.password = 123456
server.port=8888

4.开始编写代码啦

    (1) bean 

package com.example.mybatisdemo.bean;

/**
 * 用户类
 *@author  admin
 */
public class User {
    /**
     * 用户id
     */
    private   int id;
    /**
     * 用户姓名
     */
    private String name;
    /**
     * 用户年龄
     */
    private  int age;
    /**
     * 用户电话
     */
    private  String phone;
    /**
     * 用户地址
     */
    private  String address;

    public User() {
    }

    public User(int id, String name, int age, String phone, String address) {
        this.id = id;
        this.name = name;
        this.age = age;
        this.phone = phone;
        this.address = address;
    }

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }
}

  (2) mapper

package com.example.mybatisdemo.mapper;


import com.example.mybatisdemo.bean.User;
import org.apache.ibatis.annotations.Select;

public interface UserMapper {
    /**
     * 通过用户ID获取用户姓名
     * @param id  用户ID
     * @return    用户姓名
     */
    @Select("select name from users where id=#{id}")
    String  getUserName(int id);

    /**
     * 通过用户姓名查询用户的所有信息
     * @param name 用户姓名
     * @return  用户类
     */
    @Select("select * from users where name=#{name}")
    User getUserInfo(String name);
}

  (3) service

package com.example.mybatisdemo.service;

import com.example.mybatisdemo.bean.User;


public interface UserService {
    /**
     * 通过用户ID获取用户姓名
     * @param id  用户ID
     * @return    用户姓名
     */
    String getUserName(int id);
    /**
     * 通过用户姓名查询用户的所有信息
     * @param name 用户姓名
     * @return  用户类
     */
    User getUserInfo(String name);
}

  (4)serviceImpl 

package com.example.mybatisdemo.serviceImpl;


import com.example.mybatisdemo.bean.User;
import com.example.mybatisdemo.mapper.UserMapper;
import com.example.mybatisdemo.service.UserService;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;

@Service
public class UserServiceImpl  implements UserService {
    @Resource
    private UserMapper userMapper;
    @Override
    public String getUserName(int id) {

        return userMapper.getUserName(id);
    }

    @Override
    public User getUserInfo(String name) {
        return userMapper.getUserInfo(name);
    }
}

   (5)controller

package com.example.mybatisdemo.controller;

import com.example.mybatisdemo.bean.User;
import com.example.mybatisdemo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

@RestController
public class UserController {
    @Autowired
    private UserService userService;

    @RequestMapping("/findUserNameByUserId")
    public String getUserNameByUserId(int id){

        return  userService.getUserName(id);
    }
    @RequestMapping("/findUserInfoByUserName")
    public User getUserInfoByUserName(String name){

        return  userService.getUserInfo(name);
    }
}

 5.Postman测试：

  第一个接口测试结果：

第二个接口测试结果：

 好啦，是不是感觉比传统的Spring 简单一些，不需要写一堆的xml文件。这就是Spring Boot的作用啦，很多Spring Boot已经配置了，不需我们自己写太多的配置。

源码地址：https://pan.baidu.com/s/1ouu9h8dNV_wnLr1Hnu3oaA