[Qt library management system] 1. Project design and demand analysis

Hits: 0

Article directory

1. Speak up front

  • This set of library management system includes the following functions currently designed

Common user functions: book query, borrowing, returning, borrowing records, personal information modification.

Administrator functions: book borrowing and return review, book management, account management, borrowing records.

The original intention of developing the Qt library management system is to let everyone experience the fun of development with immersive programming. Currently planning to plan two versions v1.0 and v2.0.

  • Notice:
  1. After purchasing this column, I will authorize those who purchase the column to use the source code of this book management system for secondary development.

  2. If illegal transmission is found, I will hold it accountable.

  3. This set of codes can be applied to graduation design, course design, homework, etc., but cannot be of a dissemination nature.

  • What do you get when you buy a column?
  1. Requirements design document for library management system (see column)

  2. System and detailed design documents of the library management system (see column)

  3. Video tutorial (see link below)

  4. Source code (see the last article of the column)

  5. There is no risk of infringement by authorizing the second opening.

2. Video tutorial link

B station video update office

3. Develop the technology stack

v1.0 application technology stack:

  • Qt version: Qt5.15
  • Development language: C++11
  • Database: Sqlite3

Design Functional Technology:

  • Custom Navigation Bar Development
  • QStackWidget, QTableview advanced controls
  • QPushButton、QLabel、QLineEdit、QWidget、QDialog
  • Modal and Modeless Dialogs
  • custom layout technology
  • Custom Signals and Slots
  • Sql’s additions, deletions, and changes
  • Qss beautification interface technology
  • Interface Migration Logic

4. Demand analysis

5. Interface migration logic

6. Database Design

  • book object
database field name type
id Uniquely identifies Primary key auto increment
name book title text
info Book Product Information text
money price integer
total The total number integer
cur current quantity integer
seventh Inventory date text
  • borrowing object
database field name type
id Uniquely identifies Primary key auto increment
bookid the primary key of the tree integer
userid borrower id integer
start time Starting time text
end time End Time text
adminid admin primary key integer
  • User object
database field name type
id Uniquely identifies Primary key auto increment
username book title text
password Book Product Information text
totalget Borrowing quantity integer
info Personal information integer

7. SQL statement design

  • increase

-- write all column names 
insert  into table name (column name 1 , column name 2 , ... column name n) values ​​(value 1 , value 2 , ... value n);
 -- do not write column names (all All columns are added) 
insert  into table name values ​​(value 1 , value 2 ,...value n);
 -- insert some data 
insert  into table name (column name 1 , column name 2 ) values ​​(value 1 , value 2 );

  • delete

-- delete data in the table 
delete  from table name where column name = value;
 -- delete all data in the table 
delete  from table name;

  • check

select * from table name where condition

  • change

-- Modification without conditions (all rows will be modified) 
update table name set column name = value;
 -- modification with condition 
update table name set column name = value where column name = value;

  • create table

Use the sqlite3 tool

8. Rendering design

Let’s design it. The core is mainly the main interface, so a main interface diagram is attached.

Leave a Reply

Your email address will not be published.