$ npm install -g koa-generator

$ koa2 HelloKoa2

$ cd HelloKoa2 
$ npm install

$ npm start

npm install --save sequelize

# 選擇以下之一:
$ npm install --save pg pg-hstore # Postgres
$ npm install --save mysql2
$ npm install --save mariadb
$ npm install --save sqlite3
$ npm install --save tedious # Microsoft SQL Server

module.exports = {
 dbsMysql: 'mysql://root:123456@localhost:3306/new'
 //root是數(shù)據(jù)庫管理員賬號(hào)，‘123546'是密碼 3306是端口號(hào)（MySQL默認(rèn)是3306） school_admin是數(shù)據(jù)庫名稱

}

const Sequelize = require('sequelize');
const mysqlurl = require('./config').dbsMysql
const sequelize = new Sequelize(mysqlurl, {
 // 選擇一種日志記錄參數(shù)
 logging: console.log // 默認(rèn)值,顯示日志函數(shù)調(diào)用的第一個(gè)參數(shù)
});
// //每次啟動(dòng)server刷新數(shù)據(jù)庫
//  (async ()=>{
//   await sequelize.sync({ force: true });
//  })()

module.exports = sequelize

const { Sequelize, DataTypes, Model } = require('sequelize');
const sequelize = require('../mysql');

const new2 = sequelize.define('t_new2', {
  name: {
   type: DataTypes.STRING,
   allowNull: false
  },
 },
 {
  // 這是其他模型參數(shù)
  freezeTableName: true
 });
// 定義的模型是類本身
module.exports= new2

//引入kob得routes模塊
const router = require('koa-router')()
//定義模型為剛剛創(chuàng)建得new2.js
let Model = require("../db/models/new2");
//正常來說啟動(dòng)端口為http://localhost:3000 添加/new2就可以進(jìn)入new2路由
router.prefix('/new1')
// 進(jìn)入new2路由以后可以打印this is a users response!
router.get('/', function (ctx, next) {
 ctx.body = 'this is a users response!'

})
//設(shè)置增加add接口
router.post('/add', async function (ctx, next) {
 console.log(ctx.request.body)
 const new2 = await Model.create(ctx.request.body);
 ctx.body = {
  code:200,
  data:new2
 }
})
//設(shè)置查詢find接口
router.post('/find', async function (ctx, next) {
 const new2 =await Model.findAll({include: []})
 console.log(1111)
 ctx.body = {
  code: 200,
  data: new2
 }
})
//設(shè)置通過id得到所需信息的get接口
router.post('/get', async function (ctx, next) {
 // let users = await User.
 // find({})
 console.log(ctx.request.body)


 let new2 = await Model.findOne({
  // attributes: ['name', 'where']
  where: {
   id: ctx.request.body.id
  }
 });
 ctx.body = {
  code:200,
  data:new2
 }
})
//設(shè)置修改update接口
router.post('/update', async function (ctx, next) {
 console.log(ctx.request.body)
 // let pbj = await Model.update({ _id: ctx.request.body._id }, ctx.request.body);

 let new2 = await Model.update(ctx.request.body, {
  where: {
   id: ctx.request.body.id
  }
 });
 ctx.body = new2
})
//設(shè)置刪除delete接口
router.post('/delete', async function (ctx, next) {
 console.log(ctx.request.body)
 // 刪除所有名為 "Jane" 的人
 await Model.destroy({
  where: { id: ctx.request.body.id }
 });
 ctx.body = 'shibai '
})

// //每次啟動(dòng)server刷新數(shù)據(jù)庫
//  (async ()=>{
//   await sequelize.sync({ force: true });
//  })()
module.exports = router

//引入剛剛創(chuàng)建的new2路由
const new2 =require('./routes/new2')

//使用我們的路由
app.use(new2.routes(),new2.allowedMethods())