import sys
from PyQt5.QtCore import *
from PyQt5.QtGui import *
from PyQt5.QtWidgets import *
from PyQt5.QtSql import QSqlDatabase , QSqlQuery
def createDB():
# 連接到資料庫
db = QSqlDatabase.addDatabase('QODBC')
db.setHostName("LAPTOP-LEGP9GUD")
db.setUserName("bts")
db.setPassword("123456")
db.setDatabaseName("Test2")
if not db.open():
QMessageBox.critical(None,("無法打開資料庫"),("無法建立到資料庫的連接\n\n單擊取消按鈕退出應用。"),QMessageBox.Cancel)
return False
query = QSqlQuery()
query.exec_("create table member(no int primary key,name varchar(20),unit varchar(30))")
query.exec_("insert into member values (4,'RM','BTS')")
query.exec_("insert into member values (1,'Jin','BTS')")
query.exec_("insert into member values (2,'SUGA','BTS')")
query.exec_("insert into member values (3,'J-Hope','BTS')")
query.exec_("insert into member values (5,'Jimin','BTS')")
query.exec_("insert into member values (6,'V','BTS')")
query.exec_("insert into member values (7,'JungKook','BTS')")
#關閉資料庫
db.close()
return True
if __name__ == '__main__':
app = QApplication(sys.argv)
createDB()
sys.exit(app.exec_())
代碼如上，搞了一天就是不行，現在這個登錄名和密碼都是可以正常連接到本機資料庫服務器的，不知道哪里有問題，剛開始學希望有大佬指點迷津
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/133750.html
標籤：基礎類
下一篇：為什么4％5得出的是4？