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);
});