Introducing the library management system based on Java and MySQL-Mysql Tutorial-php.cn

Free learning recommendation: mysql video tutorial

##Java Library Management System

Project Requirements

With the popularity of computers and the improvement of application levels, after investigation and comparison, I decided to use my Java knowledge Develop a small library management system to facilitate the management of books.

The library management system is a typical information management system. This assignment uses the JAVA development tool Eclipse and MySQL database to develop this library management system. The system solves the problems of library management and can meet the basic requirements of library management, including functions such as addition and management. This system can provide readers with borrowing services quickly and conveniently according to the needs of users
The book management system should have the following functions:

Book library management
Reader Information Query

The library management system is mainly aimed at the operational functions of the library, so the system should try its best to meet the needs, and at the same time, it should not have redundant or complicated functions. Confusing the operation and functionality of the system.

Project Address

This project address:

https://github.com/wangyunpengbio/Library/ Free download method: Click That "Clone or download", then click "Download ZIP". If you are interested, you can click Star
If you are a beginner and don't know how to download, just download it on csdn
https:/ /download.csdn.net/download/qq_29300341/9667678

Requirement analysis

A.Business process:

No.Business processRequirements1.Librarian login systemLibrarians need to log in with their account number and password. 2.Add reader informationAdd reader information, such as name, gender, position, etc. 3.Add book informationAdd book information, such as book title, price, category, etc. 4.Reader database managementSelect the reader information in the reader database to update and delete it. 5.Book library managementYou can press "Book Number Query" and "Book Title Fuzzy Query" and then select the book information. Updating and deleting books are divided into in-store and loaned books6Borrowing ManagementEnter the reader number to check the reader's data and borrowing books, review customer data and purchase records. 7.Reader login systemReaders need to log in with their account number and password. 8Borrowing booksFuzzy search by book title, select to borrow books 9Return books Review your own reader information and the books you have borrowed, just click Return. Changes or deletions of reader data are not allowed. Only query, change and deletion functions are allowed by the administrator. Responsible.

#The following is analyzed using the Entity Relationship Model-Entity Relationship.

B. Summarize entities and attributes

##No.1.2.3.4.##5.Book library managementBookidBook nameBook price kind autor publisher6.Lending ManagementBorrowidReader idBook lendDate dueDate overtime7.Reader login systemReaderidReader password8Borrowing booksBorrowidReader idBook lendDate dueDate overtimeReturn the book

Business process	Corresponding entity	Attribute value of the entity
Librarian login system	Librarian	nameUser password
Add reader information	Reader	idReader nameReader kind sex password
Add book information	Book Author Publisher	idBook,nameBook,price,kind, author,publisher Author.name, Author.workplace Publisher.name, Publisher.address
Reader library management	Reader	idReader nameReader kind sex password



			##9
Borrow	idReader idBook lendDate dueDate overtime		C. Entity model D.ER-Entity relationship Author,Publisher To Book&Borrow&Reader To Librarian ##Design In the project folder, (total code: 4800 lines) doc folder stores the generated Document comments, you can click on the index file to view the comments of the entire project There are five packages under the Src package Database is used to store database connection operations Frame is used to store each form interface Model is used to store the data model corresponding to each entity (table) Out_of_date is used to store the interface written initially, which is later discarded and no longer called. SqlTools is used to store the addition, deletion, modification and query methods of operating the database The image folder is used to store related interface pictures and button pictures Note: The entrances to different interfaces of the program have been All are commented out, MainFrame is the only entrance to the program Detailed design of the program: The password echo of the login interface is accompanied by a jump animation (multi-threading is used here, Control thread survival time) The table can be directly selected to modify the data. When updating the data, the original data will be included by default, and books can be searched in different ways; When adding borrowing information, the current time will be automatically added , and calculate the return time. (SQL function NOW()) The interface buttons and background are redesigned with Photoshop, and the graphical user interface is friendly; The database design reaches the third paradigm, removing all non-primary attributes for any candidate Keywords are transitively dependent and have low redundancy. The naming of variables and methods conforms to the specifications and is highly readable Different Model entities (tables) correspond to different SqlTools operations and are stored separately. The program has good reusability and is easy to expand. Use to import the SQL statement. Select utf8 for the character set, otherwise Chinese may not be displayed. The database name is library create database library; It is recommended to use Mysql Front, the MySQL front desk, which supports the execution of multiple SQL statements at the same time. You can download it from the first link on Baidu. http://dlsw.baidu.com/sw-search-sp/soft/6c/17997/MySQL-Front_V5.3.4.214_Setup.1435658094.exe Add the database driver to the Java environment, The DatabaseTools.java `file in the` database `package in the source program is related to` database connection operations, The user name and password of the source program are both root, and the database name For: library This code needs to be slightly modified to run on different computers. Login: Librarian: username root password root or wangyp password 123456 Reader: username 001 password root (Note: The initial value of the password for readers in the database is root) When using Eclipse on different computers, you may need to re-establish the path to the Java class library This program is written with 1.8 jdk, so the final It’s easy to use jre 1.8. If the code is run under 1.8, no warning will appear. The display effect of 1.7 and 1.6 is not good. Both awt and swing depend on the specific implementation of the virtual machine. So different platforms perform differently. The interface can only be transplanted if javafx is used. Moreover, the laptop used for writing has a high-resolution screen, and the display size is just right on this machine. However, the interface may be too large on other computers. Specific document comments have been generated. Open the index file in the doc folder to view the comments of the entire project Related free learning Recommended: mysql database(video), java basic tutorial

The above is the detailed content of Introducing the library management system based on Java and MySQL. For more information, please follow other related articles on the PHP Chinese website!