node.js连接mysql并进行数据操作

今天学习了node.js基本语了，参考网上数据库操作，发现在还存在一些问题，通过我的修改，操作数据成功

首先需要导入mysql需要的库
npm install mysql 此命令是导入到本地  npm install -g mysql此命令是导入到全局

var _mysql = require('mysql');

var HOST = 'localhost';
var PORT = 3306;
var MYSQL_USER = 'root';
var MYSQL_PASS = '**********';
var DATABASE = 'test';
var TABLE = 'mytable';

var mysql = _mysql.createConnection({
    host: HOST,
    port: PORT,
    user: MYSQL_USER,
    password: MYSQL_PASS,
});

//mysql.query('use ' + DATABASE);


mysql.query('use ' + DATABASE, function(error, results) {
if(error) {
console.log('ClientConnectionReady Error: ' + error.message);
mysql.end();
return;
}
});

ClientReady = function(client)
{
  var values = ['Chad', 'Lung', 'Hello World'];
  client.query('INSERT INTO MyTable SET firstname = ?, lastname = ? , message = ?', values,
    function(error, results) {
      if(error) {
        console.log("ClientReady Error: " + error.message);
        client.end();
        return;
      }
      console.log('Inserted: ' + results.affectedRows + ' row.');
      console.log('Id inserted: ' + results.insertId);
    }
  );
  GetData(client);
}

GetData = function(client)
{
  client.query(
    'SELECT * FROM MyTable',
    function selectCb(error, results, fields) {
      if (error) {
          console.log('GetData Error: ' + error.message);
          client.end();
          return;
      }
      // Uncomment these if you want lots of feedback
      //console.log('Results:');
      //console.log(results);
      //console.log('Field metadata:');
      //console.log(fields);
      //console.log(sys.inspect(results));

      if(results.length > 0)
      {
        var firstResult = results[0];
        console.log('First Name: ' + firstResult['firstname']);
        console.log('Last Name: ' + firstResult['lastname']);
        console.log('Message: ' + firstResult['message']);
      }
  });

  client.end();
  console.log('Connection closed');
};

ClientReady(mysql);

运行的结果是：