Detailed Design of Library Management System

Detailed Design of Library Management System

1. Project Overview:

1.1 Software Description:

The library management system uses the C/S mode. Ordinary users can log on and manage their own information, borrow books independently, and return books as a practical software.

1.2 Background of the project:

It is used for the library to manage book information and reader information. It mainly consists of the login module, book management module, user management module, and user operation module.

2. Structure of the library management system:

Library Management Module

ReturnSmalldatatime

3. Detailed module design instructions:

Initialization module:

Function Description: at the beginning of the system, the operating system calls it and passes identity verification to access different modules.

Input: Username: string or number of any length; Password: string or number of any length.

Output items: Valid users and invalid users.

Flowchart:

Disable the system module:

Function Description: it is called by the Administrator module or user module and is returned to the operating system after execution.

Administrator module:

Function Description: receives a message loop, starts the query bibliography module, deletes the bibliography module, inserts the bibliography module, modifies the bibliography module, queries the reader module, deletes the reader module, inserts the reader module, and modifies the reader module.

Input: Administrator mouse or keyboard operation.

Output item: Start the corresponding module.

User Module:

Function Description: receives a message loop, starts the bibliography query module, queries the borrowed books module, modifies the reader module, borrow books module, and return books.

Input: User mouse or keyboard operation.

Output item: Start the corresponding module.

Query the bibliography module:

Function Description: query results as required.

Input: Search Condition.

Output item: displays the query result.

Implementation: source = "select * frombookinfo"

Adodc1.RecordSource = source

Flowchart:

Delete the bibliography module:

Function Description: deletes a record.

Input: Search Condition.

Output item: delete information.

Flowchart:

Implementation: varsource = "deletefrombookinfowherebookname = '" & Trim (DeleteBooks. bookname. Text) & "'andbookno ='" & Trim (DeleteBooks. bookno. Text )&"'"

Rsl. Openvarsource

Insert bibliography module:

Function Description: inserts a record.

Input: record information.

Output item: insert information.

Flowchart:

Implementation:

Varsource = "insertintobookinfovalues ('" & Trim (txtBookNo. text) & "','" & Trim (txtBookName. text) & "','" & Trim (txtAuthor. text) & "','" & Trim (txtPublisher. text )&"','"

& Trim (txtLocation. text) & "','" & Trim (txtPrice. text) & "','" & Trim (txtType. text) & "','" & Trim (txtTotal. text) & "','" & Trim (txtDescription. text )&"')"

Rsl. Openvarsource

Modify the bibliography module:

Function Description: completes modification of a record.

Input: Search Condition.

Output item: Modify information.

Flowchart:

Reader query module:

Function Description: query a reader record.

Input: Search Condition.

Output item: displays the reader information.

Implementation: Adodc1.RecordSource = "select * fromusersu, cardscwherec. Name = u. username"

Delete the reader module:

Function Description: deletes a reader record.

Input: Search Condition.

Output item: Delete the reader information.

Implementation:

Varsource = "deletefromcardswherename = '" & Trim (readername) & "'andcardno ='" & Trim (readerno )&"'"

Rsl1.Openvarsource

Varsource = "deletefromuserswhereusername = '" & Trim (readername )&"'"

Rsl2.Openvarsource

Insert reader module:

Function Description: inserts a reader record.

Input: reader information.

Output item: insert to database.

Modify reader module:

Function Description: completes modification of a record.

Input: Search Condition.

Output item: Modify information.

Query borrowed books:

Function Description: query a record.

Input: Search for the reader's borrow information.

Output item: display information.

Borrowing module:

Function Description: complete borrowing.

Input: name of the title.

Output item: Borrow Books.

Flowchart:

Book return module:

Function Description: return the book.

Input: name of the title.

Output item: return the book.

Flowchart:

Display Module:

Function Description: displays information.

Input: Information to be displayed.

Output item: displays information in table format.

Implementation: Adodc1.Refresh

4. Data Structure Design:

User table Card table

Name type name Type

UserNameVarchar (50) CardNoVarchar (50)

UserPwdVarchar (50) NameVarchar (50)

BookInfo table IdCardVarchar (50)

BookNoVarchar (50) CreateDatesmalldatetime

BookNameVarchar (50) TypeIdVarchar (50)

AuthorVarchar (50) StatusVarchar (50)

LocationVarchar (50) BorrowList table

PriceFloatIdVarchar (50)

TypeIdFloatUserNameVarchar (50)

TotalFloatBookNameVarchar (50)

DesVarchar (50) BorrowDataSmalldatatime

ReturnDataSmalldatatime