{
"name": "weixin-node-koa",
"version": "1.0.0",
"description": "node.js with koa2",
"private": true,
"dependencies": {
"koa": "^2.0.0",
"koa-router": "^7.0.0",
"mysql":"2.13.0"
},
"scripts": {
"start": "node app.js"
},
"engines": {
"node": ">=6.0.0"
},
"author": "Fly",
"license": "CENTERM"
}
const Koa = require('koa');
const app = new Koa();
const router2controller = require('./app/router2controller.js');
const config = require('./config/config.local.js');
app.use(router2controller());
app.listen(config.port);
console.log("Server started and listen on port " + config.port);
const Koa = require('koa');
const app = new Koa();
const router2controller = require('./app/router2controller.js');
const config = require('./config/config.local.js');
//start接收到的xml数据请求单独解析存储
const xmlParser = require('koa-xml-body');
app.use(xmlParser()).use((ctx,next) => {
ctx.data = ctx.request.body;
return next();
});
//end
app.use(router2controller());
app.listen(config.port);
console.log("Server started and listen on port " + config.port);
router
.get('/', async (ctx,next) => {
this.body = 'Hello World!';
})
.post('/users', async (ctx,next) => {
//TODO
})
.put('/users/:id', async (ctx,next) => {
//TODO
})
.del('/users/:id', async (ctx,next) => {
//TODO
});
const fs = require('fs');
const router = require('koa-router')();
function addMapping(router, mapping) {
for (var url in mapping) {
if (url.startsWith('GET ')) {
var path = url.substring(4);
router.get(path, mapping[url]);
console.log(`register URL mapping: GET ${path}`);
} else if (url.startsWith('POST ')) {
var path = url.substring(5);
router.post(path, mapping[url]);
console.log(`register URL mapping: POST ${path}`);
} else if (url.startsWith('PUT ')) {
var path = url.substring(4);
router.put(path, mapping[url]);
console.log(`register URL mapping: PUT ${path}`);
} else if (url.startsWith('DELETE ')) {
var path = url.substring(7);
router.del(path, mapping[url]);
console.log(`register URL mapping: DELETE ${path}`);
} else {
console.log(`invalid URL: ${url}`);
}
}
}
function addControllers(router, dir) {
fs.readdirSync(__dirname + '/' + dir).filter((f) => {
return f.endsWith('.js');
}).forEach((f) => {
console.log(`process controller: ${f}...`);
let mapping = require(__dirname + '/' + dir + '/' + f);
addMapping(router, mapping);
});
}
module.exports = function (dir) {
var controllersDir = dir || 'controller';
addControllers(router, controllersDir);
return router.routes();
};
const userService = require('./../service/userService.js');
var getUserinfo = (ctx, next) => {
let query = ctx.query;
let userId = query.id;
let userInfo = userService.getUserById(userId);
let html = '<html><body>'
+ '<div> userinfo: ' + userInfo + '</div>'
+ '</body></html>';
ctx.response.type ='text/html';
ctx.response.body = html;
};
var saveUserinfo = (ctx, next) => {
const requestString = ctx.data;
//TODO数据处理
Console.log(requestString);
};
module.exports = {
'GET /getUserinfo': getUserinfo,
'POST /saveUserinfo': saveUserinfo
};
const userDao = require('./../dao/userDao.js');
var getUserById = async (userId) => {
var users = userDao.getUserById(userId);
var responseContent = '';
for(let user of users) {
reaponseContent += '姓名:' + user.name + ' |';
reaponseContent += '年龄:' + user.age + ' |';
reaponseContent += '身高:' + user.height + '<br />';
}
return responseContent;
}
module.exports = {
getUserById : getUserById
};
const mysql = require('./../utils/mysqlUtil.js');
var getUserById = async (userId) => {
let mysqlOptions = {
sql : 'select * from table_user where user_id = ?',
args : [userId]
};
var users = await mysql.execQuery(mysqlOptions);
if(users.length == 0) {
return null;
} else {
return users;
}
};
module.exports = {
getUserById : getUserById
};
const mysql = require('mysql');
const config = require('./../../config/config.local.js');
var connectionPool = mysql.createPool({
'host' : config.database.host,
'port':config.database.port,
'user' : config.database.user,
'password' : config.database.password,
'database' : config.database.database,
'charset': config.database.charset,
'connectionLimit': config.database.connectionLimit,
'supportBigNumbers': true,
'bigNumberStrings': true
});
var release = connection => {
connection.end(function(error) {
if(error) {
console.log('Connection closed failed.');
} else {
console.log('Connection closed succeeded.');
}
});
};
var execQuery = sqlOptions => {
var results = new Promise((resolve, reject) => {
connectionPool.getConnection((error,connection) => {
if(error) {
console.log("Get connection from mysql pool failed !");
throw error;
}
var sql = sqlOptions['sql'];
var args = sqlOptions['args'];
if(!args) {
var query = connection.query(sql, (error, results) => {
if(error) {
console.log('Execute query error !');
throw error;
}
resolve(results);
});
} else {
var query = connection.query(sql, args, function(error, results) {
if(error) {
console.log('Execute query error !');
throw error;
}
resolve(results);
});
}
connection.release(function(error) {
if(error) {
console.log('Mysql connection close failed !');
throw error;
}
});
});
}).then(function (chunk) {
return chunk;
});
return results;
};
module.exports = {
release : release,
execQuery : execQuery
}
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有