var sql = require('mssql');
var dbConfig = {
user: 'sa',
password: 'sa123456789',
server: 'localhost',
database: 'test',
port: 1433,
pool: {
max: 10,
min: 0,
idleTimeoutMillis: 30000
},
options:{
encrypt: false
}
};
//
function getAllUsers() {
var conn = new sql.ConnectionPool(dbConfig);
var req = new sql.Request(conn);
conn.connect(function (err) {
if (err) {
console.log(err);
return;
}
req.query("SELECT * FROM [test].[dbo].[tes]", function (err, recordset) {
console.log(err);
if (err) {
console.log(err);
return;
}
else {
console.log(recordset);
}
conn.close();
});
});
}
getAllUsers();
node连接sql数据库
最新推荐文章于 2024-05-10 09:50:54 发布