1. 获取数据

通过python爬取一些图片数据保存到数据库中.略过

2. 写接口

获取所有数据库中的图片数据
实体

package com.link.model;

public class Img {
    private Integer id;
    private String name;
    private String url;

    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 String getUrl() {
        return url;
    }

    public void setUrl(String url) {
        this.url = url;
    }
}

controller层

package com.link.controller;

import com.link.common.ResponseResult;
import com.link.model.Img;
import com.link.service.ImgService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class ImgController {
    @Autowired
    private ImgService imgService;
    @RequestMapping(value = "/img",method = RequestMethod.GET)
    public ResponseResult findAll(){
        List<Img> list=imgService.findAll();
        return new ResponseResult(200,"操作成功!",list);
    }

}

dao层

package com.link.dao;

import com.link.model.Img;

import java.util.List;

public interface ImgDao {
    List<Img> findAll();
}

service 接口层

package com.link.service.impl;

import com.link.dao.ImgDao;
import com.link.model.Img;
import com.link.service.ImgService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class ImgServiceImpl implements ImgService {
    @Autowired
    private ImgDao imgDao;
    public List<Img> findAll() {
        return imgDao.findAll();
    }
}

service层

package com.link.service;


import com.link.model.Img;

import java.util.List;

public interface ImgService {

    List<Img> findAll();
}

mapper

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

<!-- 设置为IUserDao接口方法提供sql语句配置 -->
<mapper namespace="com.link.dao.ImgDao">
    <select id="findAll" resultType="Img" parameterType="int">SELECT * FROM bian</select>
</mapper>

ResponseResult响应结果

package com.link.common;

import com.fasterxml.jackson.annotation.JsonInclude;

@JsonInclude(JsonInclude.Include.NON_NULL)
public class ResponseResult <T>{
    private Integer code;
    private String msg;
    private T data;

    public ResponseResult(Integer code, String msg) {
        this.code = code;
        this.msg = msg;
    }

    public ResponseResult(Integer code, String msg, T data) {
        this.code = code;
        this.msg = msg;
        this.data = data;
    }

    public Integer getCode() {
        return code;
    }

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

    public String getMsg() {
        return msg;
    }

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

    public T getData() {
        return data;
    }

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

postman测试接口

image.png

浏览器测试接口

image.png

image.png

接口测试成功!