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