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

电玩女神 2023-10-18 15:45 34阅读 0赞

## 场景 ##

数据库中数据

![Image 1][]![2019031823294879.jpg][]

实现效果

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70][]

项目结构

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1][]

前面参照

Eclipse中新建SpringBoot项目并输出HelloWorld

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/88359953][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_88359953]

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

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/88360041][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_88360041]

## 实现 ##

### 数据库设计 ###

新建user表

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2][]

### 业务实现 ###

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

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/> 
     </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>
      
       <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);
     }
    
    }

### 运行 ###

在HelloSpringBootApplication.java中右击选择Run as--Java Application

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 3][]

打开浏览器输入：

[http://localhost:8080/ssm][http_localhost_8080_ssm]

## 源码下载 ##

[https://download.csdn.net/download/badao\_liumang\_qizhi/11029904][https_download.csdn.net_download_badao_liumang_qizhi_11029904]

[Image 1]: 
[2019031823294879.jpg]: https://img-blog.csdnimg.cn/2019031823294879.jpg
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190318232951505.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190318232954542.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_88359953]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/88359953
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_88360041]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/88360041
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/2019031823295973.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20190318233125373.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[http_localhost_8080_ssm]: http://localhost:8080/ssm
[https_download.csdn.net_download_badao_liumang_qizhi_11029904]: https://download.csdn.net/download/badao_liumang_qizhi/11029904