问题描述
在这里,我正在做一些基本的错误,一般来说,我已经实现了这样一个代码:
Here I am doing, propably some basic mistake, In general, I've implemented such a code:
module.exports = {
getDataFromUserGps: function(callback)
{
connection.connect();
connection.query("SELECT * FROM usergps",
function(err, results, fields) {
if (err) return callback(err, null);
return callback(null, results);
}
);
connection.end();
},
loginUser: function(login, pass, callback)
{
connection.connect();
connection.query(
"SELECT id FROM users WHERE login = ? AND pass = ?",
[login, pass],
function(err, results, fields)
{
if (err) return callback(err, null);
return callback(null, results);
}
);
connection.end();
},
getUserDetails: function(userid, callback)
{
connection.connect();
connection.query(
"SELECT * FROM userProfilDetails LEFT JOIN tags ON userProfilDetails.userId = tags.userId WHERE userProfilDetails.userid = ?",
[userid],
function(err, results, fields)
{
if (err) return callback(err, null);
return callback(null, results);
}
);
connection.end();
},
addTags: function(userId, tags)
{
connection.connect();
connection.query(
"INSERT INTO tag (userId, tag) VALUES (?, ?)",
[userId, tags],
function(err, results, fields)
{
if (err) throw err;
}
)
connection.end();
}
}
一切都很好,但只有第一次,如果我想第二次使用查询,我收到他的错误:
And everything works great, but only by first time, If I want to "use" query by the second time I've receive his error:
我尝试过没有.end()连接,但没有帮助
提前感谢
Radek
I've tried not to .end() connections but it does not help
Thanks in advance
Radek
推荐答案
如果使用node-mysql模块,只需删除.connect和.end。自己解决了这个问题。显然,他们在上次的迭代中推送了不必要的代码,这也是bug的。如果您已经运行createConnection调用
If you using the node-mysql module, just remove the .connect and .end. Just solved the problem myself. Apparently they pushed in unnecessary code in their last iteration that is also bugged. You don't need to connect if you have already ran the createConnection call
这篇关于调用退出后无法入站握手的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!