准备工作:需要nodejs安装mysql模块
cnpm install mysql
查询数据
var mysql = require("mysql");
var connection = mysql.createConnection({
host:'localhost',
user:'root',
password:'admin',
database:'studb'
});
var connect =connection.connect();
console.log(connect);
var sql = 'SELECT * FROM stu';
//查
connection.query(sql,function (err, result) {
if(err){
console.log('[SELECT ERROR] - ',err.message);
return;
}
console.log('--------------------------SELECT----------------------------');
console.log(result);
console.log('------------------------------------------------------------\n\n');
});
connection.end();