增删改查 mysql函数封装_node-mysql增删改查封装

util=require(‘util‘);var mysql=require(‘mysql‘);

const HOST=‘127.0.0.1‘;

const USER=‘root‘;

const PASS=‘‘;

const prefix=‘blog_‘;

const DATABASE=‘app_blog‘;

const PORT=3306const db=mysql.createPool({

host:HOST,

user:USER,

password:PASS,

database:DATABASE,

port:PORT

});var findOne=function (table,where,callback){ //查找一条；

//whre is arr; [{id:1},{username:admin}];

var _WHERE=‘‘;if(util.isObject(where)){

_WHERE+=‘WHERE ‘;for(var k inwhere){

_WHERE+=k+"=‘"+where[k]+"‘ AND ";

}

_WHERE=_WHERE.slice(0,-4);

}else if(typeof where ==‘string‘){

_WHERE=‘WHERE ‘+where;

}var sql="SELECT * FROM "+prefix+table+‘ ‘+_WHERE+‘ LIMIT 1‘;

console.log(sql+‘-------------------------‘);

db.query(sql,function(err,data){if(err){

callback(err,0);

}else{

callback(err,data[0]);

}

});

}var select=function(table,callback){ //查找所有；

var sql="SELECT * FROM "+prefix+table;

console.log(sql);

db.query(sql,callback);

}var insert =function(table,obj,callback){//insert into table() values()

//{username:‘guojikai‘,age:‘55‘,sex:‘1‘}

var fields=‘‘;var values=‘‘;for( var k inobj){

fields+=k+‘,‘;

values=values+"‘"+obj[k]+"‘,"}

fields=fields.slice(0,-1);

values=values.slice(0,-1);var sql="INSERT INTO "+prefix+table+‘(‘+fields+‘) VALUES(‘+values+‘)‘;

console.log(sql+‘--------------‘);

db.query(sql,callback);

}/**

sets is object；

where is object;*/

var update=function(table,sets,where,callback){var _SETS=‘‘;var _WHERE=‘‘;var keys=‘‘;var values=‘‘;for(var k insets){

_SETS+=k+"=‘"+sets[k]+"‘,";

}

_SETS=_SETS.slice(0,-1);for(var k2 inwhere){

_WHERE+=k+"=‘"+where[k2]+"‘ AND ";

}//update table set username=‘admin2‘,age=‘55‘ where id="5";

var sql="UPDATE "+prefix+table+‘ SET ‘+_SETS+‘ ‘+_WHERE;

db.query(sql,callback);

}var del=function(table,where,callback){var _WHERE=‘‘;for(var k2 inwhere){

_WHERE+=k+"=‘"+where[k2]+"‘ AND ";

}var sql="DELETE FROM "+prefix+table+‘ ‘+_WHERE;

}//var sql_select="SELECT * FROM blog_article";

module.exports={

db:db,

insert:insert,

select:select,

find:find,

del:del,

update:update

};

var util=require(‘util‘);var mysql=require(‘mysql‘);const HOST=‘127.0.0.1‘;const USER=‘root‘;const PASS=‘‘;const prefix=‘blog_‘;const DATABASE=‘app_blog‘;const PORT=3306const db=mysql.createPool({    host:HOST,    user:USER,    password:PASS,    database:DATABASE,    port:PORT});var findOne=function (table,where,callback){ //查找一条；    // whre is arr; [{id:1},{username:admin}];    var _WHERE=‘‘;    if(util.isObject(where)){        _WHERE+=‘WHERE ‘;        for(var k in where){            _WHERE+=k+"=‘"+where[k]+"‘ AND ";        }              _WHERE=_WHERE.slice(0,-4);    }else if(typeof where ==‘string‘){        _WHERE=‘WHERE ‘+where;    }   var sql="SELECT * FROM "+prefix+table+‘ ‘+_WHERE+‘ LIMIT 1‘;   console.log(sql+‘-------------------------‘);   db.query(sql,function(err,data){        if(err){            callback(err,0);        }else{            callback(err,data[0]);        }   });}var select=function(table,callback){ //查找所有；    var sql="SELECT * FROM "+prefix+table;    console.log(sql);    db.query(sql,callback);}var insert =function(table,obj,callback){    //insert into table() values()    //{username:‘guojikai‘,age:‘55‘,sex:‘1‘}    var fields=‘‘;    var values=‘‘;    for( var k in obj){        fields+=k+‘,‘;        values=values+"‘"+obj[k]+"‘,"    }    fields=fields.slice(0,-1);    values=values.slice(0,-1);    var sql="INSERT INTO "+prefix+table+‘(‘+fields+‘) VALUES(‘+values+‘)‘;    console.log(sql+‘--------------‘);    db.query(sql,callback);}/**  sets is object；  where is object;*/var update=function(table,sets,where,callback){    var _SETS=‘‘;    var _WHERE=‘‘;    var keys=‘‘;    var values=‘‘;    for(var k in sets){        _SETS+=k+"=‘"+sets[k]+"‘,";    }    _SETS=_SETS.slice(0,-1);    for(var k2 in where){        _WHERE+=k+"=‘"+where[k2]+"‘ AND ";    }    //update table set username=‘admin2‘,age=‘55‘   where id="5";    var sql="UPDATE "+prefix+table+‘ SET ‘+_SETS+‘ ‘+_WHERE;    db.query(sql,callback);}var del=function(table,where,callback){    var _WHERE=‘‘;    for(var k2 in where){        _WHERE+=k+"=‘"+where[k2]+"‘ AND ";    }     var sql="DELETE  FROM "+prefix+table+‘  ‘+_WHERE;}// var sql_select="SELECT * FROM blog_article";module.exports={    db:db,    insert:insert,    select:select,    find:find,    del:del,    update:update};

node-mysql增删改查封装

标签：console   tab   span   into   llb   rom   string   set   update

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://www.cnblogs.com/gjKai/p/6785300.html