学习的spring boot 2.0的记录（四）：集成mybatis

r囧r小猫 2021-11-29 18:16 267阅读 0赞

前言：

学习的地址：[https://www.majiaxueyuan.com/front/showcoulist][https_www.majiaxueyuan.com_front_showcoulist]   、[https://www.bilibili.com/video/av47407342/][https_www.bilibili.com_video_av47407342]

SpringBoot的pom依赖（以2.0版本为例的）

当前记录的是集成mybatis：

**目录**

1.添加依赖

2.编写测试代码

3.测试

--------------------

# 1.添加依赖 #

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.0.0.RELEASE</version>
    </parent>
    <dependencies>
    <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
    </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>
    </dependency>
    
    </dependencies>
    <build>
    <plugins>
    <plugin>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-maven-plugin</artifactId>
    </plugin>
    </plugins>
    </build>

# 2.编写测试代码 #

1. 改写一下application.properties的配置（定义扫描的包是在工程的mapper包下，如果要用mapping.xml也是在resources的mapping文件夹下 ，我开起了驼峰命名法，为了处理数据库中的"\_" 以及实体类中的驼峰命名）

mybatis.type-aliases-packag=com.zqj.springboot2.mapper
    mybatis.mapper-locations=classpath:mapping/*.xml
    #开启驼峰的
    mybatis.configuration.map-underscore-to-camel-case=true

2.编写mapper层的接口代码

写一个查询所有数据的查询语句

@Mapper  //mapper注解一定是要用的
    @Repository
    public interface GamesMapper {
    
        @Select("SELECT game_id , game_name,game_description FROM games")
        public List<GamesPO> listGames();
    
    }

然后去controller写一个方法调用

@GetMapping("/listGames")
        @ResponseBody
        public String listGames() {
            StringBuilder stringBuilder = new StringBuilder("");
            List<GamesPO> list = gamesMapper.listGames();
            for (GamesPO g : list) {
                System.out.println("g:" + g.toString());
                stringBuilder.append(g.toString());
                stringBuilder.append("\r\n");
            }
            System.out.println(stringBuilder.toString());
            return stringBuilder.toString();
        }

# 3.测试 #

测试连接：

http://localhost:8080/game/listGames

后台显示：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI4MTk4MTgx_size_16_color_FFFFFF_t_70][]

前台显示(JSON串):

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI4MTk4MTgx_size_16_color_FFFFFF_t_70 1][]

以上。

[https_www.majiaxueyuan.com_front_showcoulist]: https://www.majiaxueyuan.com/front/showcoulist
[https_www.bilibili.com_video_av47407342]: https://www.bilibili.com/video/av47407342/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI4MTk4MTgx_size_16_color_FFFFFF_t_70]: /images/20211129/906ca33970f242a68a30a803ff100f1c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI4MTk4MTgx_size_16_color_FFFFFF_t_70 1]: /images/20211129/c0ea18a61bf74df98a5d411c73b7e0f8.png