ConnectMysql.js 连接MysqlJS 脚本 function _exec() { var mysql=require('mysql'); var option = { host: 'localhost', port: '3306', user: 'root', password: 'root', database: 'mysql' }; this.query=function(sqls,values,_back){ var operate={}; operate.create=function(){ operate.client = mysql.createConnection(option); }; operate.error=function(_){ operate.client.on('error',function(err) { if (err.errno != 'ECONNRESET') { console.log('err.ECONNRESET: ',_); throw err; } else { console.log('operate error!'); } }); }; operate.connect=function(_){ operate.create(); operate.client.connect(function(err) { if (err) { console.log('query: ',err); return; } operate.client.query(sqls || '',values || [], function(err, rows){ _back(err, rows); operate.client.end(); }); }); operate.error('query error!'); }; operate.connect(); }; return this; } exports.exec = _exec; // var $ = require('jquery'); // console.log($('<html><body><h1>Hello World!</h1><p class="hello">Heya Big World!</body></html>').find('.hello').text()); var conn = require('./conndata').exec(); conn.query('select loginuser ,loginuserpssd from loginuser where loginuser = ?',['root'],function(err,row){ console.log('row1: ',row); }); conn.query('select loginuser ,loginuserpssd from loginuser where loginuser = ?',['root'],function(err,row){ console.log('row2: ',row); });