1.0.31 • Published 7 years ago

mksql v1.0.31

Weekly downloads
4
License
Apache-2.0
Repository
github
Last release
7 years ago

使用方法

  1. 引入mksql
    var mk=require("mksql");
  1. 连接数据库:
    var config={
        host     : 'localhost',
        port     :  3307,
        user     : 'root',
        password : '',
        database : 'test'
    }
    //建议配置信息从配置文件读取

    var conn=mk.conn(config);
  1. 生成 sql 语句
    var sql=mk.select("tablename","id,name",{id:3});

    var sql=mk.insert("tablename",{name:"lilei",age:20});

    var sql=mk.update("table",data,where);

    var sql=mk.delete("table",where);

    var sql=mk.bind("select * from table where id=:id and name=:name",{id:3,name:"lilei"});
  1. 直接使用conn.query 方法:
    conn.query(sql,function(err,res){
        console.log(err,res);
    })

todo:

  • delete 和 update 的时候,当 where 条件不成立时,考虑报错
1.0.31

7 years ago

1.0.13

7 years ago

1.0.12

7 years ago

1.0.11

7 years ago

1.0.10

7 years ago

1.0.9

7 years ago

1.0.8

7 years ago

1.0.7

7 years ago

1.0.6

7 years ago

1.0.5

7 years ago

1.0.4

7 years ago

1.0.3

7 years ago

1.0.2

7 years ago

1.0.1

7 years ago

1.0.0

7 years ago