Love school library management system
To help you get started faster, please read all the following patiently, about 1 minute
Summary download address
Based on SSM [love school library management system]
Blogger introduction: 🚀 We media JavaPub is an independent maintainer, a net fan of 15w+, a csdn blogger, a high-quality creator in the Java field, a 51ctoTOP10 blogger, a high-quality author on platforms such as Zhihu / Nuggets / Huawei cloud / Alibaba cloud /InfoQ, and focuses on the Java technology field and sidelines. 🚀
Official account: JavaPub ⭐ ⭐ Resume template, learning materials, interview question bank, etc 💪
🍅 Get the source code at the end of the article 🍅 No routine, free collection
Introduction:
Fools complain, the incompetent sigh, the Confucian weak give up.
With the development of China's economy and the progress of science and technology, the collection and collation of information culture is becoming more and more important. The library has a strong learning atmosphere, a quiet environment, and a large amount of knowledge. Therefore, it has become the first place for people to study and read. At present, the number of Libraries in China is growing faster and faster, and it has been widely distributed in regions. Each major university has more than one library, and the urban areas, counties and other places are also densely distributed, which has played a great positive role in the development of local culture. Due to the increasing number of libraries, the library management system is becoming more and more important. In this paper, the author finds out the problems existing in the library management system and analyzes its development trend according to the investigation of the current situation of the library.
At present, it is an information age. Information resources are becoming more and more important in people's lives. Libraries are also developing digital resources, and even become the key resources of many libraries. However, some libraries ignore the development of physical books in the process of developing digital resources, which is not worth the loss for libraries. On the contrary, some libraries only pay attention to the income of physical books and ignore the development of data resources, which makes the library out of touch with the pace of informatization. For the current library, we should not only pay attention to the collection of physical books, but also take into account the development of digital resources. We should combine the two and not make them develop independently. Physical books are rich in content and data resources are more convenient and fast. They have their own advantages and together constitute the overall resources of the library. At present, many libraries' physical books and digital resources are relatively independent. In order to achieve better development, we must combine the two, promote each other and develop together.
System design:
Library management system developed by springboot, mybatis, bootstrap and mysql (suitable for novices)
The system written when learning springboot has simple technology and clear notes, which is suitable for novices to learn and understand. The whole project uses springboot, mybatis, jsp, and handwritten login filter.
The administrator can add, delete, modify and query the book information, user information and borrowing information. The administrator account can reset the password of the non administrator account
- Library management: when there are new books on the shelves, add book information to the system for students to borrow
- User management: when adding users, their information will also be added to the login table
- Administrator management: same as above
- Account password reset:
- Change Password:
After a user logs in, he / she can obtain the books he / she has selected and the books he / she has borrowed according to the user information
-
Home page: borrow books here. After selection, you will automatically jump to the selected book option
-
Book borrowing: all books are displayed here. Users can select books that have not been borrowed for borrowing
-
My borrowing: displays the book details such as the books that the user has borrowed and the settlement time
-
Change Password:
Function screenshot:
Code implementation:
/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50560 Source Host : localhost:3306 Source Schema : library Target Server Type : MySQL Target Server Version : 50560 File Encoding : 65001 Date: 21/09/2019 21:26:46 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admins -- ---------------------------- DROP TABLE IF EXISTS `admins`; CREATE TABLE `admins` ( `aid` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `stuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`aid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of admins -- ---------------------------- INSERT INTO `admins` VALUES (2, 'Most code', 'zuidaima', '96e79218965eb72c92a549dd5a330112'); INSERT INTO `admins` VALUES (3, 'Wang Wu', 'wangwu', '96e79218965eb72c92a549dd5a330112'); -- ---------------------------- -- Table structure for book -- ---------------------------- DROP TABLE IF EXISTS `book`; CREATE TABLE `book` ( `bid` int(11) NOT NULL AUTO_INCREMENT, `bookname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `publisher` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `publicationdate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `price` int(11) DEFAULT NULL, `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`bid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of book -- ---------------------------- INSERT INTO `book` VALUES (1, 'Break through the sky', 'Brain damaged potato', 'Fantasy', 'starting point', '2012-04-06', 20, '2', 'nothing'); INSERT INTO `book` VALUES (2, 'Military moves the universe', 'Brain damaged potato', 'Fantasy', 'starting point', '2012-04-06', 20, '2', 'nothing'); INSERT INTO `book` VALUES (3, 'Yuanzun', 'Brain damaged potato', 'Fantasy', 'starting point', '2012-04-06', 20, '2', 'nothing'); INSERT INTO `book` VALUES (4, 'Douluo continent', 'Tang San', 'Fantasy', 'starting point', '2012-04-06', 20, '2', 'nothing'); INSERT INTO `book` VALUES (6, 'Peerless Tang clan', 'Tang San', 'Fantasy', 'starting point', '2012-04-06', 20, '2', 'nothing'); INSERT INTO `book` VALUES (7, 'Legend of the Dragon King', 'Tang San', 'Fantasy', 'starting point', '2012-04-06', 20, '1', 'nothing'); INSERT INTO `book` VALUES (9, 'Sacred tomb', 'Chendong', 'Fantasy', 'starting point', '2019-08-14', 23, '1', 'nothing'); INSERT INTO `book` VALUES (10, 'The Lost Tomb', 'Third uncle of Southern Sect', 'Suspense', 'starting point', '2019-08-07', 45, '1', 'nothing'); INSERT INTO `book` VALUES (11, 'Ghost blowing lamp', 'Dominate the world', 'Suspense', 'starting point', '2019-08-07', 45, '1', 'nothing'); -- ---------------------------- -- Table structure for borrow -- ---------------------------- DROP TABLE IF EXISTS `borrow`; CREATE TABLE `borrow` ( `id` int(11) NOT NULL AUTO_INCREMENT, `borrower` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `borrowtime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `bookname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `bid` int(11) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of borrow -- ---------------------------- INSERT INTO `borrow` VALUES (21, 'jack', '2019-08-19', 'Break through the sky', 1); INSERT INTO `borrow` VALUES (22, 'jack', '2019-08-19', 'Military moves the universe', 2); INSERT INTO `borrow` VALUES (23, 'rose', '2019-08-19', 'Yuanzun', 3); INSERT INTO `borrow` VALUES (24, 'rose', '2019-08-19', 'Douluo continent', 4); INSERT INTO `borrow` VALUES (25, 'javaniu', '2019-09-21', 'Peerless Tang clan', 6); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `uid` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `institute` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `profession` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `classname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `stuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`uid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (3, 'rick', 'male', '18090093154', 'College of energy', 'petroleum engineering ', '3 class', '1198495155', '96e79218965eb72c92a549dd5a330112'); INSERT INTO `user` VALUES (4, 'jack', 'male', '18090093154', 'College of energy', 'petroleum engineering ', '3 class', '123', '96e79218965eb72c92a549dd5a330112'); INSERT INTO `user` VALUES (5, 'javaniu', 'female', '18090093154', 'College of energy', 'petroleum engineering ', '3 class', 'javaniu', '96e79218965eb72c92a549dd5a330112'); SET FOREIGN_KEY_CHECKS = 1;
Paper reference:
Source code acquisition:
Everyone likes, collects, follows, comments and views 👇🏻👇🏻👇🏻 Get contact information through wechat official account 👇🏻👇🏻👇🏻
Official account reply: [aixiao library management system]
Punch in article update 1 / 365 days
Recommended subscription of wonderful column: in the column below 👇🏻👇🏻👇🏻👇🏻