044Node.js后端mysql、sqlite数据库和file文件数据读写封装方案

044Node.js后端mysql、sqlite数据库和file文件数据读写封装方案

来自前端的交互示例

• VUE3示例

<script setup lang="ts">
import Api from '@/utils/Api';
import As from '@/utils/As';
import {
      reactive, ref } from 'vue';
const types = [
  {
      label: '一星', value: 1 },
  {
      label: '二星', value: 2 },
  {
      label: '三星', value: 3 },
];
const lists: any = ref([]);

const itemData: any = reactive({
     
  data: {
      id: '123', title: '标题1', content: '内容1', type: 1 },
});

const activeNames = ref(['1']);
const handleChange = (val: string[]) => {
     
  console.log(val);
};
function add() {
     
  Api({
     
    url: '/apisqlitetest/add',
    method: 'POST',
    data: itemData.data,
  }).then((res: any) => {
     
    console.log(666.999, res);
    getLists();
  });
}
function del(item: any) {
     
  Api({
     
    url: '/apisqlitetest/del',
    method: 'GET',
    params: {
      id: item.id },
  }).then((res: any) => {
     
    console.log(666.999, res);
    getLists();
  });
}
function read(item: any) {
     
  Api({
     
    url: '/apisqlitetest/read',
    method: 'GET',
    params: {
      id: item.id },
  }).then((res: any) => {
     
    itemData.data = As.jsonParse(res.data[0].content);
    console.log(666.999, res);
  });
}
function edit() {
     
  Api({
     
    url: '/apisqlitetest/edit',
    method: 'POST',
    data: itemData.data,
  }).then((res: any) => {
     
    console.log(666.999, res);
    getLists();
  });
}
function getLists() {
     
  Api({
     
    url: '/apisqlitetest/list',
    method: 'GET',
  }).then((res: any) => {
     
    lists.value = res.data;
    if (lists.value && typeof lists.value === 'object' && lists.value.length) {
     
      lists.value.forEach((el: any) => {
     
        el.content = As.jsonParse(el.content);
      });
    } else {
     
      lists.value = [];
    }
    console.log(666.999, lists.value);
  });
}
getLists();
script>

<template>
  <el-form label-width="120px"
    >{
  { itemData.data }}
    <el-form-item label="编号">
      <el-input v-model="itemData.data.id" />
    el-form-item>
    <el-form-item label="标题">
      <el-input v-model="itemData.data.title" />
    el-form-item>
    <el-form-item label="类型">
      <el-select v-model="itemData.data.type" placeholder="选择类型">
        <el-option
          v-for="item in types"
          :label="item.label"
          :value="item.value"
        />
      el-select>
    el-form-item>
    <el-form-item label="内容">
      <el-input v-model="itemData.data.content" type="textarea" />
    el-form-item>
    <el-form-item>
      <el-button type="primary" @click="add()"> 新增 el-button>
      <el-button @click="edit()"> 提交 el-button>
    el-form-item>
  el-form>

  <el-collapse v-model="activeNames" @change="handleChange">
    <el-collapse-item
      v-for="(item, index) in lists"
      :title="item.content.title"
      :name="index"
    >
      <div>
        <el-button type="primary" @click="del(item.content)"> 删除 el-button>
        <el-button type="primary" @click="read(item.content)"> 编辑 el-button>
        {
  { item.content.content }}
      div>
    el-collapse-item>
  el-collapse>
template>

<style scoped lang="scss">style>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150

后端路由承接

module.exports = (route: any) => {
   
  const dbSql: any = require('../../../utils/Data/Index')('sqlite');

  const As: any = require('../../../utils/As');
  route
    .post('/add', async (ctx: any) => {
   
      const dataStr: any = await As.getCtxData(ctx);
      As.clog(666.1002, 'add', dataStr);
      await dbSql
        .sqlDb({
   
          type: 'insert',
          table: 'apifiletest',
          field: ['name', 'content'],
          value: [[As.jsonParse(dataStr).id, dataStr]],
        })
        .then((res: any) => {
   
          As.clog(10022, res);
          ctx.body = res;
        })
        .catch((err: any) => {
   
          As.clog(10021, err);
        });
    })
    .post('/edit', async (ctx: any) => {
   
      const dataStr: any = await As.getCtxData(ctx);
      As.clog(666.1004, 'edit', dataStr);
      await dbSql
        .sqlDb({
   
          type: 'update',
          table: 'apifiletest',
          set: [['content', dataStr]],
          where: [['name', '=', As.jsonParse(dataStr).id]],
        })
        .then((res: any) => {
   
          As.clog(10042, res);
          ctx.body = res;
        })
        .catch((err: any) => {
   
          As.clog(10041, err);
        });
    })
    .get('/del', async (ctx: any) => {
   
      As.clog(666.1006, 'del', ctx.query.id);
      await dbSql
        .sqlDb({
   
          type: 'delete',
          table: 'apifiletest',
          where: [['name', '=', ctx.query.id]],
        })
        .then((res: any) => {
   
          As.clog(10062, res);
          ctx.body = res;
        })
        .catch((err: any) => {
   
          As.clog(10061, err);
        }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68