express+mysql连接池

db.js

var mysql=require("mysql");

// 创建连接池
var pool = mysql.createPool({
    host: 'localhost',
    user: 'root',
    password: 'root',
    database: 'test1',
    port: 3306
});

// 连接公用方法
var query=function(sql,options,callback){
    pool.getConnection(function(err,conn){
        if(err){
            callback(err,null,null);
        }else{
            conn.query(sql,options,function(err,results,fields){
                //释放连接  
                conn.release();
                //事件驱动回调  
                callback(err,results,fields);
            });
        }
    });
};

module.exports=query;  

index.js

var express = require("express");
var app = express();
var formidable = require("formidable");
var query = require("./db.js");

app.get("/",function(req,res,next) {
    // 防止跨域，测试时使用
    res.header("Access-Control-Allow-Origin", "*");
    // 使用表单提交插件
    var form = new formidable.IncomingForm();
    form.parse(req, function(err, fields) {
        console.log(req.query.name);
        query("select * from student where s_name = ?",[req.query.name], function (err, rows, fields) {
            if (err) {
                throw err;
            }else{
                res.send(rows);
            }
        });
    });
});

app.listen(3000);