python qtablewedgit_PyQt5-TableWidget 表格视图

1 #-*- coding: utf-8 -*-

2

3 #Form implementation generated from reading ui file 'TableView_test.ui'

4 #5 #Created by: PyQt5 UI code generator 5.11.3

6 #7 #WARNING! All changes made in this file will be lost!

8

9 from PyQt5 importQtCore, QtGui, QtWidgets10

11 classUi_dataBaseForm(object):12 defsetupUi(self, dataBaseForm):13 dataBaseForm.setObjectName("dataBaseForm")14 dataBaseForm.resize(1127, 754)15 font =QtGui.QFont()16 font.setBold(False)17 font.setWeight(50)18 dataBaseForm.setFont(font)19 dataBaseForm.setAutoFillBackground(False)20 self.groupBox =QtWidgets.QGroupBox(dataBaseForm)21 self.groupBox.setGeometry(QtCore.QRect(870, 80, 231, 141))22 font =QtGui.QFont()23 font.setBold(False)24 font.setWeight(50)25 self.groupBox.setFont(font)26 self.groupBox.setStyleSheet("")27 self.groupBox.setObjectName("groupBox")28 self.layoutWidget =QtWidgets.QWidget(self.groupBox)29 self.layoutWidget.setGeometry(QtCore.QRect(10, 20, 211, 101))30 self.layoutWidget.setObjectName("layoutWidget")31 self.gridLayout =QtWidgets.QGridLayout(self.layoutWidget)32 self.gridLayout.setContentsMargins(0, 0, 0, 0)33 self.gridLayout.setObjectName("gridLayout")34 self.db_create =QtWidgets.QPushButton(self.layoutWidget)35 self.db_create.setObjectName("db_create")36 self.gridLayout.addWidget(self.db_create, 0, 1, 1, 1)37 self.db_delete_edit =QtWidgets.QLineEdit(self.layoutWidget)38 font =QtGui.QFont()39 font.setFamily("微软雅黑")40 font.setPointSize(12)41 font.setBold(False)42 font.setItalic(False)43 font.setWeight(50)44 self.db_delete_edit.setFont(font)45 self.db_delete_edit.setLayoutDirection(QtCore.Qt.LeftToRight)46 self.db_delete_edit.setStyleSheet("")47 self.db_delete_edit.setAlignment(QtCore.Qt.AlignLeading|QtCore.Qt.AlignLeft|QtCore.Qt.AlignVCenter)48 self.db_delete_edit.setObjectName("db_delete_edit")49 self.gridLayout.addWidget(self.db_delete_edit, 1, 0, 1, 1)50 self.db_delete =QtWidgets.QPushButton(self.layoutWidget)51 self.db_delete.setObjectName("db_delete")52 self.gridLayout.addWidget(self.db_delete, 1, 1, 1, 1)53 self.db_create_edit =QtWidgets.QLineEdit(self.layoutWidget)54 font =QtGui.QFont()55 font.setFamily("微软雅黑")56 font.setPointSize(12)57 font.setBold(False)58 font.setItalic(False)59 font.setWeight(50)60 self.db_create_edit.setFont(font)61 self.db_create_edit.setLayoutDirection(QtCore.Qt.LeftToRight)62 self.db_create_edit.setStyleSheet("")63 self.db_create_edit.setAlignment(QtCore.Qt.AlignLeading|QtCore.Qt.AlignLeft|QtCore.Qt.AlignVCenter)64 self.db_create_edit.setObjectName("db_create_edit")65 self.gridLayout.addWidget(self.db_create_edit, 0, 0, 1, 1)66 self.groupBox_2 =QtWidgets.QGroupBox(dataBaseForm)67 self.groupBox_2.setGeometry(QtCore.QRect(870, 270, 231, 171))68 self.groupBox_2.setObjectName("groupBox_2")69 self.layoutWidget1 =QtWidgets.QWidget(self.groupBox_2)70 self.layoutWidget1.setGeometry(QtCore.QRect(10, 20, 211, 141))71 self.layoutWidget1.setObjectName("layoutWidget1")72 self.gridLayout_2 =QtWidgets.QGridLayout(self.layoutWidget1)73 self.gridLayout_2.setContentsMargins(0, 0, 0, 0)74 self.gridLayout_2.setObjectName("gridLayout_2")75 self.A_title_3 =QtWidgets.QLabel(self.layoutWidget1)76 font =QtGui.QFont()77 font.setPointSize(11)78 self.A_title_3.setFont(font)79 self.A_title_3.setObjectName("A_title_3")80 self.gridLayout_2.addWidget(self.A_title_3, 3, 0, 1, 1)81 self.date_select =QtWidgets.QPushButton(self.layoutWidget1)82 self.date_select.setObjectName("date_select")83 self.gridLayout_2.addWidget(self.date_select, 5, 0, 1, 1)84 self.A_title_2 =QtWidgets.QLabel(self.layoutWidget1)85 font =QtGui.QFont()86 font.setPointSize(11)87 self.A_title_2.setFont(font)88 self.A_title_2.setObjectName("A_title_2")89 self.gridLayout_2.addWidget(self.A_title_2, 0, 0, 1, 1)90 self.date_start =QtWidgets.QDateTimeEdit(self.layoutWidget1)91 font =QtGui.QFont()92 font.setPointSize(12)93 font.setBold(True)94 font.setWeight(75)95 self.date_start.setFont(font)96 self.date_start.setDateTime(QtCore.QDateTime(QtCore.QDate(2019, 1, 1), QtCore.QTime(3, 2, 3)))97 self.date_start.setCalendarPopup(True)98 self.date_start.setObjectName("date_start")99 self.gridLayout_2.addWidget(self.date_start, 1, 0, 1, 1)100 self.date_end =QtWidgets.QDateTimeEdit(self.layoutWidget1)101 font =QtGui.QFont()102 font.setPointSize(12)103 font.setBold(True)104 font.setWeight(75)105 self.date_end.setFont(font)106 self.date_end.setDateTime(QtCore.QDateTime(QtCore.QDate(2019, 3, 1), QtCore.QTime(2, 7, 11)))107 self.date_end.setCalendarPopup(True)108 self.date_end.setObjectName("date_end")109 self.gridLayout_2.addWidget(self.date_end, 4, 0, 1, 1)110 self.groupBox_3 =QtWidgets.QGroupBox(dataBaseForm)111 self.groupBox_3.setGeometry(QtCore.QRect(870, 450, 231, 171))112 self.groupBox_3.setObjectName("groupBox_3")113 self.layoutWidget2 =QtWidgets.QWidget(self.groupBox_3)114 self.layoutWidget2.setGeometry(QtCore.QRect(10, 20, 211, 111))115 self.layoutWidget2.setObjectName("layoutWidget2")116 self.gridLayout_3 =QtWidgets.QGridLayout(self.layoutWidget2)117 self.gridLayout_3.setContentsMargins(0, 0, 0, 0)118 self.gridLayout_3.setObjectName("gridLayout_3")119 self.db_print =QtWidgets.QPushButton(self.layoutWidget2)120 self.db_print.setObjectName("db_print")121 self.gridLayout_3.addWidget(self.db_print, 1, 0, 1, 1)122 self.db_export =QtWidgets.QPushButton(self.layoutWidget2)123 self.db_export.setObjectName("db_export")124 self.gridLayout_3.addWidget(self.db_export, 0, 0, 1, 1)125 self.layoutWidget3 =QtWidgets.QWidget(dataBaseForm)126 self.layoutWidget3.setGeometry(QtCore.QRect(10, 630, 851, 33))127 self.layoutWidget3.setObjectName("layoutWidget3")128 self.horizontalLayout_2 =QtWidgets.QHBoxLayout(self.layoutWidget3)129 self.horizontalLayout_2.setContentsMargins(0, 0, 0, 0)130 self.horizontalLayout_2.setObjectName("horizontalLayout_2")131 self.A_title =QtWidgets.QLabel(self.layoutWidget3)132 font =QtGui.QFont()133 font.setPointSize(10)134 self.A_title.setFont(font)135 self.A_title.setObjectName("A_title")136 self.horizontalLayout_2.addWidget(self.A_title)137 self.db_writ =QtWidgets.QLineEdit(self.layoutWidget3)138 font =QtGui.QFont()139 font.setFamily("新宋体")140 font.setPointSize(10)141 font.setBold(False)142 font.setItalic(False)143 font.setWeight(50)144 self.db_writ.setFont(font)145 self.db_writ.setLayoutDirection(QtCore.Qt.LeftToRight)146 self.db_writ.setStyleSheet("")147 self.db_writ.setAlignment(QtCore.Qt.AlignLeading|QtCore.Qt.AlignLeft|QtCore.Qt.AlignVCenter)148 self.db_writ.setObjectName("db_writ")149 self.horizontalLayout_2.addWidget(self.db_writ)150 self.db_insert =QtWidgets.QPushButton(self.layoutWidget3)151 self.db_insert.setObjectName("db_insert")152 self.horizontalLayout_2.addWidget(self.db_insert)153 self.db_delete_row =QtWidgets.QPushButton(self.layoutWidget3)154 self.db_delete_row.setObjectName("db_delete_row")155 self.horizontalLayout_2.addWidget(self.db_delete_row)156 self.dataView =QtWidgets.QTableWidget(dataBaseForm)157 self.dataView.setGeometry(QtCore.QRect(10, 80, 851, 541))158 self.dataView.setObjectName("dataView")159 #self.dataView.setColumnCount(0)

160 #self.dataView.setRowCount(0)

161

162 self.retranslateUi(dataBaseForm)163 QtCore.QMetaObject.connectSlotsByName(dataBaseForm)164

165 defretranslateUi(self, dataBaseForm):166 _translate =QtCore.QCoreApplication.translate167 dataBaseForm.setWindowTitle(_translate("dataBaseForm", "TableView数据库视图-liangfu"))168 self.groupBox.setTitle(_translate("dataBaseForm", "基本操作"))169 self.db_create.setText(_translate("dataBaseForm", "创建表格"))170 self.db_delete_edit.setText(_translate("dataBaseForm", "dataBase"))171 self.db_delete.setText(_translate("dataBaseForm", "删除表格"))172 self.db_create_edit.setText(_translate("dataBaseForm", "dataBase"))173 self.groupBox_2.setTitle(_translate("dataBaseForm", "查找数据"))174 self.A_title_3.setText(_translate("dataBaseForm", "结束时间："))175 self.date_select.setText(_translate("dataBaseForm", "查询"))176 self.A_title_2.setText(_translate("dataBaseForm", "开始时间："))177 self.date_start.setDisplayFormat(_translate("dataBaseForm", "yyyy-MM-dd hh:mm:ss"))178 self.date_end.setDisplayFormat(_translate("dataBaseForm", "yyyy-MM-dd hh:mm:ss"))179 self.groupBox_3.setTitle(_translate("dataBaseForm", "导出保存"))180 self.db_print.setText(_translate("dataBaseForm", "打印"))181 self.db_export.setText(_translate("dataBaseForm", "导出为Excel文档"))182 self.A_title.setText(_translate("dataBaseForm", "输入数值(空格隔开)："))183 self.db_writ.setText(_translate("dataBaseForm", "0.1023 0.1233 0.1214"))184 self.db_insert.setText(_translate("dataBaseForm", "插入一行"))185 self.db_delete_row.setText(_translate("dataBaseForm", "删除一行"))