In this library management system, an important connection is used, which is connected with database access. The database contains all the information of the library, including reader information, administrator information, borrowing and returning records. All the data related to management are in it, which is a bridge to ensure that the system can realize various functions normally.

1, database requirements analysis

⒈? Admi table, the administrator table, records the user name and password.

⒉? Admirz table, that is, management log table, records the book number, book title, library card number, borrowing/returning, operation date and payment amount.

⒊? The book list, that is, the book list, records the book number, title, author, publishing house, storage time, whether to borrow it or not, and price.

⒋? The borrowing form, that is, the borrowing form, records the library card number, book number, borrowing date and expiration date.

⒌? The character list, that is, the reader list, records the library card number, name, gender, department and class.

2. Design of database table

⒈Admi table

User names and passwords that allow administrators to enter the system are recorded in the table, as shown in table 1.

Table 1? Administrator information table

4. Admirz table

The borrowing and returning logs of books are recorded in the table, which is used to save all records of book operations for later browsing and searching, as shown in Table 2.

Table 2? Management log table

3. Book table

This table records all the information of all the books in the library, as shown in Table 3-3.

Table three? book list

4. 4. Person table

The relevant information of all readers in the library is recorded in the table, as shown in Table 4.

Table four? Reader list

5. 5. borrowbook table

At this time, the borrowing situation of books is recorded in the table, as shown in Table 5.

Table 5? Borrowing desk