mysql - 从另一个文件调用回调？ Node js表达

Question

为什么我无法将回调作为记录？必须作为字段('id')SS:https://prnt.sc/ju4xb2

结果从 DAO 读取为数据行[0]

我如何从记录 ex: '0001' 获取数据？请帮忙谢谢

DAO

    var executeQuery = function(query,callback) {    
        var connection = mysql.createConnection({
            host: 'localhost',
            user: 'root',
            password: '',
            database: 'testt'
        });
        connection.connect();
        connection.query(query, function(err, rows, fields) {
            if (err) throw err;
            connection.end();
            console.log("Here in Dao: " + rows[0].mobile_phone);
            callback(rows[0].mobile_phone);
        });
    };

    module.exports = {
        executeQuery: executeQuery
    };

型号

    var DAO = require('../lib/database.js');

    module.exports = {

    getuser : function(id,callback){

           var User =  DAO.executeQuery("select mobile_phone from ms_customer WHERE id = " + id, function(mobile_phone){
            // var json = JSON.stringify(User);
            console.log("Return from Dao = " +User);   
            callback(mobile_phone);
           });
        }
    }
    

Controller

 

    test : function(req,res){
      var customerModel = require('../model/customer');
      customerModel.getuser('0001', function(mobile_phone){
        console.log("return from model_user = " + mobile_phone);
      });
    },

我总是遇到错误 = 'ER_BAD_FIELD_ERROR:'where 子句'' 中存在未知列 '0001'

Answer 1

我认为查询语句有错误，请尝试这个。

getuser : function(id,callback){

       var User =  DAO.executeQuery("select mobile_phone from ms_customer WHERE id = '" + id + "';", function(mobile_phone){
        // var json = JSON.stringify(User);
        console.log("Return from Dao = " +User);   
        callback(mobile_phone);
       });
    }
}