springBoot 的 整合（junit ，mybatis）

1.... pom.xml  依赖jar包

<?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.wsc</groupId>
        <artifactId>springBoot01</artifactId>
        <version>1.0-SNAPSHOT</version>
        <!--继承SpringBoot父类  spring-boot-starter-parent-->
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.0.2.RELEASE</version>
        </parent>

        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
        </properties>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <!--添加起步依赖-->
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-freemarker</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-data-jpa</artifactId>
            </dependency>
            <!--mybatis  起步依赖-->
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.1.1</version>
            </dependency>
            <!--测试的起步依赖-->
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
        </dependencies>
<!--    build 作用 : 扫描 mapper 下的 FlightMapper类  完成 自动注入对象，
             Invalid bound statement (not found): com.wsc.core.mapper.FlightMapper.getFlight -->
        <build>
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.*</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
        </build>
    </project>

2.....yaml格式 数据库连接 resources / application.yml 封装的 数据源信息 yaml格式数据

application.yml

3....mapper / FlightMapper 类  ，FlightMapper.xml  mybatis 的映射文件 SQL语句

package com.wsc.core.mapper;

import com.wsc.core.entity.Flighties;

import java.util.List;

public interface FlightMapper {
    public List<Flighties> getFlight();
}

<?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">
<!--namespace 命名空间  类全名-->
<mapper namespace="com.wsc.core.mapper.FlightMapper">
    <select id="getFlight" resultType="com.wsc.core.entity.Flighties">
        select * from flight
    </select>
</mapper>

4....实体类  

package com.wsc.core.entity;

import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Component;

/**
 * @version 1.0
 * @ClassName Person
 * @Description TODO
 * @Author WSC
 * @Date 2019/8/23 11:11
 **/
@ConfigurationProperties(prefix = "person") //  把属性的值批量绑定一个对象上
@Component
public class Person {
    private String name;
    private int age;
    private String sex;
    private String address;
    private String[] myAddress;
    private String[] myAddress1;
    public String getName() {
        return name;
    }

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

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String[] getMyAddress() {
        return myAddress;
    }

    public String[] getMyAddress1() {
        return myAddress1;
    }

    public void setMyAddress1(String[] myAddress1) {
        this.myAddress1 = myAddress1;
    }

    public void setMyAddress(String[] myAddress) {
        this.myAddress = myAddress;
    }
}

package com.wsc.core.entity;

import javax.persistence.*;
import java.io.Serializable;
import java.util.Date;

/**
 * @version 1.0
 * @ClassName Flight
 * @Description TODO
 * @Author WSC
 * @Date 2019/8/22 14:35
 **/

public class Flighties implements Serializable {

    private Integer flight_id;
    private String flight_no;
    private String departure_city;
    private Date departure_time;
    private Date arrival_time;
    private String arrival_city;

    public Integer getFlight_id() {
        return flight_id;
    }

    public void setFlight_id(Integer flight_id) {
        this.flight_id = flight_id;
    }

    public String getFlight_no() {
        return flight_no;
    }

    public void setFlight_no(String flight_no) {
        this.flight_no = flight_no;
    }

    public String getDeparture_city() {
        return departure_city;
    }

    public void setDeparture_city(String departure_city) {
        this.departure_city = departure_city;
    }

    public Date getDeparture_time() {
        return departure_time;
    }

    public void setDeparture_time(Date departure_time) {
        this.departure_time = departure_time;
    }

    public Date getArrival_time() {
        return arrival_time;
    }

    public void setArrival_time(Date arrival_time) {
        this.arrival_time = arrival_time;
    }

    public String getArrival_city() {
        return arrival_city;
    }

    public void setArrival_city(String arrival_city) {
        this.arrival_city = arrival_city;
    }

    @Override
    public String toString() {
        return "Flighties{" +
                "flight_id=" + flight_id +
                ", flight_no='" + flight_no + '\'' +
                ", departure_city='" + departure_city + '\'' +
                ", departure_time=" + departure_time +
                ", arrival_time=" + arrival_time +
                ", arrival_city='" + arrival_city + '\'' +
                '}';
    }
}

package com.wsc.core.entity;

import javax.persistence.*;
import java.util.Date;

/**
 * @version 1.0
 * @ClassName Flight
 * @Description TODO
 * @Author WSC
 * @Date 2019/8/22 14:35
 **/
@Entity //实体构造
@Table(name="flight") //表名
public class Flight {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY) //自增设置
    /**
     * @Column 注解（表的字段）  必须加上 ，不然 test 会报错
     *   报错信息 ： 数据库表 不存在 某个字段
     *   com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.ac_flight' doesn't exist
     */
    @Column(name="flight_id")
    private Integer id;
    @Column(name="flight_no")
    private String flightNo;
    @Column(name="departure_city")
    private String departureCity;
    @Column(name="departure_time")
    private Date departureTime;
    @Column(name="arrival_time")
    private Date arrivalTime;
    @Column(name="arrival_city")
    private String arrivalCity;

    public Integer getId() {
        return id;
    }

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

    public String getFlightNo() {
        return flightNo;
    }

    public void setFlightNo(String flightNo) {
        this.flightNo = flightNo;
    }

    public String getDepartureCity() {
        return departureCity;
    }

    public void setDepartureCity(String departureCity) {
        this.departureCity = departureCity;
    }

    public Date getDepartureTime() {
        return departureTime;
    }

    public void setDepartureTime(Date departureTime) {
        this.departureTime = departureTime;
    }

    public Date getArrivalTime() {
        return arrivalTime;
    }

    public void setArrivalTime(Date arrivalTime) {
        this.arrivalTime = arrivalTime;
    }

    public String getArrivalCity() {
        return arrivalCity;
    }

    public void setArrivalCity(String arrivalCity) {
        this.arrivalCity = arrivalCity;
    }

    @Override
    public String toString() {
        return "Flight{" +
                "id=" + id +
                ", flightNo='" + flightNo + '\'' +
                ", departureCity='" + departureCity + '\'' +
                ", departureTime=" + departureTime +
                ", arrivalTime=" + arrivalTime +
                ", arrivalCity='" + arrivalCity + '\'' +
                '}';
    }
}

5....service  修改数据 方法

package com.wsc.core.service;

import com.wsc.core.dao.FlightDao;
import com.wsc.core.entity.Flight;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.Optional;

/**
 * @version 1.0
 * @ClassName FlightService
 * @Description TODO
 * @Author WSC
 * @Date 2019/8/23 13:24
 **/
@Service
public class FlightService {
    @Autowired
    private FlightDao flightDao;
    @Transactional  //事务  成功 更改  失败 不更改
    //修改 数据
    public void updateArrivalCity(){
        Optional<Flight> byId = flightDao.findById(1);
        Flight flight = byId.get();
        flight.setArrivalCity("上海+郑州");
        flightDao.save(flight);
    }

}

6....dao 继承JpaRepository接口

package com.wsc.core.dao;

        import com.wsc.core.entity.Flight;
        import org.springframework.data.jpa.repository.JpaRepository;
// 继承JpaRepository
public interface FlightDao extends JpaRepository<Flight,Integer> {
}

7....controller 数据地址

package com.wsc.core.controller;

import com.wsc.core.dao.FlightDao;
import com.wsc.core.entity.Flight;
import com.wsc.core.entity.Flighties;
import com.wsc.core.entity.Person;
import com.wsc.core.mapper.FlightMapper;
import com.wsc.core.service.FlightService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * @version 1.0
 * @ClassName FlightController
 * @Description TODO
 * @Author WSC
 * @Date 2019/8/22 14:58
 **/
@RestController //返回json数据 的格式
public class FlightController {
    @Autowired
    private FlightDao flightDao;
    @Autowired
    private Person person;
    @Autowired
    private FlightMapper flightMapper;
    @Autowired
    private FlightService flightService;
    @RequestMapping("/flight/findAll") //访问地址
    //全部数据 查询
    public List<Flight> findAll(){
        List<Flight> flightList = flightDao.findAll();
        return flightList;
    }
    //获取yml文件的数据  person
    @RequestMapping("/person")
    public Person showPerson(){
        return person;
    }
    //获取flight数据库数据 mybatis
    @RequestMapping("/flight/list2")
    public List<Flighties> getList(){
        List<Flighties> flight = flightMapper.getFlight();
        return flight;
    }
    //修改数据
    @RequestMapping("/flight/update")
    public String updateArrivalCity(){
        flightService.updateArrivalCity();
        return "success";
    }
}

package com.wsc.core.controller;

import com.wsc.core.dao.FlightDao;
import com.wsc.core.entity.Flight;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @version 1.0
 * @ClassName ShowController
 * @Description TODO
 * @Author WSC
 * @Date 2019/8/22 16:24
 **/
@Controller
public class ShowController {
    @Autowired
    private FlightDao flightDao;
    @Value("${page.rows}")
    private Integer rows;
    @RequestMapping("/flight/data") //访问地址
    //返回页面数据
    public String showData(Model model){
        List<Flight> flightList = flightDao.findAll();
       model.addAttribute("flightList", flightList);
        return "flight";
    }

    /**
     * 获取yaml里的   page 数据
     * @Value("${page.rows}")  private Integer rows;
     * @return
     */
    @RequestMapping("/page/rows")
    @ResponseBody
   public Map testYml(){
      Map map = new HashMap();
       map.put("rows",rows);
       return map;
   }
}

8....测试类 springBoot与Junit 整合 本地test类  

package com.wsc.core;

import com.wsc.core.entity.Flighties;
import com.wsc.core.mapper.FlightMapper;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.List;

/**
 * @version 1.0
 * @ClassName testSpringBoot
 * @Description TODO
 * @Author WSC
 * @Date 2019/8/23 14:06
 **/
@RunWith(SpringRunner.class)
@SpringBootTest(classes = Start.class) //加载启动 
public class testSpringBoot {
    @Autowired
    private FlightMapper flightMapper;
    @Test
    public void testSpringBoot(){
        List<Flighties> flight = flightMapper.getFlight();
        for(Flighties flighties:flight){
            System.out.println(flighties);
        }

    }
}

9....启动类：@SpringBootApplication    @MapperScan

package com.wsc.core;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

/**
 * @version 1.0
 * @ClassName Start
 * @Description TODO
 * @Author WSC
 * @Date 2019/8/22 14:56
 **/

/**
 * springBoot启动类
 */
@SpringBootApplication
@MapperScan(basePackages = "com.wsc.core.mapper") //扫描 mapper下的 所有 注解对象
public class Start {
    /**
     * springBoot 启动方法
     * @param args
     */
    public static void main(String[] args) {
        //类名.class
        SpringApplication.run(Start.class,args);
    }
}