Detailed design of library management system

Detailed design of library management system

1 Project Overview:

1.1 Software Description:

The Library Management system uses C/s mode. Ordinary users landing, can carry out their own information management, independent library, book a practical software.

1.2 Project background:

For library management of book information, and reader information. Mainly by landing module, library Management module, user Management module, user Operation module.

2 Structure Chart of Library Management system:

Library Management Module

Returnsmalldatatime

3. Module Detailed Design Description:

Initialize module:

Function Description: When the system is initially invoked by the operating system, it is authenticated and entered into different modules.

Entry: User name: Any length string or number; password: any length string or number.

Output items: Valid users and invalid users.

Flow chart:

Shutdown System module:

Function Description: Called by the Administrator module or user module, and return to the operating system after execution.

Administrator module:

Function Description: Accept message loop, start query Bibliography module, delete bibliography module, insert bibliography module, modify bibliography module, Query reader module, delete reader module, insert reader module, modify reader module.

Entry: Administrator mouse or keyboard operation.

Output item: Starts the corresponding module.

User module:

Function Description: Accept the message loop, start query bibliographic module, query has borrowed library module, modify the reader module, library module, book module.

Input: User mouse or keyboard action.

Output item: Starts the corresponding module.

Query Bibliography module:

Function Description: According to the request, find out the results of the query.

Enter item: Find condition.

Output item: Displays query results.

Implementation: Source= "Select*frombookinfo"

Adodc1.recordsource=source

Flow chart:

To delete a bibliography module:

Function Description: Complete the deletion of a record.

Enter item: Find condition.

Output item: Delete information.

Flow chart:

Implementation: varsource= "Deletefrombookinfowherebookname= '" & Trim (DeleteBooks.bookname.Text) & "' Andbookno= '" & Trim (DeleteBooks.bookno.Text) & "'"

Rsl. Openvarsource

To insert a Bibliography module:

Function Description: Completes inserting a record.

Enter entry: Record information.

Output item: Insert information.

Flow chart:

Realize:

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

To modify a bibliography module:

Function Description: Complete the modification of a record.

Enter item: Find condition.

Output items: modifying information.

Flow chart:

Query Reader module:

Function Description: Complete query a reader record.

Enter item: Find condition.

Output item: Displays reader information.

Implementation: Adodc1.recordsource= "Select*fromusersu,cardscwherec." Name=u.username "

To delete a reader module:

Function Description: Complete the deletion of a reader record.

Enter item: Find condition.

Output item: Deletes reader information.

Realize:

Varsource= "Deletefromcardswherename= '" &trim (readername) & "' andcardno= '" &trim (Readerno) & ""

RSL1. Openvarsource

Varsource= "Deletefromuserswhereusername= '" &trim (readername) & ""

RSL2. Openvarsource

Insert Reader module:

Functional Description: Completes inserting a reader record.

Input items: Reader information.

Output item: INSERT INTO database.

To modify the reader module:

Function Description: Complete the modification of a record.

Enter item: Find condition.

Output items: modifying information.

Query borrowed Library module:

Function Description: Complete the query a record.

Entry: Find the reader's library information.

Output item: Display information.

Library module:

Function Description: Complete the library.

Enter item: Title.

Output items: Borrow books.

Flow chart:

Return module:

Function Description: Complete the return of the book.

Enter item: Title.

Output item: Return book.

Flow chart:

Display module:

Feature Description: Displays information.

Enter item: information to be displayed.

Output item: Tabular form of information display.

Implementation: Adodc1.refresh

4. Data structure Design:

User Table Card Table

Name Type name Type

Usernamevarchar (Cardnovarchar) (50)

Userpwdvarchar (Namevarchar) (50)

BookInfo table Idcardvarchar (50)

Booknovarchar (m) createdatesmalldatetime

Booknamevarchar (Typeidvarchar) (50)

Authorvarchar (Statusvarchar) (50)

Locationvarchar (m) borrowlist table

Pricefloatidvarchar (50)

Typeidfloatusernamevarchar (50)

Totalfloatbooknamevarchar (50)

Desvarchar (m) borrowdatasmalldatatime

Returndatasmalldatatime