https://github.com/eggjs/egg
$ npm i egg-init -g
关于koa:http://www.ruanyifeng.com/blog/2017/08/koa.html?from=groupmessage
创建egg项目: egg-init --type=simple
一直报错啊,我很无奈。决定还是用koa框架来创建好了,也算一次学习了。
fetching npm info of egg-boilerplate-simple
ConnectionTimeoutError: Connect timeout for 5000ms, GET https://registry.npmjs.org/egg-boilerplate-simple/latest -2 (connected: false, keepalive socket: false, socketHandledRequests: 1, socketHandledResponses: 0)
https://koa.bootcss.com/
npm init
npm i koa
创建app.js,写入以下代码
// 导入koa2
const Koa = require('koa');
// 创建一个Koa对象表示web app本身:
const app = new Koa();
// 对于任何请求,app将调用该异步函数处理请求:
app.use(async (ctx, next) => {
await next();
ctx.response.type = 'text/html';
ctx.response.body = '<h1>Hello, koa2!</h1>';
});
// 在端口3000监听:
app.listen(3000);
脚手架:(我用的是这个)
$ npm install -g koa-generator
koa2 test
npm install
npm start
配置数据库:
安装mysql: npm install mysql --save
安装koa:npm install koa koa-body koa-router --save
安装fetch:npm install whatwg-fetch es6-promise --save
新建文件夹config,下新建mysqlDB.js
var mysql = require('mysql');
function __connection(){
var connection = mysql.createConnection({
host : 'localhost',
user : 'DX',
password : '1285480439l',
database : 'react_blog'
});
connection.connect();
return connection;
}
const query = (sql,parmas=null)=>{
var connection=__connection();
return new Promise((resolve,reject)=>{
connection.query(sql,parmas, function (error, results, fields) {
if (error) throw error;
resolve(results);
});
connection.end();
})
}
module.exports = query
使用:
index.js中
const router = require('koa-router')()
const DB = require('../config/mysqlDB');
router.get('/database',async (ctx,next)=>{
const result = await DB('select * from article')
console.log(result)
ctx.body='<h1>result</h1>'
})
显示:成功了。
koa成功连上数据库,✌
查询语句: