1 回复
egg中实现可以参考下面代码,nodejs中能用的模块就可以在egg中使用
1、安装mysql的模块
"dependencies": {
"koa": "2.0.0",
"koa-bodyparser": "3.2.0",
"koa-router": "7.0.0",
"mssql": "4.0.4",
"mysql": "2.11.1",
"sequelize": "3.24.1",
"mocha": "3.0.2",
"mz": "2.4.0",
"supertest": "3.0.0",
"ws": "1.1.1"
}
测试 “mssql”: “4.0.4”, 这行,其它是用于其它作用的,不用管
2、添加 msdb.js
var sqlserver = require('mssql');
var msdb = {};
var dbConfig = {
server: "127.0.0.1",
database: "test",
user: "sa",
password: "123456",
port: 1433
};
var db = function(strsql){
sqlserver.connect(dbConfig).then(function () {
var req = new sqlserver.Request().query(strsql).then(function (recordset) {
console.log(recordset);
})
.catch(function (err) {
console.log(err);
});
})
.catch(function (err) {
console.log(err);
});
};
module.exports = db;
3、添加 msdbtest.js
var db = require('./msdb.js');
var sql="select top 10 * from t_city;"
db(sql,function(err,result){
if (err) {
console.log(err);
return;
}
console.log(result);
});