#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)
