图书管理系统(SpringBoot+SpringMVC+Mybatis)
基于SpringBoot+SpringMVC+Mybatis的图书管理系统
·
目录
项目业务
主要业务:管理学校图书信息,记录并管理学生借阅图书信息
开发环境与技术栈
开发环境:MySQL、Maven、Linux(云服务器部署)、IDEA、Git
技术栈:SpringBoot、SpringMVC、Mybatis
项目功能
用户注册、用户登录、会话管理 、学生信息管理、图书信息管理、图书借阅信息管理
项目演示
用户登录
用户管理
新增用户
修改用户
删除用户
学生信息管理和图书信息管理类似于用户管理
图书借阅信息管理
借阅信息查询
新增借阅信息
修改借阅信息
删除借阅信息
数据库设计
数据表关系图
创建数据库及表
前后端接口
查询专业字典
请求
GET dict/tag/query?dictionaryKey=000002
响应
{ "success" : true, "code" : "200", "message" : "操作成功", "data" : [ { "dictionaryTagKey" : "000002001", "dictionaryTagValue" : "中文系" }, { "dictionaryTagKey" : "000002002", "dictionaryTagValue" : "英语系" }, { "dictionaryTagKey" : "000002003", "dictionaryTagValue" : "计算机科学与技术" } ] }
查询毕业年份字典
请求
GET dict/tag/query?dictionaryKey=000001
响应
{ "success" : true, "code" : "200", "message" : "操作成功", "data" : [ { "dictionaryTagKey" : "000001001", "dictionaryTagValue" : "2022届" }, { "dictionaryTagKey" : "000001002", "dictionaryTagValue" : "2023届" }, { "dictionaryTagKey" : "000001003", "dictionaryTagValue" : "2024届" }, { "dictionaryTagKey" : "000001004", "dictionaryTagValue" : "2025届" } ] }
查询图书借阅信息
请求
GET borrowRecord/query?searchText=&sortOrder=asc&pageSize=7&pageNumber=1
响应
{ "success" : true, "code" : "200", "message" : "操作成功", "total" : 9, "data" : [ { "id" : 1, "startTime" : "2020-01-01 14:20:00", "endTime" : "2020-02-01 14:20:00", "createTime" : "2020-06-17 15:52:33", "book" : { "id" : 1, "bookName" : "高等数学", "author" : "王某", "price" : 45.20 }, "classes" : { "id" : 1, "classesName" : "大学1班", "classesGraduateYear" : "000001001", "classesMajor" : "000002002", "classesDesc" : "团结" }, "student" : { "id" : 1, "studentName" : "爱学习的", "studentNo" : "s00001", "idCard" : "222222222222222222", "studentEmail" : "123@qq.com" } }, { "id" : 7, "startTime" : "2022-02-01 14:20:00", "endTime" : "2022-02-21 14:20:00", "createTime" : "2022-06-17 15:52:33", "book" : { "id" : 3, "bookName" : "大学英语", "author" : "李某", "price" : 33.00 }, "classes" : { "id" : 1, "classesName" : "大学1班", "classesGraduateYear" : "000001001", "classesMajor" : "000002002", "classesDesc" : "和睦" }, "student" : { "id" : 3, "studentName" : "爱学习的", "studentNo" : "s00003", "idCard" : "222222222222222224", "studentEmail" : "123@qq.com" } } ] }
查询班级(数据字典)
使用在下拉菜单中,要求按照数据字典响应格式返回请求GET http://localhost:8080/classes/queryAsDict
响应
{ "success" : true, "code" : "200", "message" : "操作成功", "data" : [ { "dictionaryTagKey" : "1", "dictionaryTagValue" : "大学1班", "classesGraduateYear" : "000001001", "classesMajor" : "000002003" }, { "dictionaryTagKey" : "2", "dictionaryTagValue" : "大学2班", "classesGraduateYear" : "000001002", "classesMajor" : "000002003" }, { "dictionaryTagKey" : "3", "dictionaryTagValue" : "大学3班", "classesGraduateYear" : "000001003", "classesMajor" : "000002003" } ] }
查询图书(数据字典)
使用在下拉菜单中,要求按照数据字典响应格式返回请求GET book/queryAsDict
响应
{ "success" : true, "code" : "200", "message" : "操作成功", "data" : [ { "dictionaryTagKey" : "1", "dictionaryTagValue" : "高等数学", "author" : "王某", "price" : 45.20 }, { "dictionaryTagKey" : "2", "dictionaryTagValue" : "数据结构", "author" : "李某", "price" : 61.50 }, { "dictionaryTagKey" : "3", "dictionaryTagValue" : "大学英语", "author" : "张某", "price" : 33.00 }, { "dictionaryTagKey" : "4", "dictionaryTagValue" : "大学物理", "author" : "吴某", "price" : 33.00 } ] }
查询学生(数据字典)
下拉菜单:选择班级下拉选项之后,根据选择的班级 id 查询所有学生。要求按照数据字典响应格式返回请求GET student/queryAsDict?dictionaryKey=2
响应
{ "success" : true, "code" : "200", "message" : "操作成功", "data" : [ { "dictionaryTagKey" : "6", "dictionaryTagValue" : "爱学习的", "studentNo" : "s00006", "idCard" : "222222222222222227" }, { "dictionaryTagKey" : "7", "dictionaryTagValue" : "爱学习的", "studentNo" : "s00007", "idCard" : "222222222222222228" } ] }
新增图书借阅信息
请求
POST borrowRecord/add Content-Type: application/json {"studentId":"7","bookId":"3","startTime":"2022-06-10 19:40:56","endTime":""}
响应
{ "success" : true, "code" : "200", "message" : "操作成功" }
删除图书借阅信息
请求GET borrowRecord/delete?ids=2&ids=3
响应{ "success" : true, "code" : "200", "message" : "操作成功" }
查询图书借阅详情
请求GET borrowRecord/queryById?id=1
响应{ "success" : true, "code" : "200", "message" : "操作成功", "data" : { "id" : 1, "startTime" : "2022-01-01 14:20:00", "endTime" : "2022-02-01 14:20:00", "createTime" : "2022-06-17 15:52:33", "book" : { "id" : 1, "bookName" : "高等数学", "author" : "王某", "price" : 45.20 }, "classes" : { "id" : 1, "classesName" : "大学1班", "classesGraduateYear" : "000001001", "classesMajor" : "000002002", "classesDesc" : "团结" }, "student" : { "id" : 1, "studentName" : "爱学习的", "studentNo" : "s00001", "idCard" : "222222222222222222", "studentEmail" : "123@qq.com" } } }
修改图书借阅信息
请求
POST borrowRecord/update Content-Type: application/json {"id":"10","studentId":"3","bookId":"4","startTime":"2020-06-11 19:24:46","endTime":"2020-06-18 19:54:49"}
响应{ "success" : true, "code" : "200", "message" : "操作成功" }
更多推荐
已为社区贡献1条内容
所有评论(0)