jacklightchen / managebooks

图书管理系统(SpringBoot,thymeleaf) (2018, Archived)

ManageBooks

简介

项目年久失修 仅供参考 ゜▽゜)ノ
一个基于SpringBoot+Thymeleaf渲染的图书管理系统
功能:
用户: a.预约图书 b.查看预约记录 c.还书
管理员: a.添加图书 b.处理预约(借书) c.查看借阅记录
另:
1.当用户过了还书日期仍旧未还书时会发邮件通知
2.当有书被还时发邮件通知预约书的用户到图书馆进行借书

使用技术

后端	...
核心框架	spring、springboot、mybatis
连接池	Alibaba Druid

前端	...
核心框架(轻量简洁)	BootStrap、Thymeleaf

界面入口: localhost:8080
管理员用户名: admin_czc 密码: 123456 (manager表)
普通用户名: czc_reader 密码: 123456 (reader表)

目录结构

.
├── ManageBooks.iml
├── mvnw
├── mvnw.cmd
├── pom.xml
├── readme.md
├── src
│   ├── main
│   │   ├── java
│   │   │   └── cn
│   │   │       └── lightina
│   │   │           └── managebooks
│   │   │               ├── enumeration (异常枚举类)
│   │   │               ├── exception (自定义异常)
│   │   │               ├── ManageBooksApplication.java
│   │   │               ├── config
│   │   │               │   └── WebConfig.java
│   │   │               ├── controller
│   │   │               │   ├── LoginController.java (登陆)
│   │   │               │   ├── ReaderController.java 
│   │   │               │   └── emailController.java (邮件)
│   │   │               ├── dao
│   │   │               │   ├── BookMapper.java
│   │   │               │   ├── MailMapper.java
│   │   │               │   └── UserMapper.java
│   │   │               ├── pojo
│   │   │               │   ├── Book.java
│   │   │               │   ├── BookList.java
│   │   │               │   ├── Borrow.java
│   │   │               │   ├── BorrowDetail.java
│   │   │               │   ├── MailDetail.java
│   │   │               │   ├── ProcessResult.java 
│   │   │               │   ├── Reservation.java
│   │   │               │   ├── ReservationDetail.java
│   │   │               │   ├── ReservationResult.java
│   │   │               │   └── User.java
│   │   │               └── service
│   │   │                   ├── BookService.java (预约和借阅等)
│   │   │                   ├── BookServiceimpl.java
│   │   │                   ├── MailService.java (邮箱)
│   │   │                   ├── MailServiceimpl.java
│   │   │                   ├── UserService.java (登陆)
│   │   │                   └── UserServiceimpl.java
│   │   └── resources
│   │       ├── Mapper
│   │       │   ├── book.xml
│   │       │   ├── mail.xml
│   │       │   └── user.xml
│   │       ├── application.yml
│   │       ├── static
│   │       │   ├── common
│   │       │   │   └── headbar.html (导航栏)
│   │       │   └── lib
│   │       │       ├── css
│   │       │       ├── images
│   │       │       └── js
│   │       └── templates
│   │           ├── admin_addbook.html
│   │           ├── admin_borrow.html
│   │           ├── admin_processreservation.html
│   │           ├── detail_admin.html (管理员导航栏模版)
│   │           ├── detail_user.html (用户导航栏模版)
│   │           ├── login.html (登陆主界面)
│   │           ├── user_booklist.html
│   │           ├── user_borrow.html
│   │           └── user_reservation.html

主界面: 用户界面: 管理员界面:

WARNING

managebooks's Issues

message: "\r\n### Error updating database. Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: call library.new_book(?, ?, ?, ?, ?, ?, ?, ?, ?)\r\n### Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist\n; uncategorized SQLException; SQL state [HY000]; error code [1449]; The user specified as a definer ('root'@'%') does not exist; nested exception is java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist"

message: "\r\n### Error updating database. Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: call library.new_book(?, ?, ?, ?, ?, ?, ?, ?, ?)\r\n### Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist\n; uncategorized SQLException; SQL state [HY000]; error code [1449]; The user specified as a definer ('root'@'%') does not exist; nested exception is java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist"

Awesome project while the picture is so ugly!!

I strongly recommend you that the picture should be replaced with something more graceful!!!

{"status":false,"total":0,"data":null,"message":"\r\n### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.manager' doesn't exist\r\n### The error may exist in file [D:\\Project\\ManageBooks\\target\\classes\\Mapper\\user.xml]\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: select manager_id as user_id, pass_wd, mname as user_name from manager where mname=? and pass_wd=?;\r\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.manager' doesn't exist\n; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.manager' doesn't exist"}

{"status":false,"total":0,"data":null,"message":"\r\n### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.manager' doesn't exist\r\n### The error may exist in file [D:\Project\ManageBooks\target\classes\Mapper\user.xml]\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: select manager_id as user_id, pass_wd, mname as user_name from manager where mname=? and pass_wd=?;\r\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.manager' doesn't exist\n; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.manager' doesn't exist"}

sql呢

数据库脚本，直接导入会报错

数据库脚本看不太懂，里面那么多set 命令什么的，有没有简洁版的啊

数据库服务器挂了

能把数据库的代码也放出来吗？