javascript - Javascript - 如何结束与数据库的连接？

Question

我有一个代码，它运行良好(从数据库获取数据)，但是当我从终端运行它时(例如node db.js) - 它返回数据但永远不会关闭(无法在终端中输入下一个命令。

var mysql = require('mysql');

var connection = mysql.createConnection({
    host: '...',
    user: '...',
    password: "...,
    port : ..., //port mysql
    database: '...'
});

connection.connect(function(err) {
  if (err) throw err;
  connection.query("SELECT * FROM table", function (err, result, fields) {
    if (err) throw err;
    console.log(result);
  });
});

.js 末尾应该添加什么？

Answer 1

您可以使用connection.end();结束连接您必须将其添加在查询之后，因为必须先完成查询。这是您修改后的代码:

var mysql = require('mysql');

var connection = mysql.createConnection({
    host: '...',
    user: '...',
    password: "...,
    port : ..., //port mysql
    database: '...'
});

connection.connect(function(err) {
  if (err) throw err;
  connection.query("SELECT * FROM table", function (err, result, fields) {
    if (err) throw err;
    console.log(result);
  });
  connection.end();
});

Closing the connection is done using end() which makes sure all remaining queries are executed before sending a quit packet to the mysql server.

https://github.com/mysqljs/mysql#introduction