js的mysql插件工具_NodeJs Mysql简易操作工具

/**

* npm install mysql -save

*/

var mysql = require('mysql');

const conf = {

host: 'localhost',

user: 'root',

password: '123456',

database: 'test_db',

charset: 'utf8mb4',

};

function XMysql() {

/**

* 批量插入

* @sql insert into `user_tab`(`name`, `gender`, `age`, created`) values ?

* @params [[name1, gender1, age1, created1],[name2, gender2, age2, created2],[name3, gender3, age3, created3]];

*/

this.insert = function (sql, params) {

return new Promise((resolve, reject) => {

var connection = mysql.createConnection(conf);

connection.connect();

connection.query(sql, [params], function (error, results, fields) {

connection.end();

if (error) {

reject(error);

} else {

resolve(results);

}

});

});

};

/**

* 更新

* @sql update tab_tmp set tmp_field = ? where id = ?

* @params [field, id]

*/

this.update = function (sql, params) {

return new Promise((resolve, reject) => {

var connection = mysql.createConnection(conf);

connection.connect();

connection.query(sql, params, function (error, results, fields) {

if (error) {

reject(error);

} else {

resolve(results);

}

});

connection.end();

});

};

/**

* 根据SQL进行查询

* @sql select * from user_tab where id = 1

*/

this.select = function (sql) {

return new Promise((resolve, reject) => {

var connection = mysql.createConnection(conf);

connection.connect();

connection.query(sql, function (error, results, fields) {

if (error) {

reject(error);

} else {

resolve(results);

}

});

connection.end();

});

};

}

module.exports = new XMysql();

使用方式:

const xm = require('./xmysql');

xm.select("select * from user_tab where id = 1", res => {

console.log(res);

});

这样就可以查询出来内容啦,还可以把数据库连接优化一下,做个连接池..但是我这里就随便写一下 做个小工具使用 因此没有这个需求...

==LOG-Footer Start==================================

作者公众号:Loyomer

简洁：Kxvz的生活记账本。技术，生活，随笔，文摘...

欢迎大家关注...

==LOG-Footer End==================================