构建完整的学校管理软件Python PyQt5 SQL

Python PyQt5 SQL全栈实践

编辑点评

项目驱动,实战性强,适合初学者快速掌握学校管理软件开发。

⭐ 编辑推荐

本课程通过Python PyQt5和SQL技术,带你构建学校管理软件,从界面设计到功能实现,全方位学习。

课程亮点

• Python PyQt5 GUI开发
• SQL数据库应用
• 项目实战教学

课程目录

📁 21. Extra Changes in this project
    21. Extra Changes in this project必看.png  [493.5 KB]
    1. Extra changes_CN.srt  [11.0 KB]
    1. Extra changes.srt  [11.0 KB]
    1. Extra changes.mp4  [201.8 MB]
📁 17. Mark module python code
    17. Mark module python code说明.png  [493.5 KB]
    2. Edit marks.srt  [12.2 KB]
    1. Add marks.mp4  [194.3 MB]
    3. Delete marks_CN.srt  [6.4 KB]
    2. Edit marks_CN.srt  [12.1 KB]
    2. Edit marks.mp4  [215.6 MB]
    3. Delete marks.srt  [6.4 KB]
    1. Add marks.srt  [12.4 KB]
    1. Add marks_CN.srt  [12.4 KB]
    3. Delete marks.mp4  [85.4 MB]
📁 22. Export reports from QTableWidget to Excel File
    22. Export reports from QTableWidget to Excel File文档.zip  [1.8 MB]
    3. The modified Gui for export to excel.html  [198.5 KB]
    1. Export to Excel from Pyqt5 tables.mp4  [202.2 MB]
    2. Download the modified python code.html  [56.1 KB]
    1. Export to Excel from Pyqt5 tables_CN.srt  [16.4 KB]
    1. Export to Excel from Pyqt5 tables.srt  [16.5 KB]
📁 8. User interface creation  Attendance management module
    8. User interface creation  Attendance management module必看.png  [493.5 KB]
    2. Edit or delete attendance details.mp4  [35.2 MB]
    2. Edit or delete attendance details_CN.srt  [2.4 KB]
    2. Edit or delete attendance details.srt  [2.4 KB]
    1. Add attendance Details.mp4  [51.6 MB]
    1. Add attendance Details.srt  [3.0 KB]
    1. Add attendance Details_CN.srt  [3.1 KB]
📁 16. Student module python code
    16. Student module python code说明.png  [493.5 KB]
    2. Add student 2.srt  [11.0 KB]
    5. Delete student.mp4  [107.7 MB]
    3. edit student 1.srt  [11.7 KB]
    2. Add student 2.mp4  [171.9 MB]
    4. Edit student part 2_CN.srt  [7.1 KB]
    1. Add student part 1_CN.srt  [9.2 KB]
    5. Delete student_CN.srt  [7.7 KB]
    3. edit student 1.mp4  [187.1 MB]
    3. edit student 1_CN.srt  [11.9 KB]
    1. Add student part 1.mp4  [109.6 MB]
    1. Add student part 1.srt  [9.4 KB]
    5. Delete student.srt  [7.6 KB]
    4. Edit student part 2.srt  [7.1 KB]
    4. Edit student part 2.mp4  [117.4 MB]
    2. Add student 2_CN.srt  [11.0 KB]
📁 5. Interface Design - Login form and home page design
    5. Interface Design - Login form and home page design资料.png  [493.5 KB]
    1. Login form creation.srt  [6.0 KB]
    2. Home page creation_CN.srt  [1.5 KB]
    2. Home page creation.srt  [1.5 KB]
    2. Home page creation.mp4  [20.3 MB]
    1. Login form creation.mp4  [109.3 MB]
    1. Login form creation_CN.srt  [6.1 KB]
📁 20. Reports Generation
    20. Reports Generation必看.zip  [1.8 MB]
    2. Report Design Style Generation.mp4  [148.3 MB]
    1. Reports Generation.mp4  [132.0 MB]
    2. Report Design Style Generation_CN.srt  [7.4 KB]
    1. Reports Generation_CN.srt  [6.7 KB]
    1. Reports Generation.srt  [6.5 KB]
    2. Report Design Style Generation.srt  [7.2 KB]
📁 11. User interface creation  Receipt generation module
    11. User interface creation  Receipt generation module必看.zip  [1.8 MB]
    1. Receipt generation.mp4  [99.8 MB]
    1. Receipt generation_CN.srt  [4.6 KB]
    1. Receipt generation.srt  [4.7 KB]
📁 13. Complete project code for python
    13. Complete project code for python文档.zip  [1.8 MB]
    1. Copy the complete python code - copy the complete code and save as school.py.html  [31.2 KB]
📁 6. User interface creation  Student details module
    6. User interface creation  Student details module资料.zip  [1.8 MB]
    2. Edit or Delete student interface design_CN.srt  [4.2 KB]
    1. Add new student interface design.srt  [7.0 KB]
    1. Add new student interface design_CN.srt  [7.1 KB]
    1. Add new student interface design.mp4  [112.0 MB]
    2. Edit or Delete student interface design.mp4  [86.1 MB]
    2. Edit or Delete student interface design.srt  [4.1 KB]
📁 2. Software installation
    2. Software installation文档.zip  [1.8 MB]
    1. How to install Python_CN.srt  [1.6 KB]
    4. How to install text editor for our project.srt  [1.4 KB]
    4. How to install text editor for our project.mp4  [15.0 MB]
    3. How to install xampp and mysql.mp4  [19.1 MB]
    3. How to install xampp and mysql.srt  [1.6 KB]
    1. How to install Python.srt  [1.6 KB]
    3. How to install xampp and mysql_CN.srt  [1.7 KB]
    2. How to install PyQt5 and PyQt5 tools.mp4  [26.4 MB]
    1. How to install Python.mp4  [16.1 MB]
    2. How to install PyQt5 and PyQt5 tools.srt  [1.6 KB]
    2. How to install PyQt5 and PyQt5 tools_CN.srt  [1.8 KB]
    4. How to install text editor for our project_CN.srt  [1.5 KB]
📁 18. Attendance module python code
    1. Add attendance.srt  [10.5 KB]
    3. Delete Attendance.mp4  [47.9 MB]
    2. Edit attendance.srt  [13.6 KB]
    3. Delete Attendance_CN.srt  [2.8 KB]
    2. Edit attendance.mp4  [208.5 MB]
    1. Add attendance.mp4  [182.2 MB]
    2. Edit attendance_CN.srt  [13.4 KB]
    1. Add attendance_CN.srt  [10.5 KB]
    3. Delete Attendance.srt  [2.8 KB]
📁 19. Fees module python code
    4. Delete Fees_CN.srt  [4.6 KB]
    3. Edit fees_CN.srt  [11.8 KB]
    1. Addd Fees_CN.srt  [11.8 KB]
    3. Edit fees.mp4  [253.6 MB]
    2. Fees Receipt Generation.srt  [10.4 KB]
    2. Fees Receipt Generation_CN.srt  [10.5 KB]
    2. Fees Receipt Generation.mp4  [180.8 MB]
    1. Addd Fees.srt  [11.7 KB]
    4. Delete Fees.mp4  [74.4 MB]
    3. Edit fees.srt  [11.8 KB]
    4. Delete Fees.srt  [4.6 KB]
    1. Addd Fees.mp4  [227.4 MB]
📁 4. New project and menu creation using Qt Designer
    1. How to create new project and menu.mp4  [46.8 MB]
    1. How to create new project and menu.srt  [2.9 KB]
    2. How to set menu colors and object names in the menu.mp4  [45.8 MB]
    2. How to set menu colors and object names in the menu.srt  [3.3 KB]
    2. How to set menu colors and object names in the menu_CN.srt  [3.2 KB]
    1. How to create new project and menu_CN.srt  [3.1 KB]
📁 1. Introduction
    1. The complete output of the Python PyQt5 & MySql project we are goint go develop_CN.srt  [4.7 KB]
    1. The complete output of the Python PyQt5 & MySql project we are goint go develop.mp4  [28.8 MB]
    1. The complete output of the Python PyQt5 & MySql project we are goint go develop.srt  [5.0 KB]
📁 12. Database and table creation in mysql database and Php my admin
    1. How to create school database in mysql using phpmyadmin control panel_CN.srt  [2.2 KB]
    2. How to create student, mark, attendance and fees tables in school database_CN.srt  [5.7 KB]
    2. How to create student, mark, attendance and fees tables in school database.srt  [5.5 KB]
    1. How to create school database in mysql using phpmyadmin control panel.srt  [2.2 KB]
    2. How to create student, mark, attendance and fees tables in school database.mp4  [86.6 MB]
    1. How to create school database in mysql using phpmyadmin control panel.mp4  [18.5 MB]
📁 15. Python code to login form
    1. Login form.srt  [8.2 KB]
    1. Login form.mp4  [96.1 MB]
    1. Login form_CN.srt  [8.3 KB]
📁 14. Python code  How to connect Pyqt5 User interface with Python
    1. Connect ui to python code.mp4  [40.0 MB]
    1. Connect ui to python code_CN.srt  [4.9 KB]
    1. Connect ui to python code.srt  [4.9 KB]
📁 7. User interface creation  Mark management module
    2. Edit or delete mark details design.mp4  [29.4 MB]
    1. Add mark details.mp4  [51.6 MB]
    2. Edit or delete mark details design_CN.srt  [1.7 KB]
    1. Add mark details.srt  [2.9 KB]
    1. Add mark details_CN.srt  [3.0 KB]
    2. Edit or delete mark details design.srt  [1.7 KB]
📁 10. User interface creation  Reports generation module
    1. Report generation.mp4  [22.0 MB]
    1. Report generation_CN.srt  [1.8 KB]
    1. Report generation.srt  [1.8 KB]
📁 9. User interface creation  Fees management module
    2. Edit or delette fees form_CN.srt  [1.4 KB]
    2. Edit or delette fees form.srt  [1.3 KB]
    1. Add fees details form_CN.srt  [2.7 KB]
    2. Edit or delette fees form.mp4  [25.2 MB]
    1. Add fees details form.mp4  [44.1 MB]
    1. Add fees details form.srt  [2.7 KB]
📁 3. Download images for ui design
    2. Complete ui file code - copy the contents of the code and save as school.ui.html  [184.1 KB]
    1. Right click on each image - select - save image as -  and save it.html  [423.0 B]
fileTree【】.txt  [7.2 KB]

适合人群

  • Python初学者
  • 学校管理软件开发者

学习收获

掌握Python PyQt5界面设计
学会SQL数据库操作
完成学校管理软件开发

祝您学习愉快!

学有所成,前程似锦!

课程目录

fileProcess.log
fileTree.txt
ReNameTree.bat
1. Introduction
1. The complete output of the Python PyQt5 & MySql project we are goint go develop.mp4
1. The complete output of the Python PyQt5 & MySql project we are goint go develop.srt
1. The complete output of the Python PyQt5 & MySql project we are goint go develop_CN.srt
10. User interface creation  Reports generation module
1. Report generation.mp4
1. Report generation.srt
1. Report generation_CN.srt
11. User interface creation  Receipt generation module
1. Receipt generation.mp4
1. Receipt generation.srt
1. Receipt generation_CN.srt
12. Database and table creation in mysql database and Php my admin
1. How to create school database in mysql using phpmyadmin control panel.mp4
1. How to create school database in mysql using phpmyadmin control panel.srt
1. How to create school database in mysql using phpmyadmin control panel_CN.srt
2. How to create student, mark, attendance and fees tables in school database.mp4
2. How to create student, mark, attendance and fees tables in school database.srt
2. How to create student, mark, attendance and fees tables in school database_CN.srt
13. Complete project code for python
1. Copy the complete python code - copy the complete code and save as school.py.html
14. Python code  How to connect Pyqt5 User interface with Python
1. Connect ui to python code.mp4
1. Connect ui to python code.srt
1. Connect ui to python code_CN.srt
15. Python code to login form
1. Login form.mp4
1. Login form.srt
1. Login form_CN.srt
16. Student module python code
1. Add student part 1.mp4
1. Add student part 1.srt
1. Add student part 1_CN.srt
2. Add student 2.mp4
2. Add student 2.srt
2. Add student 2_CN.srt
3. edit student 1.mp4
3. edit student 1.srt
3. edit student 1_CN.srt
4. Edit student part 2.mp4
4. Edit student part 2.srt
4. Edit student part 2_CN.srt
5. Delete student.mp4
5. Delete student.srt
5. Delete student_CN.srt
17. Mark module python code
1. Add marks.mp4
1. Add marks.srt
1. Add marks_CN.srt
2. Edit marks.mp4
2. Edit marks.srt
2. Edit marks_CN.srt
3. Delete marks.mp4
3. Delete marks.srt
3. Delete marks_CN.srt
18. Attendance module python code
1. Add attendance.mp4
1. Add attendance.srt
1. Add attendance_CN.srt
2. Edit attendance.mp4
2. Edit attendance.srt
2. Edit attendance_CN.srt
3. Delete Attendance.mp4
3. Delete Attendance.srt
3. Delete Attendance_CN.srt
19. Fees module python code
1. Addd Fees.mp4
1. Addd Fees.srt
1. Addd Fees_CN.srt
2. Fees Receipt Generation.mp4
2. Fees Receipt Generation.srt
2. Fees Receipt Generation_CN.srt
3. Edit fees.mp4
3. Edit fees.srt
3. Edit fees_CN.srt
4. Delete Fees.mp4
4. Delete Fees.srt
4. Delete Fees_CN.srt
2. Software installation
1. How to install Python.mp4
1. How to install Python.srt
1. How to install Python_CN.srt
2. How to install PyQt5 and PyQt5 tools.mp4
2. How to install PyQt5 and PyQt5 tools.srt
2. How to install PyQt5 and PyQt5 tools_CN.srt
3. How to install xampp and mysql.mp4
3. How to install xampp and mysql.srt
3. How to install xampp and mysql_CN.srt
4. How to install text editor for our project.mp4
4. How to install text editor for our project.srt
4. How to install text editor for our project_CN.srt
20. Reports Generation
1. Reports Generation.mp4
1. Reports Generation.srt
1. Reports Generation_CN.srt
2. Report Design Style Generation.mp4
2. Report Design Style Generation.srt
2. Report Design Style Generation_CN.srt
21. Extra Changes in this project
1. Extra changes.mp4
1. Extra changes.srt
1. Extra changes_CN.srt
22. Export reports from QTableWidget to Excel File
1. Export to Excel from Pyqt5 tables.mp4
1. Export to Excel from Pyqt5 tables.srt
1. Export to Excel from Pyqt5 tables_CN.srt
2. Download the modified python code.html
3. The modified Gui for export to excel.html
3. Download images for ui design
1. Right click on each image - select - save image as -  and save it.html
2. Complete ui file code - copy the contents of the code and save as school.ui.html
4. New project and menu creation using Qt Designer
1. How to create new project and menu.mp4
1. How to create new project and menu.srt
1. How to create new project and menu_CN.srt
2. How to set menu colors and object names in the menu.mp4
2. How to set menu colors and object names in the menu.srt
2. How to set menu colors and object names in the menu_CN.srt
5. Interface Design - Login form and home page design
1. Login form creation.mp4
1. Login form creation.srt
1. Login form creation_CN.srt
2. Home page creation.mp4
2. Home page creation.srt
2. Home page creation_CN.srt
6. User interface creation  Student details module
1. Add new student interface design.mp4
1. Add new student interface design.srt
1. Add new student interface design_CN.srt
2. Edit or Delete student interface design.mp4
2. Edit or Delete student interface design.srt
2. Edit or Delete student interface design_CN.srt
7. User interface creation  Mark management module
1. Add mark details.mp4
1. Add mark details.srt
1. Add mark details_CN.srt
2. Edit or delete mark details design.mp4
2. Edit or delete mark details design.srt
2. Edit or delete mark details design_CN.srt
8. User interface creation  Attendance management module
1. Add attendance Details.mp4
1. Add attendance Details.srt
1. Add attendance Details_CN.srt
2. Edit or delete attendance details.mp4
2. Edit or delete attendance details.srt
2. Edit or delete attendance details_CN.srt
9. User interface creation  Fees management module
1. Add fees details form.mp4
1. Add fees details form.srt
1. Add fees details form_CN.srt
2. Edit or delette fees form.mp4
2. Edit or delette fees form.srt
2. Edit or delette fees form_CN.srt