API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 8th, 2017
110
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.40 KB | None | 0 0
raw download clone embed print report
  1. # -*- coding: utf-8 -*-
  2.  
  3. # Form implementation generated from reading ui file 'sql.ui'
  4. #
  5. # Created by: PyQt5 UI code generator 5.9
  6. #
  7. # WARNING! All changes made in this file will be lost!
  8.  
  9. from PyQt5 import QtCore, QtGui, QtWidgets
  10. import pymssql
  11.  
  12. class Ui_Form(object):
  13.  
  14. def setupUi(self, Form):
  15. Form.setObjectName("Form")
  16. Form.setWindowModality(QtCore.Qt.WindowModal)
  17. Form.setEnabled(True)
  18. Form.resize(1159, 718)
  19. sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Fixed, QtWidgets.QSizePolicy.Ignored)
  20. sizePolicy.setHorizontalStretch(0)
  21. sizePolicy.setVerticalStretch(0)
  22. sizePolicy.setHeightForWidth(Form.sizePolicy().hasHeightForWidth())
  23. Form.setSizePolicy(sizePolicy)
  24. Form.setMaximumSize(QtCore.QSize(1159, 718))
  25. Form.setSizeIncrement(QtCore.QSize(66, 0))
  26. Form.setBaseSize(QtCore.QSize(66, 0))
  27. Form.setContextMenuPolicy(QtCore.Qt.DefaultContextMenu)
  28. Form.setWindowTitle("")
  29. Form.setAutoFillBackground(True)
  30. self.groupBox = QtWidgets.QGroupBox(Form)
  31. self.groupBox.setGeometry(QtCore.QRect(3, 1, 1151, 51))
  32. sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Expanding)
  33. sizePolicy.setHorizontalStretch(0)
  34. sizePolicy.setVerticalStretch(0)
  35. sizePolicy.setHeightForWidth(self.groupBox.sizePolicy().hasHeightForWidth())
  36. self.groupBox.setSizePolicy(sizePolicy)
  37. font = QtGui.QFont()
  38. font.setFamily("微软雅黑")
  39. self.groupBox.setFont(font)
  40. self.groupBox.setContextMenuPolicy(QtCore.Qt.CustomContextMenu)
  41. self.groupBox.setAcceptDrops(False)
  42. self.groupBox.setAutoFillBackground(False)
  43. self.groupBox.setFlat(False)
  44. self.groupBox.setCheckable(False)
  45. self.groupBox.setObjectName("groupBox")
  46. self.lineEdit_4 = QtWidgets.QLineEdit(self.groupBox)
  47. self.lineEdit_4.setGeometry(QtCore.QRect(647, 20, 133, 23))
  48. self.lineEdit_4.setEchoMode(QtWidgets.QLineEdit.Password)
  49. self.lineEdit_4.setObjectName("lineEdit_4")
  50. self.label_3 = QtWidgets.QLabel(self.groupBox)
  51. self.label_3.setGeometry(QtCore.QRect(617, 23, 24, 17))
  52. self.label_3.setObjectName("label_3")
  53. self.label_4 = QtWidgets.QLabel(self.groupBox)
  54. self.label_4.setGeometry(QtCore.QRect(786, 23, 48, 17))
  55. self.label_4.setObjectName("label_4")
  56. self.label_2 = QtWidgets.QLabel(self.groupBox)
  57. self.label_2.setGeometry(QtCore.QRect(436, 23, 36, 17))
  58. self.label_2.setObjectName("label_2")
  59. self.lineEdit_5 = QtWidgets.QLineEdit(self.groupBox)
  60. self.lineEdit_5.setGeometry(QtCore.QRect(840, 20, 133, 23))
  61. self.lineEdit_5.setCursor(QtGui.QCursor(QtCore.Qt.ArrowCursor))
  62. self.lineEdit_5.setContextMenuPolicy(QtCore.Qt.DefaultContextMenu)
  63. self.lineEdit_5.setReadOnly(True)
  64. self.lineEdit_5.setObjectName("lineEdit_5")
  65. self.label = QtWidgets.QLabel(self.groupBox)
  66. self.label.setGeometry(QtCore.QRect(9, 23, 61, 17))
  67. self.label.setObjectName("label")
  68. self.lineEdit_3 = QtWidgets.QLineEdit(self.groupBox)
  69. self.lineEdit_3.setGeometry(QtCore.QRect(478, 20, 133, 23))
  70. self.lineEdit_3.setObjectName("lineEdit_3")
  71. self.pushButton_1 = QtWidgets.QPushButton(self.groupBox)
  72. self.pushButton_1.setGeometry(QtCore.QRect(979, 20, 75, 24))
  73. self.pushButton_1.setObjectName("pushButton_1")
  74. self.pushButton_2 = QtWidgets.QPushButton(self.groupBox)
  75. self.pushButton_2.setGeometry(QtCore.QRect(1060, 20, 75, 24))
  76. self.pushButton_2.setObjectName("pushButton_2")
  77. self.lineEdit_1 = QtWidgets.QLineEdit(self.groupBox)
  78. self.lineEdit_1.setGeometry(QtCore.QRect(70, 20, 133, 23))
  79. self.lineEdit_1.setObjectName("lineEdit_1")
  80. self.label_8 = QtWidgets.QLabel(self.groupBox)
  81. self.label_8.setGeometry(QtCore.QRect(210, 23, 61, 17))
  82. self.label_8.setObjectName("label_8")
  83. self.lineEdit_2 = QtWidgets.QLineEdit(self.groupBox)
  84. self.lineEdit_2.setGeometry(QtCore.QRect(280, 20, 133, 23))
  85. self.lineEdit_2.setObjectName("lineEdit_2")
  86. self.groupBox_2 = QtWidgets.QGroupBox(Form)
  87. self.groupBox_2.setGeometry(QtCore.QRect(2, 57, 1151, 62))
  88. font = QtGui.QFont()
  89. font.setFamily("微软雅黑")
  90. self.groupBox_2.setFont(font)
  91. self.groupBox_2.setObjectName("groupBox_2")
  92. self.gridLayout = QtWidgets.QGridLayout(self.groupBox_2)
  93. self.gridLayout.setObjectName("gridLayout")
  94. self.label_5 = QtWidgets.QLabel(self.groupBox_2)
  95. self.label_5.setObjectName("label_5")
  96. self.gridLayout.addWidget(self.label_5, 0, 0, 1, 1)
  97. self.lineEdit_6 = QtWidgets.QLineEdit(self.groupBox_2)
  98. self.lineEdit_6.setMaximumSize(QtCore.QSize(120, 16777215))
  99. self.lineEdit_6.setObjectName("lineEdit_6")
  100. self.gridLayout.addWidget(self.lineEdit_6, 0, 1, 1, 1)
  101. self.pushButton_3 = QtWidgets.QPushButton(self.groupBox_2)
  102. self.pushButton_3.setObjectName("pushButton_3")
  103. self.gridLayout.addWidget(self.pushButton_3, 0, 4, 1, 1)
  104. self.label_6 = QtWidgets.QLabel(self.groupBox_2)
  105. self.label_6.setObjectName("label_6")
  106. self.gridLayout.addWidget(self.label_6, 0, 2, 1, 1)
  107. self.lineEdit_7 = QtWidgets.QLineEdit(self.groupBox_2)
  108. self.lineEdit_7.setObjectName("lineEdit_7")
  109. self.gridLayout.addWidget(self.lineEdit_7, 0, 3, 1, 1)
  110. self.groupBox_3 = QtWidgets.QGroupBox(Form)
  111. self.groupBox_3.setGeometry(QtCore.QRect(3, 117, 831, 581))
  112. font = QtGui.QFont()
  113. font.setFamily("微软雅黑")
  114. self.groupBox_3.setFont(font)
  115. self.groupBox_3.setObjectName("groupBox_3")
  116. self.tableWidget = QtWidgets.QTableWidget(self.groupBox_3)
  117. self.tableWidget.setGeometry(QtCore.QRect(4, 13, 1131, 566))
  118. self.tableWidget.setFocusPolicy(QtCore.Qt.NoFocus)
  119. self.tableWidget.setFrameShadow(QtWidgets.QFrame.Raised)
  120. self.tableWidget.setSizeAdjustPolicy(QtWidgets.QAbstractScrollArea.AdjustIgnored)
  121. self.tableWidget.setEditTriggers(QtWidgets.QAbstractItemView.AnyKeyPressed|QtWidgets.QAbstractItemView.DoubleClicked)
  122. self.tableWidget.setDragEnabled(True)
  123. self.tableWidget.setTextElideMode(QtCore.Qt.ElideNone)
  124. self.tableWidget.setGridStyle(QtCore.Qt.CustomDashLine)
  125. self.tableWidget.setObjectName("tableWidget")
  126. self.tableWidget.setColumnCount(3)
  127. self.tableWidget.setRowCount(18)
  128. item = QtWidgets.QTableWidgetItem()
  129. self.tableWidget.setVerticalHeaderItem(0, item)
  130. item = QtWidgets.QTableWidgetItem()
  131. self.tableWidget.setVerticalHeaderItem(1, item)
  132. item = QtWidgets.QTableWidgetItem()
  133. self.tableWidget.setVerticalHeaderItem(2, item)
  134. item = QtWidgets.QTableWidgetItem()
  135. self.tableWidget.setVerticalHeaderItem(3, item)
  136. item = QtWidgets.QTableWidgetItem()
  137. self.tableWidget.setVerticalHeaderItem(4, item)
  138. item = QtWidgets.QTableWidgetItem()
  139. self.tableWidget.setVerticalHeaderItem(5, item)
  140. item = QtWidgets.QTableWidgetItem()
  141. self.tableWidget.setVerticalHeaderItem(6, item)
  142. item = QtWidgets.QTableWidgetItem()
  143. self.tableWidget.setVerticalHeaderItem(7, item)
  144. item = QtWidgets.QTableWidgetItem()
  145. self.tableWidget.setVerticalHeaderItem(8, item)
  146. item = QtWidgets.QTableWidgetItem()
  147. self.tableWidget.setVerticalHeaderItem(9, item)
  148. item = QtWidgets.QTableWidgetItem()
  149. self.tableWidget.setVerticalHeaderItem(10, item)
  150. item = QtWidgets.QTableWidgetItem()
  151. self.tableWidget.setVerticalHeaderItem(11, item)
  152. item = QtWidgets.QTableWidgetItem()
  153. self.tableWidget.setVerticalHeaderItem(12, item)
  154. item = QtWidgets.QTableWidgetItem()
  155. self.tableWidget.setVerticalHeaderItem(13, item)
  156. item = QtWidgets.QTableWidgetItem()
  157. self.tableWidget.setVerticalHeaderItem(14, item)
  158. item = QtWidgets.QTableWidgetItem()
  159. self.tableWidget.setVerticalHeaderItem(15, item)
  160. item = QtWidgets.QTableWidgetItem()
  161. self.tableWidget.setVerticalHeaderItem(16, item)
  162. item = QtWidgets.QTableWidgetItem()
  163. self.tableWidget.setVerticalHeaderItem(17, item)
  164. item = QtWidgets.QTableWidgetItem()
  165. self.tableWidget.setHorizontalHeaderItem(0, item)
  166. item = QtWidgets.QTableWidgetItem()
  167. self.tableWidget.setHorizontalHeaderItem(1, item)
  168. item = QtWidgets.QTableWidgetItem()
  169. self.tableWidget.setHorizontalHeaderItem(2, item)
  170. item = QtWidgets.QTableWidgetItem()
  171. self.tableWidget.setItem(0, 0, item)
  172. item = QtWidgets.QTableWidgetItem()
  173. self.tableWidget.setItem(11, 0, item)
  174. item = QtWidgets.QTableWidgetItem()
  175. item.setFlags(QtCore.Qt.ItemIsSelectable|QtCore.Qt.ItemIsUserCheckable|QtCore.Qt.ItemIsEnabled)
  176. self.tableWidget.setItem(12, 0, item)
  177. self.progressBar = QtWidgets.QProgressBar(Form)
  178. self.progressBar.setGeometry(QtCore.QRect(0, 700, 1151, 20))
  179. self.progressBar.setProperty("value", 0)
  180. self.progressBar.setObjectName("progressBar")
  181.  
  182. self.retranslateUi(Form)
  183. self.pushButton_1.clicked.connect(self.lineEdit_5_show)
  184. self.pushButton_3.clicked.connect(self.pushButton_3_click)
  185. QtCore.QMetaObject.connectSlotsByName(Form)
  186. Form.setTabOrder(self.lineEdit_1, self.lineEdit_2)
  187. Form.setTabOrder(self.lineEdit_2, self.lineEdit_3)
  188. Form.setTabOrder(self.lineEdit_3, self.lineEdit_4)
  189. Form.setTabOrder(self.lineEdit_4, self.lineEdit_5)
  190. Form.setTabOrder(self.lineEdit_5, self.pushButton_1)
  191. Form.setTabOrder(self.pushButton_1, self.pushButton_2)
  192. Form.setTabOrder(self.pushButton_2, self.lineEdit_6)
  193. Form.setTabOrder(self.lineEdit_6, self.lineEdit_7)
  194. Form.setTabOrder(self.lineEdit_7, self.pushButton_3)
  195.  
  196. def retranslateUi(self, Form):
  197. _translate = QtCore.QCoreApplication.translate
  198. self.groupBox.setTitle(_translate("Form", "连接信息"))
  199. self.label_3.setText(_translate("Form", "密码"))
  200. self.label_4.setText(_translate("Form", "连接状态"))
  201. self.label_2.setText(_translate("Form", "用户名"))
  202. self.lineEdit_5.setText(_translate("Form", "未连接....."))
  203. self.lineEdit_5.setStyleSheet("color:#DEB887")#文本颜色
  204. self.label.setText(_translate("Form", "数据库地址"))
  205. self.pushButton_1.setText(_translate("Form", "连接"))
  206. self.pushButton_2.setText(_translate("Form", "断开"))
  207. self.label_8.setText(_translate("Form", "数据库名称"))
  208. self.groupBox_2.setTitle(_translate("Form", "查询状态"))
  209. self.label_5.setText(_translate("Form", "选择编号"))
  210. self.pushButton_3.setText(_translate("Form", "查询"))
  211. self.label_6.setText(_translate("Form", "印章内容"))
  212. self.groupBox_3.setTitle(_translate("Form", "数据信息"))
  213. item = self.tableWidget.verticalHeaderItem(0)
  214. item.setText(_translate("Form", "1"))
  215. item = self.tableWidget.verticalHeaderItem(1)
  216. item.setText(_translate("Form", "2"))
  217. item = self.tableWidget.verticalHeaderItem(2)
  218. item.setText(_translate("Form", "3"))
  219. item = self.tableWidget.verticalHeaderItem(3)
  220. item.setText(_translate("Form", "4"))
  221. item = self.tableWidget.verticalHeaderItem(4)
  222. item.setText(_translate("Form", "5"))
  223. item = self.tableWidget.verticalHeaderItem(5)
  224. item.setText(_translate("Form", "6"))
  225. item = self.tableWidget.verticalHeaderItem(6)
  226. item.setText(_translate("Form", "7"))
  227. item = self.tableWidget.verticalHeaderItem(7)
  228. item.setText(_translate("Form", "8"))
  229. item = self.tableWidget.verticalHeaderItem(8)
  230. item.setText(_translate("Form", "9"))
  231. item = self.tableWidget.verticalHeaderItem(9)
  232. item.setText(_translate("Form", "10"))
  233. item = self.tableWidget.verticalHeaderItem(10)
  234. item.setText(_translate("Form", "11"))
  235. item = self.tableWidget.verticalHeaderItem(11)
  236. item.setText(_translate("Form", "12"))
  237. item = self.tableWidget.verticalHeaderItem(12)
  238. item.setText(_translate("Form", "13"))
  239. item = self.tableWidget.verticalHeaderItem(13)
  240. item.setText(_translate("Form", "14"))
  241. item = self.tableWidget.verticalHeaderItem(14)
  242. item.setText(_translate("Form", "15"))
  243. item = self.tableWidget.verticalHeaderItem(15)
  244. item.setText(_translate("Form", "16"))
  245. item = self.tableWidget.verticalHeaderItem(16)
  246. item.setText(_translate("Form", "17"))
  247. item = self.tableWidget.verticalHeaderItem(17)
  248. item.setText(_translate("Form", "18"))
  249. item = self.tableWidget.horizontalHeaderItem(0)
  250. item.setText(_translate("Form", "印章编号"))
  251. item = self.tableWidget.horizontalHeaderItem(1)
  252. item.setText(_translate("Form", "印章信息"))
  253. item = self.tableWidget.horizontalHeaderItem(2)
  254. item.setText(_translate("Form", "印章状态"))
  255. __sortingEnabled = self.tableWidget.isSortingEnabled()
  256. self.tableWidget.setSortingEnabled(False)
  257. self.tableWidget.setSortingEnabled(__sortingEnabled)
  258.  
  259.  
  260.  
  261. def lineEdit_5_show(self):
  262. global cur
  263. global conn
  264. conn = pymssql.connect(host=self.lineEdit_1.text(),
  265. user=self.lineEdit_3.text(),
  266. password=self.lineEdit_4.text(),
  267. charset='GBK',
  268. database=self.lineEdit_2.text())
  269.  
  270. cur = conn.cursor()
  271.  
  272. if not cur:
  273. self.lineEdit_5.setText('数据库连接失败...')
  274. else:
  275. self.lineEdit_5.setText('数据库连接成功...')
  276. Sslect = "select * from t_signet WHERE se_signet_id=" + self.lineEdit_6.text() + " and " +"se_content=" +self.lineEdit_7.text()
  277. print(Sslect)
  278.  
  279. def pushButton_3_click(self):
  280. if cur:
  281. Sslect = "select * from t_signet WHERE " + self.lineEdit_6.text() + "And" + self.lineEdit_7.text()
  282. cur.execute(Sslect)
  283. self.tableWidget.show = cur.fetchall()
  284. #print(result)
  285. conn.close()
  286.  
  287.  
  288.  
  289.  
  290.  
  291.  
  292. if __name__ == "__main__":
  293. import sys
  294. app = QtWidgets.QApplication(sys.argv)
  295. MainWindow = QtWidgets.QMainWindow()
  296. ui = Ui_Form()
  297. ui.setupUi(MainWindow)
  298. MainWindow.show()
  299. sys.exit(app.exec_())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!