2.开发视频列表

1.在resources下的mapper下创建VideoMapper.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.xiaoguan.mapper.VideoMapper">
	<select id="listVideo" resultType="Video">
		select  * from video
	</select>
</mapper>

2.在java下的mapper下创建VideoMapper接口

package com.xiaoguan.mapper;

import com.xiaoguan.model.entity.Video;
import java.util.List;

public interface VideoMapper {
    /*
    * 查询视频列表
    * @return
    * */
    List<Video> listVideo();
}

3.在service下创建VideoService接口

package com.xiaoguan.service;

import com.xiaoguan.model.entity.Video;
import java.util.List;

public interface VideoService {
    List<Video> listVideo();
}

4.在service下的Impl下创建VideoServiceImpl.java

package com.xiaoguan.myproject.service.Impl;

import com.xiaoguan.myproject.model.entity.Video;
import com.xiaoguan.myproject.mapper.VideoMapper;
import com.xiaoguan.myproject.service.VideoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class VideoServiceImpl implements VideoService {
    @Autowired
//    @Resource
    private VideoMapper videoMapper;
    @Override
    public List<Video> listVideo() {
        return videoMapper.listVideo();
    }
}

5.在utils下创建JsonData.java

package com.xiaoguan.myproject.utils;

import java.util.jar.JarEntry;

public class JsonData {
    //0表示成功，1表示处理中，-1表示失败
    private Integer code;
    private Object data;
    private String msg;

    public JsonData() {
    }

    public JsonData(Integer code, Object data, String msg) {
        this.code = code;
        this.data = data;
        this.msg = msg;
    }

    //成功，不返回数据
    public static JsonData buildSuccess(){
        return new JsonData(0,null,null);
    }

    //成功，返回数据
    public static JsonData buildSuccess(Object data){
        return new JsonData(0,data,null);
    }

    //失败，返回固定状态码
    public static JsonData buildError(String msg){
        return new JsonData(-1,null,msg);
    }

    //失败，自定义错误码和信息
    public static JsonData buildError(Integer code,String msg){
        return new JsonData(code,null,msg);
    }
    public Integer getCode() {
        return code;
    }

    public void setCode(Integer code) {
        this.code = code;
    }

    public Object getData() {
        return data;
    }

    public void setData(Object data) {
        this.data = data;
    }

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }
}

6.在controller下创建VideoController

import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
@RequestMapping("api/v1/pub/video")
public class VideoController {
    @Autowired
    private VideoService videoService;
    @RequestMapping("list")
    public Object listVideo(){
         List<Video> videoList = videoService.listVideo();
        return JsonData.buildSuccess(videoList);
    }
}

7.在启动类中添加mapper扫描

package com.xiaoguan.myproject;

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

@SpringBootApplication
@MapperScan("com.xiaoguan.myproject.mapper")
public class MyprojectApplication {

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

}