Catalog
Division of labor arrangement 4
summary 4
2.1 System introduction 4
2.2 Running environment and its development tools 4
System requirements analysis 5
3.1 Main requirements of the system 5
3.2 System secondary requirements 5
Use case analysis 7
4.1 Administrator's use case analysis 7
4.1.1 Login use case description 7
4.1.2 Exit use case description 7
4.1.3 View the user information description 7
4.1.4 Modify the user information description 7
4.1.5 Create a new user case 7
4.1.6 Delete user use case 7
4.2 User use case analysis 7
4.2.1 Login use case description 7
4.2.2 Exit use case description 7
4.2.3 View the user information description 7
4.2.4 Modify the user information description 7
4.2.5 Create a new user case 7
4.2.6 Activate VIP 7
Class design 17
Behavioral model design 17
Data model design 18
7.1 Entity association design 19
7.2 Top level data flow diagram design 20
7.3 First level data flow diagram design 20
7.4 The data dictionary 22
7.4.1 Account 23
7.4.2 Play data 24
7.4.3 Note data 25
Prototype design 25
System framework design 26
System architecture 27
10.1 Overall system architecture 27
Software implementation and testing 27
11.1 Software operation process 27
11.2 Database establishment 31
Database used 31
Database running environment 31
Database creation and data table design 31
Relational schema design 32
11.3 The realization of video player module of food class 33
11.3.1 Main form layout 33
11.3.2 Sign up and log in 34
11.3.3VIP Activate 37
11.3.4 Video playback module 39
11.3.5 Play data statistics 42
11.4 Food class notes module implementation 47
11.4.1 Window layout 47
11.4.2 Illustration module 47
11.4.3 Note data statistics 49
11.5 Data management 50
11.5.1 Window layout 50
11.5.2 Connect to database 51
11.5.3 Data addition, deletion, modification and query 53
11.6 Personal account management and information modification 57
11.6.1 Window layout 57
11.6.2 Learning records display 57
11.6.3 User information modification 58
summary 60
reference 61
Division of labor arrangement
XXX（50%）： The layout and logic functions of the main window of the player 、 The realization of note taking function 、 Keyword generation displays . Report preparation part ： summary 、 System requirements analysis 、 Class design 、 Behavioral model design 、 Prototype design 、 System framework design 、 Player module implementation 、 The memo module implements 、 summary
XXX（50%）： Database connection 、 Database establishment 、 Data table creation 、 Use case analysis 、 Speech recognition and caption adding module 、 Data model design 、 Data management module 、 Personal account management and information modification module 、 summary 、 reference
summary
1.1 System introduction
Set up a multi-function local video playing system , It is mainly composed of four parts , They are the main window of the video player 、 Rich text notes 、 Display the management interface of account information and statistics , as well as openGauss database .
Users can complete the registration and login operation to access data , And get the activation code , You can get VIP
jurisdiction ; Permissions are also set for administrators , Different objects are distinguished .
After login , Import local video for normal playback , At the same time, you can take notes , Insert screenshots and pictures for recording , And it can record the data of playing video and notes , All data passed JDBC Connect openGauss Database operation .
1.2 Running environment and its development tools
The system is Windows10 Under the operating system , The software development environment is Python3.8, Development tools are PyCharm, The database for openGauss.
