01_2.SpringBoot前后端简单响应（后台）

1.基础打通数据库

1.1. AdMapper.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.AdMapper">

    <select id="listVideo" resultType="Ad">

        select  * from video

    </select>

</mapper>

1.2 AdMapper.java

package com.example.demo.Mapper;

import com.example.demo.model.entity.Ad;

import java.util.List;

public interface AdMapper {
    List<Ad> listVideo();
}

1.3 AdController.java

package com.example.demo.Controller;

import com.example.demo.Service.AdService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@RequestMapping("k")
public class AdController {

    @Autowired
    private AdService adService;

    @GetMapping("add")
    public Object listVideo(){

        return adService.listVideo();
    }

}

1.4 AdService.java

package com.example.demo.Service;

import com.example.demo.model.entity.Ad;
import org.springframework.stereotype.Service;

import java.util.List;


public interface AdService {
    List<Ad> listVideo();
}

1.5 AdServiceImpl.java

package com.example.demo.Service.Impl;

import com.example.demo.Mapper.AdMapper;
import com.example.demo.Service.AdService;
import com.example.demo.model.entity.Ad;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class   AdServiceImpl implements AdService {


    @Autowired
    private AdMapper adMapper;

    @Override
    public List<Ad> listVideo() {

        return adMapper.listVideo();
    }
}

1.6 Ad.java

package com.example.demo.model.entity;

import java.util.Date;

public class Ad {
    private Integer id;

    private String title;


    private String summary;


    private String coverImg;

    private Integer  price;


    private Date createTime;


    private Double point;


    public Integer getId() {
        return id;
    }

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

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public String getSummary() {
        return summary;
    }

    public void setSummary(String summary) {
        this.summary = summary;
    }

    public String getCoverImg() {
        return coverImg;
    }

    public void setCoverImg(String coverImg) {
        this.coverImg = coverImg;
    }

    public Integer getPrice() {
        return price;
    }

    public void setPrice(Integer price) {
        this.price = price;
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public Double getPoint() {
        return point;
    }

    public void setPoint(Double point) {
        this.point = point;
    }

    @Override
    public String toString() {
        return "Video{" +
                "id=" + id +
                ", title='" + title + '\'' +
                ", summary='" + summary + '\'' +
                ", coverImg='" + coverImg + '\'' +
                ", price=" + price +
                ", createTime=" + createTime +
                ", point=" + point +
                '}';
    }
}