SpringBoot–SpringBoot集成mybatis

1.添加jar包

• 如果在创建项目的时候没有添加maybatis依赖，需要在pom文件中加入jar包

<!--驱动包-->
<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <scope>runtime</scope>
</dependency>
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.3.0</version>
</dependency>

• 如果在创建项目的时候添加maybatis依赖，在pom文件中会自带mybatis相关jar包

  • 在 Spring Initializr 创建项目时直接选择：MySQL Driver和MyBatis Framework

2.配置MyBatis

• 在application.yml文件中添加相关配置

server:
  port: 80
spring:
  # 数据源配置
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/smbms?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=true
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver
# 配置MyBatis
mybatis:
	 # 别名包扫描
    type-aliases-package: org.hz.springboot01.pojo
     # Mapper XML 文件位置
    mapper-locations: classpath:/mappers/*.xml
    configuration:
     	# 日志实现
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

3.在启动类中扫包

@SpringBootApplication
//扫描mapper接口
@MapperScan("org.hz.springboot01.mapper")
public class Springboot01Application {
    public static void main(String[] args) {
        SpringApplication.run(Springboot01Application.class, args);
    }
}

4.创建实体类和Mapper层

4.1实体类

import lombok.Data;
import java.util.Date;
@Data
public class Provider {

	private Integer id;   //id
	private String proCode; //供应商编码
	private String proName; //供应商名称
	private String proDesc; //供应商描述
	private String proContact; //供应商联系人
	private String proPhone; //供应商电话
	private String proAddress; //供应商地址
	private String proFax; //供应商传真
	private Integer createdBy; //创建者
	private String creationDate; //创建时间
	private Integer modifyBy; //更新者
	private Date modifyDate;//更新时间
}

4.2Mapper 接口

public interface ProviderMapper {
    /**
     * 查询供应商列表
     * @return
     */
    public List<Provider> findProviderList();
}

4.3Mapper XML 文件

在resources文件架下创建mappers文件夹，在mappers文件夹下创建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="org.hz.springboot01.mapper.ProviderMapper">

    <select id="findProviderList" resultType="Provider">
        select * from smbms_provider
    </select>

</mapper>

5. 创建 Service层和 Controller层

5.1Service 接口

public interface ProviderService {
    public List<Provider> findProviderList();

}

5.2Service 实现

@Service
public class ProviderServiceImpl implements ProviderService {
    @Autowired
    private ProviderMapper providerMapper;
    @Override
    public List<Provider> findProviderList() {
        return providerMapper.findProviderList();
    }
}

5.3Controller

@RestController
@RequestMapping("/pro")
public class ProviderController {
    @Autowired
    private ProviderService providerService;
    @GetMapping("/list")
    public List<Provider> findProviderList(){
        return providerService.findProviderList();
    }
}

6. 项目结构