Node JS 连接Mysql 数据库

最新推荐文章于 2024-07-04 09:16:19 发布

CONLONG

最新推荐文章于 2024-07-04 09:16:19 发布

阅读量994

点赞数

分类专栏：脚本语言

本文链接：https://blog.csdn.net/CONLONG/article/details/26362799

版权

脚本语言专栏收录该内容

4 篇文章 0 订阅

订阅专栏


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

});

CONLONG

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Node JS 连接Mysql 数据库

function _exec() { var mysql=require('mysql'); var option = { host: 'localhost', port: '3306', user: 'root', password: 'root', database: 'mysql' }; this.query=function(sql
复制链接

扫一扫

专栏目录