场景

数据库中数据

Eclipse中实现SpringBoot与Mybatis整合（图文教程带源码）

实现效果

Eclipse中实现SpringBoot与Mybatis整合（图文教程带源码）

项目结构

Eclipse中实现SpringBoot与Mybatis整合（图文教程带源码）

前面参照

Eclipse中新建SpringBoot项目并输出HelloWorld

https://blog.****.net/BADAO_LIUMANG_QIZHI/article/details/88359953

Eclipse中新建SpringBoot项目完成对json、pojo、map、list的请求

https://blog.****.net/BADAO_LIUMANG_QIZHI/article/details/88360041

实现

数据库设计

新建user表

Eclipse中实现SpringBoot与Mybatis整合（图文教程带源码）

业务实现

完成业务实现所需包的创建以及包下类的创建

pojo包下新建User.java

package com.example.demo.pojo;

public class User {
 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;
 }

}

resource下新建mapper文件夹，mapper下新建UserMapper.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.UserMapper">
 
   <select id="findAll" resultType="user">
     select * from user
   </select>


</mapper>

mapper下新建config文件夹，config下新建sqlMapConfig.xml

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

</configuration>

新建service包，并在包下新建UserService.java接口类

package com.example.demo.service;

import java.util.List;


import org.springframework.stereotype.Service;

import com.example.demo.pojo.User;
@Service
public interface UserService {
 
 public List<User> findAll();
 
}

在service下新建UserServiceImpl.java

package com.example.demo.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.example.demo.mapper.UserMapper;
import com.example.demo.pojo.User;
import com.example.demo.service.UserService;
@Service
public class UserServiceImpl implements UserService {
 
 //注入mapper接口代理对象
 @Autowired
 private UserMapper userMapper;

 @Override
 public List<User> findAll() {
  // TODO Auto-generated method stub
  List<User> list = userMapper.findAll();
  return list;
 }

}

新建mapper包并在下面新建UserMapper.java接口

package com.example.demo.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.example.demo.pojo.User;

@Mapper
public interface UserMapper {
 /**
  * 查询所有用户
  */
 public List<User> findAll();
}

新建controller包并在下面新建UserController.java

package com.example.demo.controller;

import java.util.ArrayList;

import java.util.HashMap;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.example.demo.pojo.User;
import com.example.demo.service.UserService;


/**
 * @author badao
 * @Description:测试
 * @Time:2019年3月6日 下午11:20:19
 */
@RestController
public class UserController {
 
 
 //注入Service服务对象
 @Autowired
 private UserService userService;
 
 /**
  * 整合SSM
  */
 @RequestMapping("ssm")
 public List<User> findAll(){
  List<User> list = userService.findAll();
  return list;
 }
 
}

配置文件配置

打开application.properties

#springboot整合Mybatis框架
#加载Mybatis配置文件
mybatis.mapper-locations=classpath:mapper/*Mapper.xml
mybatis.config-location=classpath:mapper/config/sqlMapConfig.xml
#定义别名
mybatis.type-aliases-package=com.example.demo.pojo
#数据源
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=utf8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=123

打开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.3.RELEASE</version>
  <relativePath/> <!-- lookup parent from repository -->
 </parent>
 <groupId>com.badao</groupId>
 <artifactId>helloSpringBoot</artifactId>
 <version>0.0.1-SNAPSHOT</version>
 <name>helloSpringBoot</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-web</artifactId>
  </dependency>

  <dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-test</artifactId>
   <scope>test</scope>
  </dependency>
  <!-- mybatis整合Springboot -->
   <dependency>
   <groupId>org.mybatis.spring.boot</groupId>
   <artifactId>mybatis-spring-boot-starter</artifactId>
   <version>1.1.1</version>
  </dependency>
  <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.11</version>
  </dependency>
 </dependencies>

 <build>
  <plugins>
   <plugin>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-maven-plugin</artifactId>
   </plugin>
  </plugins>
 </build>

</project>

打开HelloSpringBootApplication.java，注意其位置要和业务包同级。

package com.example.demo;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@MapperScan("com.example.demo.mapper")
@SpringBootApplication
public class HelloSpringBootApplication {

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

}