class Ui_Form(object):
def setupUi(self, Form):
Form.setObjectName(_fromUtf8("Form"))
Form.resize(400, 300)
self.pushButton = QtGui.QPushButton(Form)
self.pushButton.setGeometry(QtCore.QRect(120, 10, 98, 27))
self.pushButton.setObjectName(_fromUtf8("pushButton"))
self.pushButton.clicked.connect(self.newWindow)
self.treeWidget = QtGui.QTreeWidget(Form)
self.treeWidget.setGeometry(QtCore.QRect(50, 70, 300, 192))
self.treeWidget.setObjectName(_fromUtf8("treeWidget"))
self.treeWidget.headerItem().setText(0, _fromUtf8("1"))
self.retranslateUi(Form)
QtCore.QMetaObject.connectSlotsByName(Form)
def retranslateUi(self, Form):
Form.setWindowTitle(
QtGui.QApplication.translate("Form", "Form", None,
QtGui.QApplication.UnicodeUTF8))
self.pushButton.setText(
QtGui.QApplication.translate("Form", "PushButton", None,
QtGui.QApplication.UnicodeUTF8))
def UpdateTree(self):
db = MySQLdb.connect("localhost", "root", "root", "test")
cursor = db.cursor()
cursor.execute("show columns from nameVal")
col = cursor.fetchall()
print col
cursor.execute("select * from nameVal;")
table = cursor.fetchall()
for c in range(len(col)):
self.treeWidget.setColumnWidth(c, 20)
self.treeWidget.header().setResizeMode(
c, QtGui.QHeaderView.Stretch | QtGui.QHeaderView.Interactive)
self.treeWidget.headerItem().setText(c, str(col[c][0]))
self.treeWidget.clear()
for item in range(len(table)):
QtGui.QTreeWidgetItem(self.treeWidget)
for value in range(len(table[item])):
self.treeWidget.topLevelItem(item).setText(
value, str(table[item][value]))
def newWindow(self):
self.w = MyPopup()
#self.w.setGeometry(QtCore.QRect(100, 100, 400, 200))
self.w.show()
class Ui_Form(object):
def setupUi(self, Form):
Form.setObjectName(_fromUtf8("Form"))
Form.resize(400, 300)
self.pushButton = QtGui.QPushButton(Form)
self.pushButton.setGeometry(QtCore.QRect(120, 10, 98, 27))
self.pushButton.setObjectName(_fromUtf8("pushButton"))
self.pushButton.clicked.connect(self.newWindow)
self.treeWidget = QtGui.QTreeWidget(Form)
self.treeWidget.setGeometry(QtCore.QRect(50, 70, 300, 192))
self.treeWidget.setObjectName(_fromUtf8("treeWidget"))
self.treeWidget.headerItem().setText(0, _fromUtf8("1"))
self.retranslateUi(Form)
QtCore.QMetaObject.connectSlotsByName(Form)
def retranslateUi(self, Form):
Form.setWindowTitle(QtGui.QApplication.translate("Form", "Form", None, QtGui.QApplication.UnicodeUTF8))
self.pushButton.setText(QtGui.QApplication.translate("Form", "PushButton", None, QtGui.QApplication.UnicodeUTF8))
def UpdateTree(self):
db = MySQLdb.connect("localhost","root","root","test" )
cursor = db.cursor()
cursor.execute("show columns from nameVal")
col = cursor.fetchall()
print col
cursor.execute("select * from nameVal;")
table = cursor.fetchall()
for c in range(len(col)):
self.treeWidget.setColumnWidth(c,20)
self.treeWidget.header().setResizeMode(c,QtGui.QHeaderView.Stretch | QtGui.QHeaderView.Interactive)
self.treeWidget.headerItem().setText(c,str(col[c][0]))
self.treeWidget.clear()
for item in range(len(table)):
QtGui.QTreeWidgetItem(self.treeWidget)
for value in range(len(table[item])):
self.treeWidget.topLevelItem(item).setText(value, str(table[item][value]))
def newWindow(self):
self.w = MyPopup()
#self.w.setGeometry(QtCore.QRect(100, 100, 400, 200))
self.w.show()
def newWindow(self):
self.w = MyPopup()
#self.w.setGeometry(QtCore.QRect(100, 100, 400, 200))
self.w.show()
def newWindow(self): self.w = MyPopup() #self.w.setGeometry(QtCore.QRect(100, 100, 400, 200)) self.w.show()
