nodejs简单访问及操作mysql数据库的方法示例

var mysql = require('mysql'); //调用MySQL模块 mysql模块要安装 $ npm install mysql//创建一个connectionvar connection = mysql.createConnection({  host   : '127.0.0.1',    //主机  user   : 'root',        //MySQL认证用户名  password : '',    //MySQL认证用户密码  port: '3306',          //端口号  database:''   //数据库名});//创建一个connectionconnection.connect(function(err){  if(err){    console.log('[query] - :'+err);    return;  }  console.log('[connection connect] succeed!');});//执行SQL语句connection.query('SELECT 1 + 1 AS solution', function(err, rows, fields) {  if (err) {    console.log('[query] - :'+err);    return;  }  console.log('The solution is: ', rows[0].solution);});//关闭connectionconnection.end(function(err){  if(err){    return;  }  console.log('[connection end] succeed!');});