SpringBoot整合mybatis

1. 添加依赖

        <!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.3</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.18</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.22</version>
        </dependency>

2. 配置文件

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/employee?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=改成你自己的密码

mybatis.mapper-locations=classpath:/com/seekwind/mapper/*.xml
mybatis.type-aliases-package=com.seekwind.springboot_demo3_mybatis.entity

3. 入口类添加注解

package com.seekwind.springboot_demo3_mybatis;

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

@SpringBootApplication
@MapperScan("com.seekwind.springboot_demo3_mybatis.dao")
public class SpringbootDemo3MybatisApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringbootDemo3MybatisApplication.class, args);
    }

}

4. 构造DAO接口、实体类、控制器

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-c6o5mlYg-1595592945185)(images/image-20200724200750877.png)]

// User.java
package com.seekwind.springboot_demo3_mybatis.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;

import java.util.Date;

@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
public class User {
    private String id;
    private String name;
    private Integer age;
    private Date bir;


}

// UserDAO.java
package com.seekwind.springboot_demo3_mybatis.dao;

import com.seekwind.springboot_demo3_mybatis.entity.User;

import java.util.List;

public interface UserDAO {
    void save(User user);
    List<User> findAll();
}

/// UserService.java
package com.seekwind.springboot_demo3_mybatis.service;

import com.seekwind.springboot_demo3_mybatis.entity.User;

import java.util.List;

public interface UserService {
    void save(User user);
    List<User> findAll();

}

// UserServiceImpl.java
package com.seekwind.springboot_demo3_mybatis.service;

import com.seekwind.springboot_demo3_mybatis.dao.UserDAO;
import com.seekwind.springboot_demo3_mybatis.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;
import java.util.UUID;

@Service
@Transactional
public class UserServiceImpl implements UserService {

    @Autowired
    private UserDAO userDAO;

    @Override
    public void save(User user) {
        user.setId(UUID.randomUUID().toString());
        userDAO.save(user);
    }

    @Override
    public List<User> findAll() {
        return userDAO.findAll();
    }
}

5. Mapper文件

<?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.seekwind.springboot_demo3_mybatis.dao.UserDAO">
<!--    save-->
    <insert id="save" parameterType="User">
        insert into t_user values (#{id},#{name},#{age},#{bir})
    </insert>


<!--    findAll-->
    <select id="findAll" resultType="User">
        select id,name,age,bir from t_user
    </select>

</mapper>

Edge浏览器推荐使用FeHelper(前端助手)格式化浏览JSON