（数据）Spring-boot Mybatis配置

PS：不要吐槽字段名称， 慕课的大神这么做的

使用的是注解方式

先看下数据库

image.png

既然是使用Mybatis那么我们要下载相关JAR包,我们项目构建是采用maven
如果不知道可以去这个网站http://mvnrepository.com/上查 maven相关JAR包

这里先看下POM文件

<?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>

    <groupId>com.song</groupId>
    <artifactId>springboot-demo</artifactId>
    <version>1.0-SNAPSHOT</version>

    <!--spring boot start-->
      <!-- 使用springboot必须的依赖-->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.9.RELEASE</version>
     </parent>


  <!--构建web需要的依赖 里面内置tomcat-->
    <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>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>4.3.11.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <optional>true</optional>
        </dependency>

      <!-- mybatis依赖  下面必须加mysql支持-->
        <!-- 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>1.3.0</version>
        </dependency>

      <!-- mysql 连接驱动支持-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
    </dependencies>


    <properties>
        <java.version>1.8</java.version>
    </properties>


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

然后看一下yml配置文件

我们在这里设置所有pom相关的配置

image.png

项目试验目录结构

image.png

我们先创建一个数据模型
Model ->Girl

package hello.Model;

import org.springframework.stereotype.Component;

@Component
public class Girl {

    private  Integer id ;
    private String name;
    private char cupSize;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public char getCupSize() {
        return cupSize;
    }

    public void setCupSize(char cupSize) {
        this.cupSize = cupSize;
    }
}

然后我们创建一个映射文件
Mapper->GirlMapper
这个文件是接口类型

  package hello.Mapper;

import hello.Model.Girl;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface GirlMapper {

    @Select("select * from girl where name = #{name}")
    Girl girlFindName(@Param("name") String name);
}

接下来我们创建Controller来获取查询条件
Controller->HelloController

package hello.Controller;

import hello.Mapper.GirlMapper;
import hello.Model.Girl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;




@RestController
public class HelloController {

    @Autowired
    private GirlMapper girlMapper;
    @GetMapping(value = "/name")
    public Girl getUserName(String name){
        return girlMapper.girlFindName(name);
    }


}

最后也是最重要的

需要在启动项类上面添加Mapper扫描设置

package hello;

import java.util.Arrays;

import java.util.Arrays;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.CommandLineRunner;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.Bean;

@MapperScan(basePackages = "hello.Mapper")
@SpringBootApplication
public class Application {

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




}

数据库字段可能需要改一下 这是做完JAP 之后该的字段