Node.js实现连接mysql数据库功能示例

npm install node-mysql

var express = require('express');var mysql = require('mysql');var app = express();app.use(function(req, res, next){ console.log('%s %s', req.method, req.url); next();});var conn = mysql.createConnection({  host:'localhost',  user:'root',  database:'ceshi',  password:'123456',  port:3306});conn.connect();app.get('/', function(req, res){  conn.query('SELECT * from ceshibiao', function(err, rows, fields) {    if(err) throw err;    var data = '';    foreach(rows,function(key,value){      data += '<p>' + 'contents：' + value.contents + '</p>';      data += '<hr />';    }    res.send(data);  });});app.listen(81);console.log('Listening on port 81');