1 安装Node的MySQL模块,方法有两种:
一种是手动在package.json中添加依赖(dependencies),然后执行 npm install。
一种是直接执行 npm install mysql。
package.json示例:
[javascript]
{
"name": "test",
"version": "0.0.0",
"private": true,
"scripts": {
"start": "node ./bin/www"
},
"dependencies": {
"mysql":"latest"
}
}
[/javascript]
2 Node连接MySQL的示例:
[javascript]
let mysql = require('mysql');
let connection = mysql.createConnection({
host:'localhost',
user:'root',
password:'850804',
database:'test'
});
connection.connect();
connection.query('SELECT 1+1 AS solution', function(err,rows,fields){
if(err) throw err;
console.log('The solution is: ', rows[0].solution);
});
connection.end();
[/javascript]
您的赞助将会支持作者创作及本站运维
发表评论