const Controller =require('egg').Controller
classClazzextendsController{asyncindex(){let id =this.ctx.request.query.id
//拿到get请求参数let list =awaitthis.app.model.Clazz.findAll({
where:{id:id}})//根据拿到的参数,查询数据库信息this.ctx.body=list
//把查询的数据库的信息返回给请求}//查询数据asynccreate(){let name =this.ctx.request.body.name
awaitthis.app.model.Clazz.create({
name:name//左边是数据库中要添加的,右边是拿到的请求数据})this.ctx.body="添加成功"}//添加数据asyncupdate(){let id =this.ctx.params.id
let name =this.ctx.request.body.name
awaitthis.app.model.Clazz.update({name:name},{
where:{
id:id
}})this.ctx.body="修改成功"}//修改数据asyncdestroy(){let id =this.ctx.params.id
awaitthis.app.model.Clazz.destroy({
where:{id:id}})this.ctx.body="删除成功"}//删除数据}
module.exports = Clazz
const Controller =require('egg').Controller
classStudentextendsController{asyncindex(){let id =this.ctx.request.query.id
let list =awaitthis.app.model.Student.findAll({
where:{id:id}})this.ctx.body=list
}asynccreate(){let name=this.ctx.request.body.name
let achievement=this.ctx.request.body.achievement
let clazz_id =this.ctx.request.body.clazz_id
awaitthis.app.model.Student.create({
name:name,
achievement:achievement,
clazz_id:clazz_id
})this.ctx.body="添加成功"}asyncupdate(){}asyncdestroy(){}}
module.exports = Student
Mysql数据类型与sequelize数据类型对应如下
1.STRING=>varchar(255)2.INTEGER=> int
3.DOUBLE=> double
4.DATA=> datatime
5.TEXT=> text