-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathUi_Database.py
164 lines (157 loc) · 9.47 KB
/
Ui_Database.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
# -*- coding: utf-8 -*-
# Form implementation generated from reading ui file 'd:\MyCode\Software\Exp22\EatecPlayer 12_22_21_37\Database.ui'
#
# Created by: PyQt5 UI code generator 5.15.4
#
# WARNING: Any manual changes made to this file will be lost when pyuic5 is
# run again. Do not edit this file unless you know what you are doing.
from PyQt5 import QtCore, QtGui, QtWidgets
class Ui_MainWindow(object):
def setupUi(self, MainWindow):
MainWindow.setObjectName("MainWindow")
MainWindow.resize(879, 379)
self.widget = QtWidgets.QWidget(MainWindow)
self.widget.setObjectName("widget")
self.gridLayout = QtWidgets.QGridLayout(self.widget)
self.gridLayout.setObjectName("gridLayout")
self.group_box = QtWidgets.QGroupBox(self.widget)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Preferred)
sizePolicy.setHorizontalStretch(4)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(self.group_box.sizePolicy().hasHeightForWidth())
self.group_box.setSizePolicy(sizePolicy)
self.group_box.setObjectName("group_box")
self.verticalLayout = QtWidgets.QVBoxLayout(self.group_box)
self.verticalLayout.setObjectName("verticalLayout")
self.b_view_data = QtWidgets.QPushButton(self.group_box)
self.b_view_data.setObjectName("b_view_data")
self.verticalLayout.addWidget(self.b_view_data)
self.b_refresh = QtWidgets.QPushButton(self.group_box)
self.b_refresh.setObjectName("b_refresh")
self.verticalLayout.addWidget(self.b_refresh)
self.b_add_row = QtWidgets.QPushButton(self.group_box)
self.b_add_row.setObjectName("b_add_row")
self.verticalLayout.addWidget(self.b_add_row)
self.b_modifyvip = QtWidgets.QPushButton(self.group_box)
self.b_modifyvip.setObjectName("b_modifyvip")
self.verticalLayout.addWidget(self.b_modifyvip)
self.b_modifyenddate = QtWidgets.QPushButton(self.group_box)
self.b_modifyenddate.setObjectName("b_modifyenddate")
self.verticalLayout.addWidget(self.b_modifyenddate)
self.b_modifyadmin = QtWidgets.QPushButton(self.group_box)
self.b_modifyadmin.setObjectName("b_modifyadmin")
self.verticalLayout.addWidget(self.b_modifyadmin)
self.b_delete_row = QtWidgets.QPushButton(self.group_box)
self.b_delete_row.setObjectName("b_delete_row")
self.verticalLayout.addWidget(self.b_delete_row)
self.b_close = QtWidgets.QPushButton(self.group_box)
self.b_close.setObjectName("b_close")
self.verticalLayout.addWidget(self.b_close)
self.gridLayout.addWidget(self.group_box, 0, 0, 2, 1)
self.table_widget = QtWidgets.QTableView(self.widget)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Expanding)
sizePolicy.setHorizontalStretch(16)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(self.table_widget.sizePolicy().hasHeightForWidth())
self.table_widget.setSizePolicy(sizePolicy)
self.table_widget.setObjectName("table_widget")
self.gridLayout.addWidget(self.table_widget, 1, 1, 1, 1)
self.groupBox_2 = QtWidgets.QGroupBox(self.widget)
self.groupBox_2.setObjectName("groupBox_2")
self.gridLayout_2 = QtWidgets.QGridLayout(self.groupBox_2)
self.gridLayout_2.setObjectName("gridLayout_2")
self.label_6 = QtWidgets.QLabel(self.groupBox_2)
self.label_6.setMinimumSize(QtCore.QSize(0, 30))
self.label_6.setObjectName("label_6")
self.gridLayout_2.addWidget(self.label_6, 0, 0, 1, 1)
self.label_7 = QtWidgets.QLabel(self.groupBox_2)
self.label_7.setMinimumSize(QtCore.QSize(0, 30))
self.label_7.setObjectName("label_7")
self.gridLayout_2.addWidget(self.label_7, 2, 0, 1, 1)
spacerItem = QtWidgets.QSpacerItem(20, 40, QtWidgets.QSizePolicy.Minimum, QtWidgets.QSizePolicy.Expanding)
self.gridLayout_2.addItem(spacerItem, 4, 0, 1, 1)
spacerItem1 = QtWidgets.QSpacerItem(20, 40, QtWidgets.QSizePolicy.Minimum, QtWidgets.QSizePolicy.Expanding)
self.gridLayout_2.addItem(spacerItem1, 4, 1, 1, 1)
self.l_usercount = QtWidgets.QLabel(self.groupBox_2)
self.l_usercount.setMinimumSize(QtCore.QSize(0, 30))
self.l_usercount.setObjectName("l_usercount")
self.gridLayout_2.addWidget(self.l_usercount, 1, 1, 1, 1)
self.l_timecount = QtWidgets.QLabel(self.groupBox_2)
self.l_timecount.setMinimumSize(QtCore.QSize(0, 30))
self.l_timecount.setObjectName("l_timecount")
self.gridLayout_2.addWidget(self.l_timecount, 3, 1, 1, 1)
self.gridLayout.addWidget(self.groupBox_2, 1, 2, 1, 1)
self.groupBox = QtWidgets.QGroupBox(self.widget)
self.groupBox.setObjectName("groupBox")
self.horizontalLayout = QtWidgets.QHBoxLayout(self.groupBox)
self.horizontalLayout.setObjectName("horizontalLayout")
self.b_run = QtWidgets.QPushButton(self.groupBox)
self.b_run.setObjectName("b_run")
self.horizontalLayout.addWidget(self.b_run)
self.label = QtWidgets.QLabel(self.groupBox)
self.label.setObjectName("label")
self.horizontalLayout.addWidget(self.label)
self.name_modifytext = QtWidgets.QLineEdit(self.groupBox)
self.name_modifytext.setMinimumSize(QtCore.QSize(70, 0))
self.name_modifytext.setObjectName("name_modifytext")
self.horizontalLayout.addWidget(self.name_modifytext)
self.label_2 = QtWidgets.QLabel(self.groupBox)
self.label_2.setObjectName("label_2")
self.horizontalLayout.addWidget(self.label_2)
self.pw_modifytext = QtWidgets.QLineEdit(self.groupBox)
self.pw_modifytext.setMinimumSize(QtCore.QSize(70, 0))
self.pw_modifytext.setObjectName("pw_modifytext")
self.horizontalLayout.addWidget(self.pw_modifytext)
self.label_3 = QtWidgets.QLabel(self.groupBox)
self.label_3.setObjectName("label_3")
self.horizontalLayout.addWidget(self.label_3)
self.vip_modifytext = QtWidgets.QLineEdit(self.groupBox)
self.vip_modifytext.setObjectName("vip_modifytext")
self.horizontalLayout.addWidget(self.vip_modifytext)
self.label_5 = QtWidgets.QLabel(self.groupBox)
self.label_5.setObjectName("label_5")
self.horizontalLayout.addWidget(self.label_5)
self.date_modifytext = QtWidgets.QLineEdit(self.groupBox)
self.date_modifytext.setMinimumSize(QtCore.QSize(70, 0))
self.date_modifytext.setText("")
self.date_modifytext.setObjectName("date_modifytext")
self.horizontalLayout.addWidget(self.date_modifytext)
self.label_4 = QtWidgets.QLabel(self.groupBox)
self.label_4.setObjectName("label_4")
self.horizontalLayout.addWidget(self.label_4)
self.adm_modifytext = QtWidgets.QLineEdit(self.groupBox)
self.adm_modifytext.setObjectName("adm_modifytext")
self.horizontalLayout.addWidget(self.adm_modifytext)
self.gridLayout.addWidget(self.groupBox, 0, 1, 1, 2)
MainWindow.setCentralWidget(self.widget)
self.retranslateUi(MainWindow)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
def retranslateUi(self, MainWindow):
_translate = QtCore.QCoreApplication.translate
MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
self.group_box.setTitle(_translate("MainWindow", "操作模式选择"))
self.b_view_data.setText(_translate("MainWindow", "连接数据库"))
self.b_refresh.setText(_translate("MainWindow", "刷新数据"))
self.b_add_row.setText(_translate("MainWindow", "添加用户"))
self.b_modifyvip.setText(_translate("MainWindow", "修改VIP状态"))
self.b_modifyenddate.setText(_translate("MainWindow", "修改VIP有效期"))
self.b_modifyadmin.setText(_translate("MainWindow", "修改管理员状态"))
self.b_delete_row.setText(_translate("MainWindow", "删除用户"))
self.b_close.setText(_translate("MainWindow", "退出"))
self.groupBox_2.setTitle(_translate("MainWindow", "数据统计"))
self.label_6.setText(_translate("MainWindow", "用户人数："))
self.label_7.setText(_translate("MainWindow", "播放时长统计："))
self.l_usercount.setText(_translate("MainWindow", "0"))
self.l_timecount.setText(_translate("MainWindow", "0"))
self.groupBox.setTitle(_translate("MainWindow", "数据库操作(执行前先填写数据)"))
self.b_run.setText(_translate("MainWindow", "执行"))
self.label.setText(_translate("MainWindow", "用户名"))
self.name_modifytext.setPlaceholderText(_translate("MainWindow", "必选项"))
self.label_2.setText(_translate("MainWindow", "密码"))
self.pw_modifytext.setPlaceholderText(_translate("MainWindow", "至少6位"))
self.label_3.setText(_translate("MainWindow", "VIP状态（t/f）"))
self.vip_modifytext.setText(_translate("MainWindow", "f"))
self.label_5.setText(_translate("MainWindow", "VIP有效期"))
self.date_modifytext.setPlaceholderText(_translate("MainWindow", "2021-01-30"))
self.label_4.setText(_translate("MainWindow", "管理员状态（t/f）"))
self.adm_modifytext.setText(_translate("MainWindow", "f"))