nodejs 与 mysql联接
首先安装Mysql 模块吧
npm install mysql
刚开始在网上搜索了一个测试代码,发现根本就连接不上mysql.
varClient=require('mysql').Client,
client =new Client(),
类似这样的.
查原因:
console.log(require("mysql"));
对象只有5个方法
createConnection
createPool
createQuery
escape
escapeId
没有Client 方法和 属性.
去mysql 模块目录查看了下 Readme.md
#Here is an example on how to use it: ```js var mysql = require('mysql'); var connection = mysql.createConnection({ host : 'localhost', user : 'me', password : 'secret', }); connection.connect();
看来网上的代码是有问题.应该是版本更新了不支持了.自己重新写了测试代码运行正常
// mysql.js //加载mysql Module var Client = require('mysql'); var db_options = { host: "localhost", port: 3306, user: "root", password: "123456", database: "drupal" }; var client = Client.createConnection(db_options); client.connect(); client.query( 'SELECT * FROM actions', function selectCb(err, results, fields) { if (err) { throw err; } console.log(results); console.log(fields); } ); client.end();