# å¾ä¹¦ç®¡çç³»ç»
# ð项ç®ä»ç»
#### 项ç®ææ¯æ ðð
å¾ä¹¦åå°ç®¡çç³»ç»ï¼éç¨SpringBoot+Mybatiusï¼é¡µé¢ä½¿ç¨Elementæ¡æ¶ï¼ä½¿ç¨RESTful APIé£æ ¼ç¼åæ¥å£ã
æ°æ®åºä½¿ç¨mysql
- Spring Boot
- MyBatis-puls
- MySQL
- ElementUI
#### 项ç®å·¥å
·:
ð¤ð¤
IntelliJ IDEA 2023.2.2+Navicat Premium 16+ElementUI
#### å·²å®ç°åè½
- [x] åºæ¬å¢å æ¹æ¥,è表æ¥è¯¢
- [x] æ¦æªå¨ç»å½éªè¯
-
# ð¹é¡¹ç®é¢è§
è´¦å·:admin å¯ç :123456
#### ç»å½é¡µé¢
#### å¾ä¹¦ç®¡ç
#### 读è
管ç
#### åé
管ç
## âæ°æ®åºè®¾è®¡
#### 读è
表
```sql
DROP TABLE IF EXISTS `tbl_reader`;
CREATE TABLE `tbl_reader` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`reader_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`reader_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`card_id` int(32) NULL DEFAULT NULL,
`education` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`create_date` date NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `reader_id`(`reader_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
```
#### ç¨æ·è¡¨
```sql
DROP TABLE IF EXISTS `tbl_user`;
CREATE TABLE `tbl_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`login_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`user_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`status` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`create_date` date NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
```
#### åé
表
```sql
-- ----------------------------
DROP TABLE IF EXISTS `tbl_borrow`;
CREATE TABLE `tbl_borrow` (
`isbn_log` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`bookname_log` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`readerid_log` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`readername_log` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`cardid_log` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`num` int(15) NOT NULL DEFAULT 1,
`id` int(10) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`) USING BTREE,
INDEX `isbn_log`(`isbn_log`) USING BTREE,
INDEX `readerid_log`(`readerid_log`) USING BTREE,
CONSTRAINT `isbn_log` FOREIGN KEY (`isbn_log`) REFERENCES `tbl_book` (`isbn`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `tbl_borrow_ibfk_1` FOREIGN KEY (`readerid_log`) REFERENCES `tbl_reader` (`reader_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 145 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
```
#### å¾ä¹¦è¡¨
```sql
DROP TABLE IF EXISTS `tbl_book`;
CREATE TABLE `tbl_book` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`isbn` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`book_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`synopsis` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ç®ä»',
`publisher` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`publication_date` date NULL DEFAULT NULL,
`last` int(11) NULL DEFAULT NULL,
`notes` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `isbn`(`isbn`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 64 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
```
#
基于mysql+SpringBoot+Mybatius的图书管理系统 .zip
版权申诉
52 浏览量
2024-01-11
00:29:37
上传
评论
收藏 1.42MB ZIP 举报
基于mysql+SpringBoot+Mybatius的图书管理系统 .zip （40个子文件） 
code_20105 
IKUN_library.sql 22KB IKUN_library.iml 10KB pom.xml 2KB src test java com itheima dao BookDaoTestCase.java 2KB service BookServiceTest.java 2KB main resources config application.yml 601B
前端UI(解压后拖到resources下).rar 1.16MB java com itheima Application.java 304B Interceptor LoginHandlerInterceptor.java 1KB controller BookController.java 3KB IndexController.java 662B utils MessageExceptionAdvice.java 580B ProjectExceptionAdvice.java 574B M.java 520B R.java 518B UserController.java 3KB ReaderController.java 3KB BorrowControler.java 3KB dao BorrowDao.java 651B UserDao.java 591B BookDao.java 347B ReaderDao.java 374B service UserService.java 680B IReaderService.java 756B IBorrwoService.java 660B impl ReaderServiceImpl.java 2KB UserServiceImpl.java 1KB BookServiceImpl.java 2KB BorrowSericeImpl.java 3KB IBookService.java 587B domain Reader.java 290B Book.java 403B Borrow.java 432B User.java 1KB config MPConfig.java 596B MvcConfig.java 2KB img 
1234.png 102KB 12345.png 116KB 123.png 80KB README.md 5KB资源评论
