Using databases in PyQt5 involves using Qt’s SQL module to connect and manipulate databases. Here is a simple example demonstrating how to connect to a SQLite database and execute queries in PyQt5.<\/p>\n
from<\/span> PyQt5 import<\/span> QtSql\r\n\r\n# \u521b\u5efa\u6570\u636e\u5e93\u8fde\u63a5<\/span>\r\ndb = QtSql.QSqlDatabase.addDatabase('QSQLITE'<\/span>)\r\ndb.setDatabaseName('test.db'<\/span>)\r\n\r\nif<\/span> not<\/span> db.open<\/span>():\r\n print<\/span>('\u65e0\u6cd5\u6253\u5f00\u6570\u636e\u5e93\u8fde\u63a5'<\/span>)\r\nelse<\/span>:\r\n query = QtSql.QSqlQuery()\r\n query.exec_(\"CREATE TABLE person (id INTEGER PRIMARY KEY, name TEXT)\"<\/span>)\r\n\r\n # \u63d2\u5165\u6570\u636e<\/span>\r\n query.exec_(\"INSERT INTO person (name) VALUES ('Alice')\"<\/span>)\r\n query.exec_(\"INSERT INTO person (name) VALUES ('Bob')\"<\/span>)\r\n\r\n # \u67e5\u8be2\u6570\u636e<\/span>\r\n query.exec_(\"SELECT * FROM person\"<\/span>)\r\n while<\/span> query.next<\/span>():\r\n id<\/span> = query.value(0<\/span>)\r\n name = query.value(1<\/span>)\r\n print<\/span>(f'id: {id<\/span>}<\/span>, name: {name}<\/span>'<\/span>)\r\n\r\n # \u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5<\/span>\r\n db.close()\r\n<\/code><\/pre>\nIn this example, start by establishing a connection to a SQLite<\/a> database, then perform various database operations such as creating tables, inserting data, and querying data. Finally, close the database connection.<\/p>\nIt is important to note that PyQt5 provides the QtSql module for database operations, supporting various databases such as SQLite, MySQL, and PostgreSQL. When using different databases, it is necessary to adjust settings and operations accordingly based on the specific database type.<\/p>\n
<\/p>\n
More tutorials<\/p>\n
insertMany function for bulk insertion into a MongoDB database.(Opens in a new browser tab)<\/span><\/a><\/p>\nWhat operating systems does PyQt5 support?(Opens in a new browser tab)<\/span><\/a><\/p>\nHow to add a menu bar in PyQt5?(Opens in a new browser tab)<\/span><\/a><\/p>\nWhat is the purpose of the QThread class in PyQt5?(Opens in a new browser tab)<\/span><\/a><\/p>\n