NODEJS学习笔记

两个页面的链接

var http = require("http");
var control = require("./main.js");
function app(request, response) {
        response.writeHead(200, {"Content-Type": "text/html;charset=utf-8"});
        getdb(response)
}
//response.wirte();
//response.end()
function getdb(response){
    // 模拟Ajax发送请求
    request="a";
    // 创建链接
    control.cona();
    // 执行mysql 语句
    control.Toconb(request, response);
    //  关闭连接
    control.Toconc()
}
http.createServer(app).listen(8081);

//  这是main.js文件  与上一个页面链接

// 链接数据库
var mysql = require("./mysql");
// 创建链接
var conis;
exports.cona = function(){
        conis = mysql.createConnection({
        host:"localhost",
        user:"root",
        password:"",
        database:"test"
    });
}

// 执行mysql 语句

function conb(request, response){
    var sql="select * from t_xixixi where f_name like '%xue%'";
    conis.query(sql,[],function(er,re){
        if(er){
            console.log(er);
        }
        else{
            console.log("")
            response.write(re.toString());
            response.end()
        }
    })
}
exports.Toconb=conb;
//  关闭连接
function conc(){
    conis.end();
}
exports.Toconc=conc;

转载于:https://my.oschina.net/u/1985334/blog/304057