|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/python-pyqt-database-programming/
课程评论：没有评论
课程名称：Python Pyqt5数据库编程与MySQL在Qt Designer中的应用 概述： 欢迎同学们，感谢您对本课程《Python Pyqt5数据库编程与MySQL在Qt Designer中的应用》的关注。本课程将对希望使用Python Pyqt5和MySQL服务器开发完整软件应用的学生非常有用。Python Pyqt5是一种现代的图形用户界面（GUI）开发库，我们可以使用它开发各种GUI应用程序。而在开发GUI应用软件时，需要一个数据库来存储数据，MySQL服务器是世界上最常用的数据库服务器之一，以安全的方式存储客户和公司数据非常重要。因此，在软件开发中使用MySQL服务器存储数据是非常必要的。 在本课程中，您将学习以下概念： 1. 软件安装 - 如何安装Python最新版本 - 通过pip安装Pyqt5 - 通过pip安装Pyqt5工具 - 配置Qt Designer - 安装XAMPP服务器以支持MySQL - 安装MySQL连接器 - 安装Python程序编辑器 2. 通过Python PyQt5和Qt Designer创建MySQL数据库 - 设计表单，输入要创建的数据库名称，点击按钮后在MySQL服务器上创建数据库。 3. 通过Python PyQt5和Qt Designer删除MySQL数据库 - 设计表单，输入要删除的数据库名称，点击按钮后在MySQL服务器上删除该数据库。 4. 向MySQL数据库表中插入数据 - 设计表单，输入姓名、地址、电话和电子邮件，填写完毕后点击按钮，将详细信息插入MySQL服务器数据库表中。 5. 更新MySQL数据库表中的数据 - 设计表单，从下拉框选择电子邮件ID，并显示对应的姓名、地址和电话。修改后点击按钮，更新MySQL数据库表中的数据。 6. 从MySQL数据库表中删除数据 - 设计表单，选择电子邮件ID，点击按钮后删除对应行的数据。 7. 使用PyQt5中的QTable Widget显示MySQL数据库表的数据 - 设计表单，使用QTable Widget展示MySQL数据库表中的所有数据。 本课程将为希望学习如何使用Python Pyqt5 GUI开发库与MySQL数据库开发GUI应用的学生提供宝贵的知识。我们欢迎您加入本课程，深入了解使用Python Pyqt5库进行MySQL数据库编程的知识。 谢谢大家！期待在课程中见到您！
Hello students, Thank you very much for showing interest in this course Python Pyqt5 Database Programming with MySql in Qt Designer.This course is going to be very useful for the students who want to create to develop a complete software application using python pyqt5 and mysql server as back end.Python pyqt5 is a moden GUI development library. We can develop a lot of GUI Applications using python pyqt5. If we want to develop GUI based application software, we require a database to store our datas. Mysql server is one of the most used database server in the world. It is very important to store our customer and companies data in a secured way. So using mysql server to store our data is very important in software development.In this course you are going learn the following conceptsSoftware installation1. How to install python latest version2. Install Pyqt5 through pip3. Install Pyqt5 Tools through pip4. Configure Qt Designer5. Install Xampp server for Mysql 6. Install mysql connector7. Install Python program EditorMysql Database creation through Python PyQt5 using Qt DesignerWe will design a form in Qt Designer that contains a Line edit and a Push Button. After enter the database name we want to create in the line edit, If we click the push button, the database will be created in the mysql server. We can check the mysql server by opening the in the web browser. Initially we have to start the mysql server and apache server from the xampp control panel.Mysql Database deletion through Python PyQt5 using Qt DesignerWe will design a form in Qt Designer that contains a Line edit and a Push Button. After enter the database name we want to delete in the line edit, If we click the push button, the database will be deleted or dropped in the mysql server. We can check the mysql server by opening the in the web browser. Initially we have to start the mysql server and apache server from the xampp control panel.Insert into mysql database table through Python PyQt5 using Qt DesignerWe will design a form in Qt Designer that contains input for name, address, phone and email. After fill all the details in the Pyqt5 Gui form, If we click the push button, the the entered details will be inserted in the mysql server database table. We can check the mysql server by opening the in the web browser. Update the data in mysql database table through Python PyQt5 using Qt DesignerWe will design a form in Qt Designer that contains combobox filled with all email id in the mysql database table. We use email id as unique field because each persons email id will be unique. When we select a email id from the combo box, the name, address, phone number will be filled in the corresponding input controls. After we made the required changes, if we click the push button, the modified details will be updated in the mysql database table for the selected email id. We can chech the updates in the mysql server database.Delete the data in mysql database table through Python PyQt5 using Qt DesignerWe will design a form in Qt Designer that contains combobox filled with all email id in the mysql database table. We use email id as unique field because each persons email id will be unique. When we select a email id from the combo box and if we click the push button, the details in the complete row will be deleted in the mysql database table for the selected email id. We can chech the deleted in the mysql server database.Display the data from mysql database table in the Python PyQt5 using Qt Designer Table widgetWe will design a form in Qt Designer that contains QTable Widget filled with all data in the mysql database table. The program will collect all the data from the mysql database table and save it in to an array. Then the data will be added to qtable widget in rows and columns.This course will be very useful for the students who want to learn how to develop a GUI application using python pyqt5 GUI development library using mysql database.I welcome you all to join this course and get a strong knowledge in the mysql database programming using python pyqt5 libraryThank you very much.. I will see you in the course.....
