PS：不要吐槽字段名稱邪财， 慕課的大神這么做的

使用的是注解方式

先看下數(shù)據(jù)庫

image.png

既然是使用Mybatis那么我們要下載相關(guān)JAR包,我們項目構(gòu)建是采用maven
如果不知道可以去這個網(wǎng)站http://mvnrepository.com/上查 maven相關(guān)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>


  <!--構(gòu)建web需要的依賴 里面內(nèi)置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 連接驅(qū)動支持-->
        <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配置文件

我們在這里設(shè)置所有pom相關(guān)的配置

image.png

項目試驗?zāi)夸浗Y(jié)構(gòu)

image.png

我們先創(chuàng)建一個數(shù)據(jù)模型
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;
    }
}

然后我們創(chuàng)建一個映射文件
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);
}

接下來我們創(chuàng)建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掃描設(shè)置

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




}

數(shù)據(jù)庫字段可能需要改一下 這是做完JAP 之后該的字段