当我运行应用程序时,它向我展示了Database is connected!
db.js
var mysql = require('mysql');
var settings = require('./config');
var db;
var exports = {};
exports.connectdb = function () {
db = mysql.createConnection(settings.Database);
db.connect(function(err){
console.log('connecting');
if(!err) {
console.log('Database is connected!');
return db;
} else {
console.log('Error connecting database!'+err);
return null;
}
});
};
module.exports = exports;但是,当我试图从user.js连接DB时,它显示了connection is null / TypeError: Cannot read property 'query' of undefined。
来自user.js的代码块
var exports = {};
var dbcon = require('../config/db.js');
var dbconn = dbcon.connectdb();
exports.login = function(email,password) {
var userdetails = { name:email, password:password};
var dbconn = dbcon.connectdb();
if ( dbconn == null ) console.log('still nul');
dbconn.query("SELECT * FROM users where email = '"+email+"' and password = '"+password +"'", function (err, result) {
if(err)
{
console.log(result[0]+' err');
return null;
}
});
};
module.exports = exports;发布于 2016-11-25 15:54:41
Node.js本质上是异步的。您正在尝试以同步的方式使用它。要使此工作,您必须使用回调模式。以下是一个例子:
db.js
var mysql = require('mysql');
var settings = require('./config');
var exports = {};
exports.connectdb = function (callback) {
var db = mysql.createConnection(settings.Database);
db.connect(function(err){
callback(err,db);
});
};
module.exports = exports;user.js
var exports = {};
var dbcon = require('../config/db.js');
exports.login = function(email,password) {
var userdetails = { name:email, password:password};
dbcon.connectdb(function(err, dbconn){
if ( err) //handle error
dbconn.query("SELECT * FROM users where email = '"+email+"' and password = '"+password +"'", function (err, result) {
if(err)
{
console.log(result[0]+' err');
}
});
});
};
module.exports = exports;通过上面的代码,您可以看到connectdb函数是如何接受函数回调的。连接数据库后,代码将执行回调以发送结果。在user.js文件中,您现在可以传递一个回调函数并使用它给出的结果( db)。您可以找到更多关于Node.js‘异步性质这里的信息。基本上,异步代码使用回调,同步代码使用return语句。从异步函数返回值通常都会产生空结果,因为异步回调总是在调用函数之后触发“某个时候”。
https://stackoverflow.com/questions/40808364
复制相似问题