获取资源列表

前置内容

1. 【Nodejs express 连接Mysql】: https://www.hyz.cool/articles/207
2. 【Nodejs express 连接 Redis】: https://www.hyz.cool/articles/208
3. 【统一后端返回数据格式——云剪切板】: https://www.hyz.cool/articles/209

路由

• RouterController.js

const ResourceController = require("./ResourceController")

module.exports =(app)=>{
    app.use("/resource",ResourceController)
}
js

• ResourceController.js

const express = require("express");
const ResourceController  = express.Router();

const ResourceService = require("../services/ResourceService")

/**
 * 获取资源列表
 */
ResourceController.get("/list",ResourceService.listResource)

module.exports = ResourceController;
js

数据库访问

• ResourceDao.js

import {Query} from "../services/MysqlService";

export const listResource = () => {
    return Query("SELECT * FROM `tb_resource`")
}
js

服务实现

• ResourceService.js

const Result = require("../utils/Result")

const ResourceDao = require("../daos/ResourceDao")

/**
 * 获取资源列表
 */
export const listResource = (req,res,next)=>{
    //查询
    ResourceDao.listResource().then(result=>{
        return Result.result(res,Result.success(result))
    }).catch(err=>{
        return Result.result(res,Result.failed("获取资源失败"))
    })
}
js