四十一 （后端）搭建数据库表和数据结构

记得先在后端安装mysql

var mysql = require('mysql')
var connection = mysql.createConnection({
    host: '127.0.0.1',
    user: 'root',
    password: '123456',
    database: 'uniapp'
}) 

module.exports = connection

编写后端查询数据接口

// 查询商品数据-数据库
var connection = require('../sql/mysql')
router.get('/api/goods/search', function(req, res, next) {
        // 获取前端传递过来的参数
        // desc 降序  asc升序
        // 获取对象的key 和 value 
        let [goodName, orderName] = Object.keys(req.query);
        let [Name, order] = Object.values(req.query);
        // 数据库进行 模糊查询
      // connection.query('select * from search_list where name like "%' + Name + '%" order by ' + orderName + ' ' + order + '',
connection.query(`select * from search_list where name like "%${Name}%" order by ${orderName} ${order}`,
                function(
                        err, result) {
                        console.log(result);
                        res.send({
                                code: 0,
                                data: result
                        })
                })
});