Node-mysql use

var mysql = require (' mysql ');//create MySQL Connection pool resource var pool = Mysql.createpool ({    host     : ' localhost ',    user     : ' r Oot ',    password: ' Root ',    database: ' Test '}); exports.query = function (sql, arr, callback) {    //Establish link    Pool.getconnection (function (err,connection) {        if (err) {throw err;return;}        Connection.query (Sql,arr,function (error,results,fields) {            //returns the link to the connection pool, ready to be reused by someone else            connection.release ( );            if (error) throw error;            Execute callback function, return data to            callback && callback (Results,fields);});};    

　　

2. On the page call

var db = require ('./... /model/db ');  The path of the require is the path of our DB module relative to this file Db.query (' select * from user ', [], function (results,fields) {////    Query callback    // The results represents the result of the query, and if it is an operation such as inserting a modification, returns the object that affects the database information    //fields representing the field information of the query}

　　

Node-mysql use