/***npminstallmysql-save*/varmysql=require('mysql');constconf={主机：'localhost'，用户：'root'，密码：'123456'，数据库：'test_db'，字符集:'utf8mb4',};functionXMysql(){/***批量插入*@sqlinsertinto`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){returnnewPromise((resolve,reject)=>{varconnection=mysql.createConnection(conf);connection.connect();connection.query(sql,[params],function(error,results,fields){connection.end();if(error){reject(error);}else{resolve(results);}});});};/***更新*@sqlupdatetab_tmpsettmp_field=?在哪里身份证=？*@params[field,id]*/this.update=function(sql,params){returnnewPromise((resolve,reject)=>{varconnection=mysql.createConnection(conf);connection.connect();连接.query(sql,params,function(error,results,fields){if(error){reject(error);}else{resolve(results);}});connection.end();});};/***根据SQL执行查询*@sqlselect*fromuser_tabwhereid=1*/this.select=function(sql){returnnewPromise((resolve,reject)=>{varconnection=mysql.createConnection(conf);connection.connect();connection.query(sql,function(error,results,fields){if(error){reject(error);}else{resolve(results);}});连接结束（）；});};}module.exports=newXMysql();用法：constxm=require('./xmysql');xm.select("select*fromuser_tabwhereid=1",res=>{console.log(res);});这样既可以查询内容，也可以优化数据库连接，做一个连接池。。不过我就写到这里，让Gadgets用到，所以没有这个要求了。。。==LOG-FooterStart=======================================作者公众号：Loyomer简洁：Kxvz的生活账簿。技术、生活、随笔、文摘……欢迎大家关注……==LOG-FooterEnd=====================================
