nodejs连接数据库增删改查语句

1. nodejs 结合erpess框架 连接MySql数据库

   const mysql = require('mysql')
   module.exports = {
       // 数据库配置
       config: {
           host: '182.92.159.81',
           port: '端口号',
           user: 'root',
           password: '你的数据库密码',
           database: '数据表名称'
       },
       // 连接数据库 
       sqlConnect: function (sql, sqlArr, callBack) {
           var pool = mysql.createPool(this.config)
           pool.getConnection((err, conn) => {
               console.log('1234')
               if (err) {
                   console.log('连接失败', err);
                   return
               }
               // 事件驱动回调
               conn.query(sql, sqlArr, callBack);
               conn.release()
           })
       }
   }

2. 用nodejs写一个请求列表的接口  

// 技能卡列表
findSkill = (req, res) => {
//分页
    const page = req.query.page || 1;
    const pageSize = req.query.pageSize || 10;

    const countSql = 'SELECT COUNT(*) AS total FROM find_skills';
    const countSqlArr = [];
    const countCallBack = (err, countData) => {
        if (err) {
            console.log('连接出错');
        } else {
            const total = countData[0].total;

            const offset = (page - 1) * pageSize;

            const dataSql = `SELECT find_skills.*, find_users.nick_name, DATE_FORMAT(find_skills.create_at, '%Y-%m-%d %H:%i:%s') AS formatted_create_at FROM find_skills INNER JOIN find_users ON find_skills.id = find_users.id LIMIT ${offset}, ${pageSize}`;
            const dataSqlArr = [];
            const dataCallBack = (err, data) => {
                if (err) {
                    console.log('连接出错');
                } else {
                    res.send({
                        'total': total,
                        'list': data.map(item => {
                            return {
                                ...item,
                                create_at: item.formatted_create_at
                            };
                        })
                    });
                }
            };
            dbConfig.sqlConnect(dataSql, dataSqlArr, dataCallBack);
        }
    };
    dbConfig.sqlConnect(countSql, countSqlArr, countCallBack);
};

 3.根据id删除

// 删除帖子的接口
deleteFeed = (req, res) => {
    // console.log('req', req);
    var feedId = req.query.id; // 获取要删除的帖子的ID

    // 构建删除语句
    const sql = `DELETE FROM 你的数据表名字 WHERE id = ?`;
    console.log('111', req);
    const sqlArr = [feedId];
    const callBack = (err, data) => {
        if (err) {
            console.log('连接出错');
        } else {
            res.send({
                'message': '帖子删除成功'
            });
        }
    };

    dbConfig.sqlConnect(sql, sqlArr, callBack);
};