mssql-mini v1.0.0

简介

mssql-mini 是一个基于 mssql 进行二次封装的一个模块，可以通过简易的方式去操作sql server 数据库

安装方式

npm i mssql-mini

API列表

使用方式

const mssql_mini = require('./index')

// 必须传递数据库的配置
const db = mssql_mini({
    user: 'sa',
    password: '123',
    server: 'localhost',
    port: 1433,
    database: 'resume',
    options: {
        enableArithAbort: true,
        encrypt: true
    },
    pool: {
        max: 1024,
        min: 0
    }
})


db.query(...);
db.select(...);
db.selectAll(...);
db.insert(...);
db.update(...);
db.delete(...)

示例

query

• fn(sql, input?)

let inputParams = { name: 'tom' };
let sql = 'select * from where name = @name';

// async/await
let res1 = await db.query(sql, inputParams);
console.log(res1); // 执行结果 Implementation results

// promise
db.query(sql, inputParams).then(res2 => {
    console.log(res2); // 执行结果 Implementation results
});

select

• fn(tableName, top, where, orderBy, input)

let inputParams = { name: 'tom' };
let where = 'name = @name';

let res = await db.select('Students', 10, where, 'sno desc', inputParams);

selectAll

• fn(tableName, orderBy)

let res = await db.selectAll('Students', 'age desc');

insert

• fn(tableName, data)

let data = {
    name: 'jon',
    age: 18,
    sex: 'male'
}

let res = await db.insert('Students', data);
console.log(res);
// 该函数的返回结果为布尔值true或false
// The function returns a Boolean value of true or false

update

• fn(tableName, newData, where, input)

let newData = {
    age: 48,
    sex: 'female'
}

let where = 'name = @name';

let input = { name: 'jon' };

let res = await db.update('Students', newData, where, input);
console.log(res);
// 该函数的返回结果为布尔值true或false
// The function returns a Boolean value of true or false

delete

• fn(tableName, where)

let where = 'age > @age';

let res = await db.delete('Students', where);
console.log(res);
// 该函数的返回结果为布尔值true或false
// The function returns a Boolean value of true or false

说明

之所以要使用 input 这个参数来进行值的注入，在一定程度上可以确保不被SQL注入攻击；

the reason for using the input parameter for value injection is to ensure, to a certain extent, against SQL injection attacks.