Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # -*- coding: utf-8 -*-
- # Form implementation generated from reading ui file 'sql.ui'
- #
- # Created by: PyQt5 UI code generator 5.9
- #
- # WARNING! All changes made in this file will be lost!
- from PyQt5 import QtCore, QtGui, QtWidgets
- import pymssql
- class Ui_Form(object):
- def setupUi(self, Form):
- Form.setObjectName("Form")
- Form.setWindowModality(QtCore.Qt.WindowModal)
- Form.setEnabled(True)
- Form.resize(1159, 718)
- sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Fixed, QtWidgets.QSizePolicy.Ignored)
- sizePolicy.setHorizontalStretch(0)
- sizePolicy.setVerticalStretch(0)
- sizePolicy.setHeightForWidth(Form.sizePolicy().hasHeightForWidth())
- Form.setSizePolicy(sizePolicy)
- Form.setMaximumSize(QtCore.QSize(1159, 718))
- Form.setSizeIncrement(QtCore.QSize(66, 0))
- Form.setBaseSize(QtCore.QSize(66, 0))
- Form.setContextMenuPolicy(QtCore.Qt.DefaultContextMenu)
- Form.setWindowTitle("")
- Form.setAutoFillBackground(True)
- self.groupBox = QtWidgets.QGroupBox(Form)
- self.groupBox.setGeometry(QtCore.QRect(3, 1, 1151, 51))
- sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Expanding)
- sizePolicy.setHorizontalStretch(0)
- sizePolicy.setVerticalStretch(0)
- sizePolicy.setHeightForWidth(self.groupBox.sizePolicy().hasHeightForWidth())
- self.groupBox.setSizePolicy(sizePolicy)
- font = QtGui.QFont()
- font.setFamily("微软雅黑")
- self.groupBox.setFont(font)
- self.groupBox.setContextMenuPolicy(QtCore.Qt.CustomContextMenu)
- self.groupBox.setAcceptDrops(False)
- self.groupBox.setAutoFillBackground(False)
- self.groupBox.setFlat(False)
- self.groupBox.setCheckable(False)
- self.groupBox.setObjectName("groupBox")
- self.lineEdit_4 = QtWidgets.QLineEdit(self.groupBox)
- self.lineEdit_4.setGeometry(QtCore.QRect(647, 20, 133, 23))
- self.lineEdit_4.setEchoMode(QtWidgets.QLineEdit.Password)
- self.lineEdit_4.setObjectName("lineEdit_4")
- self.label_3 = QtWidgets.QLabel(self.groupBox)
- self.label_3.setGeometry(QtCore.QRect(617, 23, 24, 17))
- self.label_3.setObjectName("label_3")
- self.label_4 = QtWidgets.QLabel(self.groupBox)
- self.label_4.setGeometry(QtCore.QRect(786, 23, 48, 17))
- self.label_4.setObjectName("label_4")
- self.label_2 = QtWidgets.QLabel(self.groupBox)
- self.label_2.setGeometry(QtCore.QRect(436, 23, 36, 17))
- self.label_2.setObjectName("label_2")
- self.lineEdit_5 = QtWidgets.QLineEdit(self.groupBox)
- self.lineEdit_5.setGeometry(QtCore.QRect(840, 20, 133, 23))
- self.lineEdit_5.setCursor(QtGui.QCursor(QtCore.Qt.ArrowCursor))
- self.lineEdit_5.setContextMenuPolicy(QtCore.Qt.DefaultContextMenu)
- self.lineEdit_5.setReadOnly(True)
- self.lineEdit_5.setObjectName("lineEdit_5")
- self.label = QtWidgets.QLabel(self.groupBox)
- self.label.setGeometry(QtCore.QRect(9, 23, 61, 17))
- self.label.setObjectName("label")
- self.lineEdit_3 = QtWidgets.QLineEdit(self.groupBox)
- self.lineEdit_3.setGeometry(QtCore.QRect(478, 20, 133, 23))
- self.lineEdit_3.setObjectName("lineEdit_3")
- self.pushButton_1 = QtWidgets.QPushButton(self.groupBox)
- self.pushButton_1.setGeometry(QtCore.QRect(979, 20, 75, 24))
- self.pushButton_1.setObjectName("pushButton_1")
- self.pushButton_2 = QtWidgets.QPushButton(self.groupBox)
- self.pushButton_2.setGeometry(QtCore.QRect(1060, 20, 75, 24))
- self.pushButton_2.setObjectName("pushButton_2")
- self.lineEdit_1 = QtWidgets.QLineEdit(self.groupBox)
- self.lineEdit_1.setGeometry(QtCore.QRect(70, 20, 133, 23))
- self.lineEdit_1.setObjectName("lineEdit_1")
- self.label_8 = QtWidgets.QLabel(self.groupBox)
- self.label_8.setGeometry(QtCore.QRect(210, 23, 61, 17))
- self.label_8.setObjectName("label_8")
- self.lineEdit_2 = QtWidgets.QLineEdit(self.groupBox)
- self.lineEdit_2.setGeometry(QtCore.QRect(280, 20, 133, 23))
- self.lineEdit_2.setObjectName("lineEdit_2")
- self.groupBox_2 = QtWidgets.QGroupBox(Form)
- self.groupBox_2.setGeometry(QtCore.QRect(2, 57, 1151, 62))
- font = QtGui.QFont()
- font.setFamily("微软雅黑")
- self.groupBox_2.setFont(font)
- self.groupBox_2.setObjectName("groupBox_2")
- self.gridLayout = QtWidgets.QGridLayout(self.groupBox_2)
- self.gridLayout.setObjectName("gridLayout")
- self.label_5 = QtWidgets.QLabel(self.groupBox_2)
- self.label_5.setObjectName("label_5")
- self.gridLayout.addWidget(self.label_5, 0, 0, 1, 1)
- self.lineEdit_6 = QtWidgets.QLineEdit(self.groupBox_2)
- self.lineEdit_6.setMaximumSize(QtCore.QSize(120, 16777215))
- self.lineEdit_6.setObjectName("lineEdit_6")
- self.gridLayout.addWidget(self.lineEdit_6, 0, 1, 1, 1)
- self.pushButton_3 = QtWidgets.QPushButton(self.groupBox_2)
- self.pushButton_3.setObjectName("pushButton_3")
- self.gridLayout.addWidget(self.pushButton_3, 0, 4, 1, 1)
- self.label_6 = QtWidgets.QLabel(self.groupBox_2)
- self.label_6.setObjectName("label_6")
- self.gridLayout.addWidget(self.label_6, 0, 2, 1, 1)
- self.lineEdit_7 = QtWidgets.QLineEdit(self.groupBox_2)
- self.lineEdit_7.setObjectName("lineEdit_7")
- self.gridLayout.addWidget(self.lineEdit_7, 0, 3, 1, 1)
- self.groupBox_3 = QtWidgets.QGroupBox(Form)
- self.groupBox_3.setGeometry(QtCore.QRect(3, 117, 831, 581))
- font = QtGui.QFont()
- font.setFamily("微软雅黑")
- self.groupBox_3.setFont(font)
- self.groupBox_3.setObjectName("groupBox_3")
- self.tableWidget = QtWidgets.QTableWidget(self.groupBox_3)
- self.tableWidget.setGeometry(QtCore.QRect(4, 13, 1131, 566))
- self.tableWidget.setFocusPolicy(QtCore.Qt.NoFocus)
- self.tableWidget.setFrameShadow(QtWidgets.QFrame.Raised)
- self.tableWidget.setSizeAdjustPolicy(QtWidgets.QAbstractScrollArea.AdjustIgnored)
- self.tableWidget.setEditTriggers(QtWidgets.QAbstractItemView.AnyKeyPressed|QtWidgets.QAbstractItemView.DoubleClicked)
- self.tableWidget.setDragEnabled(True)
- self.tableWidget.setTextElideMode(QtCore.Qt.ElideNone)
- self.tableWidget.setGridStyle(QtCore.Qt.CustomDashLine)
- self.tableWidget.setObjectName("tableWidget")
- self.tableWidget.setColumnCount(3)
- self.tableWidget.setRowCount(18)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(0, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(1, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(2, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(3, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(4, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(5, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(6, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(7, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(8, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(9, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(10, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(11, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(12, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(13, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(14, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(15, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(16, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setVerticalHeaderItem(17, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setHorizontalHeaderItem(0, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setHorizontalHeaderItem(1, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setHorizontalHeaderItem(2, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setItem(0, 0, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setItem(11, 0, item)
- item = QtWidgets.QTableWidgetItem()
- item.setFlags(QtCore.Qt.ItemIsSelectable|QtCore.Qt.ItemIsUserCheckable|QtCore.Qt.ItemIsEnabled)
- self.tableWidget.setItem(12, 0, item)
- self.progressBar = QtWidgets.QProgressBar(Form)
- self.progressBar.setGeometry(QtCore.QRect(0, 700, 1151, 20))
- self.progressBar.setProperty("value", 0)
- self.progressBar.setObjectName("progressBar")
- self.retranslateUi(Form)
- self.pushButton_1.clicked.connect(self.lineEdit_5_show)
- self.pushButton_3.clicked.connect(self.pushButton_3_click)
- QtCore.QMetaObject.connectSlotsByName(Form)
- Form.setTabOrder(self.lineEdit_1, self.lineEdit_2)
- Form.setTabOrder(self.lineEdit_2, self.lineEdit_3)
- Form.setTabOrder(self.lineEdit_3, self.lineEdit_4)
- Form.setTabOrder(self.lineEdit_4, self.lineEdit_5)
- Form.setTabOrder(self.lineEdit_5, self.pushButton_1)
- Form.setTabOrder(self.pushButton_1, self.pushButton_2)
- Form.setTabOrder(self.pushButton_2, self.lineEdit_6)
- Form.setTabOrder(self.lineEdit_6, self.lineEdit_7)
- Form.setTabOrder(self.lineEdit_7, self.pushButton_3)
- def retranslateUi(self, Form):
- _translate = QtCore.QCoreApplication.translate
- self.groupBox.setTitle(_translate("Form", "连接信息"))
- self.label_3.setText(_translate("Form", "密码"))
- self.label_4.setText(_translate("Form", "连接状态"))
- self.label_2.setText(_translate("Form", "用户名"))
- self.lineEdit_5.setText(_translate("Form", "未连接....."))
- self.lineEdit_5.setStyleSheet("color:#DEB887")#文本颜色
- self.label.setText(_translate("Form", "数据库地址"))
- self.pushButton_1.setText(_translate("Form", "连接"))
- self.pushButton_2.setText(_translate("Form", "断开"))
- self.label_8.setText(_translate("Form", "数据库名称"))
- self.groupBox_2.setTitle(_translate("Form", "查询状态"))
- self.label_5.setText(_translate("Form", "选择编号"))
- self.pushButton_3.setText(_translate("Form", "查询"))
- self.label_6.setText(_translate("Form", "印章内容"))
- self.groupBox_3.setTitle(_translate("Form", "数据信息"))
- item = self.tableWidget.verticalHeaderItem(0)
- item.setText(_translate("Form", "1"))
- item = self.tableWidget.verticalHeaderItem(1)
- item.setText(_translate("Form", "2"))
- item = self.tableWidget.verticalHeaderItem(2)
- item.setText(_translate("Form", "3"))
- item = self.tableWidget.verticalHeaderItem(3)
- item.setText(_translate("Form", "4"))
- item = self.tableWidget.verticalHeaderItem(4)
- item.setText(_translate("Form", "5"))
- item = self.tableWidget.verticalHeaderItem(5)
- item.setText(_translate("Form", "6"))
- item = self.tableWidget.verticalHeaderItem(6)
- item.setText(_translate("Form", "7"))
- item = self.tableWidget.verticalHeaderItem(7)
- item.setText(_translate("Form", "8"))
- item = self.tableWidget.verticalHeaderItem(8)
- item.setText(_translate("Form", "9"))
- item = self.tableWidget.verticalHeaderItem(9)
- item.setText(_translate("Form", "10"))
- item = self.tableWidget.verticalHeaderItem(10)
- item.setText(_translate("Form", "11"))
- item = self.tableWidget.verticalHeaderItem(11)
- item.setText(_translate("Form", "12"))
- item = self.tableWidget.verticalHeaderItem(12)
- item.setText(_translate("Form", "13"))
- item = self.tableWidget.verticalHeaderItem(13)
- item.setText(_translate("Form", "14"))
- item = self.tableWidget.verticalHeaderItem(14)
- item.setText(_translate("Form", "15"))
- item = self.tableWidget.verticalHeaderItem(15)
- item.setText(_translate("Form", "16"))
- item = self.tableWidget.verticalHeaderItem(16)
- item.setText(_translate("Form", "17"))
- item = self.tableWidget.verticalHeaderItem(17)
- item.setText(_translate("Form", "18"))
- item = self.tableWidget.horizontalHeaderItem(0)
- item.setText(_translate("Form", "印章编号"))
- item = self.tableWidget.horizontalHeaderItem(1)
- item.setText(_translate("Form", "印章信息"))
- item = self.tableWidget.horizontalHeaderItem(2)
- item.setText(_translate("Form", "印章状态"))
- __sortingEnabled = self.tableWidget.isSortingEnabled()
- self.tableWidget.setSortingEnabled(False)
- self.tableWidget.setSortingEnabled(__sortingEnabled)
- def lineEdit_5_show(self):
- try:
- global cur
- global conn
- conn = pymssql.connect(host=self.lineEdit_1.text(),
- user=self.lineEdit_3.text(),
- password=self.lineEdit_4.text(),
- charset='GBK',
- database=self.lineEdit_2.text())
- cur = conn.cursor()
- if not cur:
- self.lineEdit_5.setText('数据库连接失败...')
- else:
- self.lineEdit_5.setText('数据库连接成功...')
- except Exception as e:
- print(e)
- def pushButton_3_click(self):
- try:
- if self.lineEdit_6.text =='':
- Sslect = "select * from t_signet WHERE se_content LIKE '%s%%'" % (self.lineEdit_7.text())
- elif self.lineEdit_7.text=='':
- Sslect = "select * from t_signet WHERE se_signet_id LIKE '%s%%'" % (self.lineEdit_6.text())
- else:
- Sslect = "select * from t_signet WHERE se_signet_id ='%s%%' or se_content ='%s%%'" % \
- (self.lineEdit_6.text(),self.lineEdit_7.text())
- cur.execute(Sslect)
- result = cur.fetchall()
- print(result)
- conn.close()
- except Exception as e:
- print(e)
- if __name__ == "__main__":
- import sys
- app = QtWidgets.QApplication(sys.argv)
- MainWindow = QtWidgets.QMainWindow()
- ui = Ui_Form()
- ui.setupUi(MainWindow)
- MainWindow.show()
- sys.exit(app.exec_())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement