course-app-backend

基本需求

登录查询某一周的课表、推送当天课程所有课程增删改查根据每天的课表动态手机状态查看所有作业（今天以后的所有作业）、前一天推送作业消息（未标记完成的作业）事件增删查

接口

已实现：

用户info接口 查询（用户学号，用户密码）、修改密码（id、旧密码、新密码）

@PostMapping(value = "/verify",produces = "application/json;charset=utf-8")
@ResponseBody
public String verify(@RequestParam("num") String num,@RequestParam("pwd")String pwd){}

@PutMapping(value = "/updatePwd",produces = "application/json;charset=utf-8")
@ResponseBody
public String updatePwd(Integer userId,String oldPwd,String newPwd){}

课程接口

@GetMapping(value = {"/getCourseOfWeek/{userId}","/getCourseOfWeek/{userId}/{week}"},produces = "application/json;charset=utf-8")
    @ResponseBody
    public String getCourseOfWeek(@PathVariable("userId") Integer userId,@PathVariable(value = "week",required = false) Integer week){}
/*
{
  "code": 200,
  "msg": 18,
  "data": [
    {
      "courseId": 4,
      "userId": 1,
      "termId": 1,
      "courseName": "软件需求分析",
      "startWeek": 1,
      "endWeek": 18,
      "courseTimeId": 1,
      "weekday": 1,
      "classroom": "6D-403",
      "startLesson": "1",
      "endLesson": "2"
    },
    {
      "courseId": 4,
      "userId": 1,
      "termId": 1,
      "courseName": "软件需求分析",
      "startWeek": 1,
      "endWeek": 18,
      "courseTimeId": 2,
      "weekday": 3,
      "classroom": "6D-403",
      "startLesson": "1",
      "endLesson": "2"
    }
  ]
}
*/
 @GetMapping(value = "/getCourseOfNextDay/{userId}",produces = "application/json;charset=utf-8")
    @ResponseBody
    public String getCourseOfNextDay(@PathVariable("userId") Integer userId) {}
/*
{
  "code": 200,
  "data": [
    {
      "courseId": 4,
      "userId": 1,
      "termId": 1,
      "courseName": "软件需求分析",
      "startWeek": 1,
      "endWeek": 18,
      "courseTimeId": 2,
      "weekday": 3,
      "classroom": "6D-403",
      "startLesson": "1",
      "endLesson": "2"
    }
  ]
}
*/

事件接口

    //添加事件{userId:userId，name:name，detail:name，endTime:yyyy-MM-dd，canDelete:1}
    @PostMapping(value = "/item",produces = "application/json;charset=utf-8")
    @ResponseBody
    public String insertItem(Item item) {}
    
    //删除事件
    @DeleteMapping(value = "/item/{itemId}", produces = "application/json;charset=utf-8")
    @ResponseBody
    public String deleteItem(@PathVariable("itemId")Integer itemId){}
    
    //获取最近20件，已完成(isFinished=1)或未完成事件(isFinished=0)
    @GetMapping(value = "/items/{userId}/{isFinished}", produces = "application/json;charset=utf-8")
    @ResponseBody
    public String selectItems(@PathVariable("isFinished")Integer isFinished,@PathVariable("userId")Integer userId){}

    //获取明天截止的未标记完成的事件
    @GetMapping(value = "/expiringItems/{userId}", produces = "application/json;charset=utf-8")
    @ResponseBody
    public String selectDeadlineItems(@PathVariable("userId")Integer userId){}

    //更改事件的完成状态
    @PutMapping(value = "/markFinished/{itemId}/{isFinished}",produces = "application/json;charset=utf-8")
    @ResponseBody
    public String markFinished(@PathVariable("itemId")Integer itemId,@PathVariable("isFinished")Integer isFinished){}

未实现：

用户表接口：添加（用户）、查询（用户id）

数据库：

create table info(
	user_id int primary key auto_increment comment '用户id',
    num varchar(12) comment '学号',
    pwd varchar(12) comment '密码',
    name varchar(12) comment '姓名',
    grade varchar(4) comment '年级',
    classes varchar(12) comment'班级'
) comment '用户表';

create table term(
	term_id int primary key auto_increment comment '学期id',
    years varchar(10) comment '学年',
    up_down int comment '上下学期，0表示上学期，1表示下学期',
    open_time date comment '开学时间',
    cur int default 0 comment'是否是当前学期'
)comment '学期表';

create table course(
	course_id int primary key auto_increment comment '课程id',
    user_id int comment '用户id',
    term_id int comment '学期id',
    course_name varchar(12) comment '课程名',
    start_week int comment '起始周',
    end_week int comment '结束周',
    foreign key (user_id) references info(user_id),
    foreign key (term_id) references term(term_id)
)comment '课程表';

create table course_time(
	course_time_id int primary key auto_increment comment '课程时间id',
    course_id int comment '课程id',
    weekday int comment '星期几上课1-7（星期一开始）',
    classroom varchar(12) comment '课室',
    start_lesson varchar(12) comment '起始节',
    end_lesson varchar(12)  comment '终止节',
    foreign key (course_id) references course(course_id)
)comment '课程时间表';

create table item(
	item_id int primary key auto_increment comment '条目id',
    name varchar(20) comment '条目名',
    detail varchar(50) comment '详情',
    end_time date comment '截止时间',
    can_delete int default 1 comment '是否可删除，默认1表示可以，0表示不行',
    is_finished int default 0 comment '是否完成，1表示已完成，默认0表示未完成',
    user_id int comment '用户id',
    foreign key (user_id) references info(user_id)
)comment '条目表';

caijunqian/course-app-backend

course-app-backend

基本需求

接口

已实现：

未实现：

数据库：