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)
def getFieldType(db: QSqlDatabase, typeID: int) -> FieldType: '''根据当前数据库类型,返回一个数据库中字段的FieldType枚举值''' database_type = {'QMYSQL3': _MySqlFieldType} fun = database_type[db.driverName()]() tp = fun.getFieldType(typeID) return tp