|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/python-pyqt/
课程评论：没有评论
课程名称：使用Python、PyQt5和SQL构建完整的学校管理软件 课程概述：亲爱的学生，欢迎参加“使用Python、PyQt5和Qt Designer构建学校管理系统”课程。本课程旨在帮助学生深入理解PYTHON PYQT5的实时项目开发。完成该课程后，学生将能够独立开发出一套完整的Python软件，涵盖GUI开发、数据库设计、表格设计以及后端编码等全部要求。 在本课程中，您将学习如何使用PyQt开发完整的学校管理系统项目。课程重点包括使用Qt Designer创建表单设计，并将用户界面与Python文件整合。您将掌握创建登录表单、学生详细信息表单、考勤表单、成绩表单和费用表单的技巧。 具体内容包括： - 使用Qt Designer创建标签、图像、文本框、多行文本框、下拉框、消息框、按钮、选项卡小部件、菜单栏和表格小部件。 - 创建MySQL数据库、表格，并通过Python代码实现数据插入、更新、删除和选择。 - 登录模块：使用Qt Designer创建登录框，验证用户名和密码以开启主界面，并在信息错误时显示错误消息。 - 学生模块：录入学生注册号、出生日期、年龄、班级、地址、电话号码和电子邮件，所有信息存储在数据库中，供后续编辑或删除。 - 成绩模块：录入各科目的成绩，保存数据后可进行编辑或删除。 - 考勤模块：录入考勤信息，包括考勤日期和状态，保存后同样可以编辑或删除。 - 费用模块：录入费用详情，系统支持查看、编辑和删除记录，并能够自动生成收据。 此外，系统能生成学生报告、成绩报告、考勤报告和费用报告，并支持将报告导出为Excel文件，使用pandas库实现。 通过本课程的学习，学生将能够在职业生涯中迈出重要的一步，全面掌握Python GUI编程及数据库操作。这将为未来的发展打下坚实的基础。
Dear Student,Welcome to Build School Management System Python, PyQt5 & Qt Designer CourseI welcome you all to the course to get a good knowledge about PYTHON PYQT5 real time project development.Students can complete a wonderful complete python software with all requirements from GUI Development, Database design, Table design, back end coding with python. Students, I am sure this course will be a biggest milestone in your career if you complete this course filly without skipping any lesson.Do you want to get in depth knowledge in Python GUI programming using Pyqt. This course teaches how to develop a complete school management system project using python pyqt. This project teaches how to create form designs using Qt Designer and how to integrate the user interface with python file.This course teaches how to create a login form, student details form, attendance details form, mark details form, fees details form using Qt Designer.How to create Labels, Images, Text fields (Line Edit), Multi line text fields (Text Edit), Combo boxes, Message boxes, Buttons, Tab widgets, Menu bars, Table widgets are explained using Qt DesignerHow to create Mysql database, how to create tables in the database, how to insert data, update data, delete data and select data from user interface to mysql database through python code are explained in this course.The students will learn how to develop the following modules using Qt Designer and write python code to connect with user interface and with mysql database.Login moduleHow to create a login using Qt Designer and how to write python code to connect with user interface, the administrator will enter the username and password, if the username and password are correct, it will open the main form. If the details are not correct, it will show error message.This login form displays the message using message box. This form uses lineEdit, QPushButton, QLabel controls from Qt Designer.Student ModuleIn the student module, all student details like registration number, date of birth, age, section, address, phone number and email are entered in the form. All the entered details are stored in the database. After save the administrator can perform edit or delete, if the administrator want to edit the entered details or delete the details.Mark detailsIn the mark module, all mark details like registration number, exam name, language mark, English mark, maths mark, science mark and social science marks are entered in the form. All the entered details are stored in the database. After save the administrator can perform edit or delete, if the administrator wants to edit the entered mark details or delete the mark detailsAttendance detailsIn the attendance module, all attendance details like registration number, attendance date, morning attendance status, evening attendance status are entered in the form. All the entered details are stored in the database. After save the administrator can perform edit or delete, if the administrator wants to edit the entered attendance details or delete the attendance detailsAttendance detailsIn the fees module, all fees details like receipt number, registration number, fees amount, fees date, reason for fees are entered in the form. All the entered details are stored in the database. After save the administrator can perform edit or delete, if the administrator wants to edit the entered fees details or delete the fees detailsReceiptThe administrator can take print out of the receipt after entering the receipt details and edit fees details. The receipt are generated automatically when add fees or edit fees form is executed.ReportsThe system generates the student reports, mark reports, attendance reports and fees reports for the administrator.Export to ExcelThe administrator can view the reports in QTableWidget from mysql database table. In the reports page, we have a download button. When the admin click on the download button, the reports will be exported as EXCEL file in the project folder. This export process needs pandas library to be imported.
