如果你已经能写 Python 脚本，却从没把一个带界面的程序从头做到尾；如果你用过 SQL，但只是背过 SELECT、INSERT 的语法，没试过让界面上的按钮真正去改数据库里的行——那这门课补的正好是这段缺口。它的目标不是教你 Python 语法，而是让你亲手拼出一个能跑起来的校园管理软件：学生、课程、成绩这些信息，从窗口里录入，落到数据库里存住，再被查出来、改掉、删掉。
先说清楚：它补的是哪一段能力
很多人学 Python 到函数和类就停了，学数据库到建表就停了，中间那条「把两者接起来」的路一直是断的。断点通常有三个：一是不知道 PyQt5 的窗口、布局、信号槽怎么组织成一个多页面的应用；二是不清楚界面事件怎么触发数据库操作，又怎么把结果回填到表格控件里；三是没处理过真实项目里的琐碎问题——输入校验、删除确认、主键冲突、查询条件拼接。
这门课围绕一个校园管理软件展开，把这些断点放进同一个项目里逐个解决。你会看到窗口是怎么搭的、数据是怎么流的、模块是怎么拆的，而不是零散地学控件用法。
跟着做时会碰到的具体内容
- 界面层：主窗口与子模块的组织方式，表单控件与表格视图的配合，按钮点击后界面如何响应。
- 数据层：用 SQL 建库建表，把学生、课程、成绩这类实体落成表结构，写增删改查语句。
- 连接层：Python 侧如何执行 SQL、如何取回结果集、如何把查询结果塞进界面表格。
- 模块化：成绩模块这类独立功能区怎么单独写代码、单独接入主程序。
- 收尾改动：项目做到后期会有的调整与补充，这部分往往最接近真实开发的样子。
注意这些环节是相互咬合的。你在界面上加一个「录入成绩」的按钮，背后要牵出参数传递、SQL 拼接、异常捕获、界面刷新一整条链。只学其中一环，项目就立不起来。
适合谁，不适合谁
适合的人：写过一些 Python，想找一个体量不大但结构完整的东西练手；做过后端或脚本，想补桌面端界面这一块；正在准备课程设计或转岗作品，需要一个能讲清楚「我做了什么」的项目。
不太适合的人：完全没碰过 Python 的，建议先补基础语法再看；只想学 PyQt5 控件大全的，这里更偏项目整合而不是控件手册；指望学完就能直接商用交付的，课程项目和企业级产品的距离还得自己补。
看完应该能回答的问题
- 一个桌面管理软件，界面代码和数据代码应该按什么边界切开？
- 用户在表格里改了一行，怎么保证数据库里那一行真的跟着变了？
- 查询条件是可选的（比如按姓名或按班级查），SQL 语句该怎么组织才不出错？
- 删除一条被别的表引用的记录时，程序该怎么处理才不崩？
- 新增一个功能模块，需要改动主程序的哪些地方？
如果你现在答不上来其中一半，这门课值得从头跟一遍。跟的时候别只看，把代码敲进去，然后自己改需求——比如加一个字段、加一种查询方式，看能不能独立改通。能做到这一步，这个项目才算真的落到你手里。
构建完整校园管理软件：Python PyQt5 SQL
Python PyQt5 SQL实战项目
编辑点评
从界面设计到数据管理，全面掌握校园软件开发。
⭐ 编辑推荐
本课程通过Python PyQt5和SQL技术，带你构建一个完整的校园管理软件。
课程亮点
• 实战项目驱动
• 界面设计与数据管理并重
• Python PyQt5 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进行数据管理
完成校园管理软件项目
祝您学习愉快！
学有所成，前程似锦！
