SpringBoot 整合 Mybatis

SpringBoot 整合 Mybatis

环境准备

数据库 : mysql

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

Java 环境 : Jdk1.8

SpringBoot 版本 : 2.1.6.RELEASE

工程创建

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.6.RELEASE</version>
        <relativePath/>
    </parent>
	
    <!-- 修改为自己的 groupId, artifactId , name -->
    <groupId>com.lfy</groupId>
    <artifactId>springboot-mybatis</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>springboot-mybatis</name>
    <description>Demo project for Spring Boot</description>
	
    <properties>
        <!-- java 版本 -->
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <!-- 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>2.1.0</version>
        </dependency>
		<!-- mysql 的驱动包 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!-- springboot 测试所需 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <!-- 自动将工程打成 jar 包 -->
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

application.properties

server.port=8080

# 数据源
spring.datasource.url=jdbc:mysql:///springbootShiro
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=123456

JavaBean

编写 User 类

package com.lfy.springbootmybatis.bean;

/**
 * User 实体类
 */
public class User {

    private String id;
    private String username;
    private String sex;
    private String password;
	
    //省略 get set 方法

}

mybatis-config.xml

mybatis 的配置文件 , 因为我们不需要任何配置, 所以里面为空就可以

<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DOD Config 3.0//EN"
        "http://mybatis.org/schema/mybatis-3-config.dtd">
<configuration>
</configuration>

UserMapper.java

package com.lfy.springbootmybatis.dao;

import com.lfy.springbootmybatis.bean.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

@Mapper
//可以不加 @Repository 注解 , 但是在 idea 中进行装配时会报错 但是项目正常运行
//有强迫症的同学加上 @_@
@Repository
public interface UserMapper {
    void insert(User user);
    void delete(String id);
    void update(User user);
    User selectById(String id);
}

UserMapper.xml

在 resources/mybatis 下建立 mapper 文件夹 , 在 mapper 文件夹下编写 UserMapper.xml

<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DOD Config 3.0//EN"
        "http://mybatis.org/schema/mybatis-3-mapper.dtd">
<mapper namespace="com.lfy.springbootmybatis.dao.UserMapper">
    <insert id="insert" parameterType="com.lfy.springbootmybatis.bean.User">
        insert into user(id,username,sex,password) values (#{id},#{username},#{sex},#{password})
    </insert>
    <delete id="delete" parameterType="java.lang.String">
        delete from user where id = #{id}
    </delete>
    <select id="selectById" parameterType="java.lang.String" resultType="com.lfy.springbootmybatis.bean.User">
        select * from user where id = #{id}
    </select>
    <update id="update" parameterType="com.lfy.springbootmybatis.bean.User">
        update user set username = #{username}, sex = #{sex}, password = #{password} where id = #{id}
    </update>
</mapper>

配置 mapper 和 mybatis 配置文件

修改 application.properties 文件

server.port=8080

# 数据源
spring.datasource.url=jdbc:mysql:///springbootShiro
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=123456

# 配置mybatis
# mybatis 配置文件位置
mybatis.config-location=classpath:mybatis/mybatis-config.xml
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml

编写 service , controller

项目结构 :

UserService

package com.lfy.springbootmybatis.service;
 
@Service
public class UserService {

    @Autowired
    private UserMapper userMapper;

    public void insert(User user){
        userMapper.insert(user);
    }

    public void delete(String id){
        userMapper.delete(id);
    }

    public void update(User user){
        userMapper.update(user);
    }

    public User findById(String id){
        return userMapper.selectById(id);
    }
}

UserController

package com.lfy.springbootmybatis.controller;

@RestController
public class UserController {

    @Autowired
    private UserService userService;

    @PostMapping("/user")
    public void insert(@RequestBody User user){
        userService.insert(user);
    }

    @PutMapping("/user")
    public void update(@RequestBody User user){
        userService.update(user);
    }

    @DeleteMapping("/user/{id}")
    public void delete(@PathVariable String id){
        userService.delete(id);
    }

    @GetMapping("user/{id}")
    public User findById(@PathVariable String id){
        return userService.findById(id);
    }

}

运行测试

查询 :

增加 :

修改 :

删除 :

整合完成