#coding=utf-8 from PyQt5.QtSql import QSqlDatabase, QSqlQuery from PyQt5.QtCore import * from PyQt5.QtWidgets import QApplication if __name__=='__main__': import sys app=QApplication(sys.argv) db=QSqlDatabase("QMYSQL") db.setHostName('57af503e35be5.gz.cdb.myqcloud.com') db.setDatabaseName('gstar') db.setUserName('root') db.setPassword('root123456*') db.setPort(4402) if not db.open(): print('open error') else: print ('open success!') print ('db is open', db.isOpen()) print ("db's driver name is", db.driverName()) print ("db's tables", db.tables()) query=QSqlQuery(db) query.prepare(u"SELECT * FROM material") s=query.exec_() while query.next(): print (query.value(0)) print (s)