koa2使用

创建项目

初始化生产package.json 文件

npm init -y

安装koa包，

npm install --save koa

安装koa-router中间件

npm install --save koa-router

安装mysqle

npm install --save mysql-pro

在根目录下index.js

const Koa = require('koa');
const router=require('./routes.js')
const app = new Koa();

app
  .use(router.routes())
  .use(router.allowedMethods());
  app.listen(3000,()=>{
      console.log('starting at port 3000');
  });

创建routes.js

const Router = require('koa-router');
const router = new Router();
const client=require('./mysqle.js')
router.get('/', async (ctx, next)=>{
	var tmp = await client.query("select * from article where id = 1;").then(function(result) {
      console.log('1');
      return result;
    }, function(error){
      return -1;
    });
    ctx.body=tmp;
});
router.get('/selt', async (ctx, next)=>{
	var tmp = await client.query("select * from blog_content").then(function(result) {
	console.log('2');
      return result;
    }, function(error){
      return -1;
    });
    ctx.body=tmp;
});
module.exports=router;

创建mysqle.js

const Client = require("mysql-pro");
const client = new Client({  
	mysql:{
		user: 'root',
	    password: 'kingdee',
	    port:'3308',
	    database: 'cyx',
	    host: '127.0.0.1',
	}
})

module.exports=client;