程式代碼和運行結果如下:
from PyQt5.QtSql import QSqlDatabase,QSqlQuery
def createDB():
db = QSqlDatabase.addDatabase('QSQLITE')
# 指定SQLite資料庫的檔案名
db.setDatabaseName('./db/database.db')
if not db.open():
print('無法建立與資料庫的連接')
return False
query = QSqlQuery()
query.exec('create table people(id int primary key,name varchar(10),address varchar(50))')
query.exec('insert into people values(1,"李寧","Shenyang")')
query.exec('insert into people values(2,"超人","克星")')
db.close()
return True
if __name__ == '__main__':
createDB()
uj5u.com熱心網友回復:
修改代碼成如下:if __name__ == '__main__':
app = QApplication(sys.argv)
createDB()
sys.exit(app.exec_())
uj5u.com熱心網友回復:
我也遇到同樣的問題,樓主解決了嗎?或者建了資料庫檔案,無法創建表,檔案大小為0kb轉載請註明出處,本文鏈接:https://www.uj5u.com/caozuo/21001.html
標籤:應用程序開發區
