PyQt5 快速開發 - 學生管理系統專案實戰報告
2022-01-02 13:00:23
PyQt5 快速開發 - 學生管理系統專案實戰報告
為了實現我的計劃，我使用 PyQt5 編寫程式，製作了一個簡易 GUI 的 學生管理系統，作為 2021 年最後一個程式，運用到了我在2021年所學的大部分知識，絕對算得上是壓軸程式，但是並沒有給介面做美化。
- 登入介面
- 主介面
一、登陸介面搭建
登入介面用的 Designer 視覺化程式搭建的，動動滑鼠就能輕鬆搭建出一個使用者介面。
然後在 Pycharm 中用 PyUIC 把 .ui 檔案轉為 .py 檔案。
二、登陸驗證
在介面程式中給兩個按鈕（登入 和 退出）繫結訊號
# 退出
self.retranslateUi(widget)
self.pushButton_2.clicked.connect(widget.close) # type: ignore
# 登入
self.pushButton.clicked.connect(self.login_in) # type: ignore
self.pushButton.setShortcut('Return')
寫登入訊號槽
# 驗證登入
def login_in(self):
# 全域性變數傳參給其他所有介面
global gl_db
global gl_host
global gl_pwd
global gl_user
global gl_port
gl_db = self.lineEdit_5.text()
gl_host = self.lineEdit_3.text()
gl_pwd = self.lineEdit_2.text()
gl_user = self.lineEdit.text()
try:
port = int(self.lineEdit_4.text())
try:
conn = pymysql.connect(host=gl_host, port=gl_port, db=gl_db, user=gl_user, password=gl_pwd)
print('登入資料庫{}成功'.format(gl_db))
self.messageDialog('提示', '登入資料庫{}成功'.format(gl_db))
conn.close()
del conn
# 登入成功後跳轉到主介面
self.main_show = Fulling()
self.main_show.show()
mainWindow.close()
except pymysql.err.OperationalError:
print('由於目標計算機積極拒絕，無法連線。')
self.messageDialog('警告', '由於目標計算機積極拒絕，無法連線。')
except ValueError:
print('埠號錯誤')
self.messageDialog('警告', '埠號錯誤')
except Exception as err:
print('錯誤：', err)
self.messageDialog('警告', str(err))
# 提示資訊
def messageDialog(self, title, text):
msg_box = QtWidgets.QMessageBox(QtWidgets.QMessageBox.Warning, title, text)
msg_box.exec_()
登入邏輯程式程式碼
class Login(QMainWindow):
def __init__(self):
super().__init__()
self.setFixedSize(600, 400) # 禁止拖動
self.setWindowIcon(QtGui.QIcon('./img/001.ico')) # 設定表單標題圖示
self.setWindowFlags(QtCore.Qt.WindowMinimizeButtonHint) # 禁用最大化
# 背景圖片
image = QtGui.QPixmap()
image.load(r'./img/login_bg.jpg')
bg = QtGui.QPalette()
bg.setBrush(self.backgroundRole(), QtGui.QBrush(image))
self.setPalette(bg)
self.setAutoFillBackground(True)
if __name__ == '__main__':
gl_db = ''
gl_host = ''
gl_pwd = ''
gl_user = ''
gl_port = 0
# 建立 QApplication 類的範例
logapp = QApplication(sys.argv)
# 建立表單
mainWindow = Login()
# 關聯login
ui = Ui_widget()
ui.setupUi(mainWindow)
# 開啟表單
mainWindow.show()
# 退出表單
sys.exit(logapp.exec_())
三、主介面
因為主介面涉及到的控制元件比較複雜，所以直接用程式碼寫出來，不使用 Designer。
1、初始化
- 先給介面初始化，標題，視窗大小，圖示，控制元件，並且連線資料庫
class Fulling(QWidget):
# 初始化
def __init__(self):
super().__init__()
# 視窗標題
self.setWindowTitle('學生管理系統')
# 視窗大小
self.resize(720, 600)
# 視窗居中
self.center()
# 圖示
self.setWindowIcon(QIcon('./img/001.ico'))
# 連線資料庫
self.conn = pymysql.connect(host=gl_host, port=gl_port, user=gl_user, password=gl_pwd, db=gl_db)
self.tree_view = None
self.table_view = None
self.queryModel = None
self.text_edit = None
self.run_button = None
self.row = None
self.vol = None
self.text_browser = None
self.clear_button = None
self.add_db_view = None
self.del_db_view = None
self.cur = self.conn.cursor()
self.init_ui()
# 視窗居中
def center(self):
screen = QDesktopWidget().screenGeometry()
size = self.geometry()
self.move(round((screen.width() - size.width()) / 2), round((screen.height() - size.height()) / 2))
# 警告資訊
@staticmethod
def message_dialog(title, text):
msg_box = QtWidgets.QMessageBox(QtWidgets.QMessageBox.Warning, title, text)
msg_box.exec_()
2、新增控制元件
- 視窗新增控制元件，併為他們佈局
# 視窗佈局
def create_window(self):
# 設定樹屬性
self.tree_view = QTreeWidget()
# 設定表格屬性
self.table_view = QTableWidget()
# 設定文字方塊
self.text_edit = QTextEdit()
# 設定執行按鈕
self.run_button = QPushButton('執行所有程式碼')
# 設定清空按鈕
self.clear_button = QPushButton('清空程式碼')
# 設定檢視文字
self.text_browser = QTextBrowser()
# 表格寬度自適應
self.table_view.horizontalHeader().setStretchLastSection(True)
self.table_view.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)
# 左側佈局
left_layout = QVBoxLayout()
left_layout.addWidget(self.tree_view, 15)
left_layout.addWidget(self.text_browser, 9)
# 右中
mid_layout = QHBoxLayout()
mid_layout.addWidget(self.run_button)
mid_layout.addWidget(self.clear_button)
mid_layout.addWidget(QSplitter())
# 右側佈局
right_layout = QVBoxLayout()
right_layout.addWidget(self.table_view, 15)
right_layout.addLayout(mid_layout, 1)
right_layout.addWidget(self.text_edit, 8)
# 建立介面
layout = QHBoxLayout(self)
layout.addLayout(left_layout, 1)
layout.addLayout(right_layout, 3)
self.setLayout(layout)
3、設定函數與訊號
- 給每個控制元件新增自己的函數和訊號
# 設定視窗主要部件和訊號
def init_ui(self):
# 建立視窗
self.create_window()
# 設定樹
self.set_tree_view()
# 設定表格
self.set_table_view()
# 設定文字方塊
self.set_text_edit()
# 建立執行按鈕
self.set_run_button()
# 建立清空按鈕
self.set_clear_button()
# 建立檢視文字
self.set_text_browser()
# 訊號槽
self.tree_view.clicked.connect(self.on_tree_clicked)
self.run_button.clicked.connect(self.run_program)
self.clear_button.clicked.connect(self.clear_all)
# 給樹新增右鍵
self.tree_view.setContextMenuPolicy(Qt.CustomContextMenu)
self.tree_view.customContextMenuRequested.connect(self.right_menu_show)
# 執行按鈕快捷鍵
self.run_button.setShortcut('F5')
4、樹的函數
- 讓樹能夠顯示所有的資料表
- 本來想的是把所有的資料表、檢視、事件等都顯示出來，但是這裡我只寫了顯示資料表
# 樹
def set_tree_view(self):
# 樹行數
self.tree_view.setColumnCount(1)
# 樹標題
self.tree_view.setHeaderLabel(gl_db + '.db')
# 設定根節點
root = QtWidgets.QTreeWidgetItem(self.tree_view)
root.setText(0, '表') # 只有一列
root.setIcon(0, QIcon('img/db_logo.png'))
# 建立遊標
cursor = self.conn.cursor()
cursor.execute("show tables;")
res = cursor.fetchall()
# 遍歷表
for i in range(len(res)):
child = QtWidgets.QTreeWidgetItem(root) # 指定父目錄
child.setText(0, res[i][0])
child.setText(1, '{}'.format(i + 1))
child.setIcon(0, QIcon('img/table_logo.png'))
# 樹預設收縮
root.setExpanded(False)
# 樹根節點
self.tree_view.addTopLevelItem(root)
- 樹中左鍵單擊展開樹 或 開啟資料表
# 樹左鍵單擊
def on_tree_clicked(self):
try:
# 獲取樹中的內容
item = self.tree_view.currentItem()
# 如果單擊的是根目錄則展開或收縮樹
if item.text(0) == '表':
print('左鍵單擊{}'.format(item.text(0)))
if self.tree_view.currentItem().isExpanded():
self.tree_view.collapseAll()
else:
self.tree_view.expandAll()
# 如果單擊的是表則開啟表
else:
item = self.tree_view.currentItem()
self.cur.execute('select * from ' + item.text(0))
self.select_run()
print('左鍵單擊{}'.format(item.text(0)))
except Exception as e:
print('樹左鍵單擊{}'.format(e))
self.message_dialog('提示', '請先輸入資料')
- 樹中右鍵單擊顯示 右鍵選單選項
# 樹右鍵單擊
def right_menu_show(self):
try:
item = self.tree_view.currentItem()
if item.text(0) == '表':
print('右鍵單擊{}'.format(item.text(0)))
# 新增選單選項
self.contextMenu = QMenu()
self.add_db = self.contextMenu.addAction(u'新建資料表')
self.flash_db = self.contextMenu.addAction(u'重新整理')
self.close_db = self.contextMenu.addAction(u'退出')
self.contextMenu.popup(QCursor.pos())
# 給選單選項繫結訊號
self.add_db.triggered.connect(self.add_database) # type:ignore
self.flash_db.triggered.connect(self.flash) # type:ignore
self.close_db.triggered.connect(self.close_database) # type:ignore
self.contextMenu.show()
else:
# 資料表的右鍵
print('右鍵單擊{},序號是{}'.format(item.text(0), item.text(1)))
self.contextMenu = QMenu()
self.open = self.contextMenu.addAction(u'開啟表')
self.drop = self.contextMenu.addAction(u'刪除表')
self.add = self.contextMenu.addAction(u'新增記錄')
self.delete = self.contextMenu.addAction(u'刪除記錄')
self.update = self.contextMenu.addAction(u'更改記錄')
self.select = self.contextMenu.addAction(u'查詢記錄')
self.open.triggered.connect(self.open_table) # type:ignore
self.drop.triggered.connect(self.drop_table) # type:ignore
self.add.triggered.connect(self.add_table) # type:ignore
self.delete.triggered.connect(self.delete_table) # type:ignore
self.update.triggered.connect(self.update_table) # type:ignore
self.select.triggered.connect(self.select_table) # type:ignore
self.contextMenu.popup(QCursor.pos())
self.contextMenu.show()
except Exception as e:
print(e)
5、右鍵選項訊號槽
- 根目錄的右鍵選單
# 樹重新整理
def flash(self):
"""新增資料表後的重新整理操作"""
print('重新整理')
item = self.tree_view.currentItem()
root = QtWidgets.QTreeWidgetItem(self.tree_view)
root.setText(0, '表') # 只有一列
root.setIcon(0, QIcon('img/db_logo.png'))
cursor = self.conn.cursor()
cursor.execute("show tables;")
res = cursor.fetchall()
# 清除樹
curr_node = self.tree_view.currentItem()
root_index = self.tree_view.indexOfTopLevelItem(curr_node)
self.tree_view.takeTopLevelItem(root_index)
# 再把重新整理獲取的樹放上去
for i in range(len(res)):
child = QtWidgets.QTreeWidgetItem(root) # 指定父目錄
child.setText(0, res[i][0])
child.setText(1, '{}'.format(i + 1))
child.setIcon(0, QIcon('img/table_logo.png'))
# 新建資料表 這裡要用另外的視窗作為對話方塊，在第四點
def add_database(self):
try:
# 開啟對話方塊
self.add_db_view = AdDB()
add_ui = Ui_add_db_object()
add_ui.setupUi(self.add_db_view)
self.add_db_view.show()
except Exception as e:
print(e)
print('新建資料表')
# 退出資料表
def close_database(self):
reply = QMessageBox.question(self, '退出', '確定退出', QMessageBox.Yes | QMessageBox.No, QMessageBox.Yes)
if reply == QMessageBox.Yes:
sender = self.sender()
main_app_db = QApplication.instance()
main_app_db.quit()
print('退出資料表')
- 資料表的右鍵選單，下面四個操作沒有寫完，因為需要新建一個對話方塊
# 右鍵開啟
def open_table(self):
item = self.tree_view.currentItem()
self.cur.execute('select * from ' + item.text(0))
self.select_run()
print('開啟 {}'.format(item.text(0)))
# 右鍵刪除表
def drop_table(self):
item = self.tree_view.currentItem()
reply = QMessageBox.question(self, '刪除表', '確定要刪除嗎？', QMessageBox.Yes | QMessageBox.No, QMessageBox.Yes)
if reply == QMessageBox.Yes:
self.cur.execute('drop table ' + item.text(0))
self.text_browser.append('刪除表 {} 成功，右擊根目錄重新整理'.format(item.text(0)))
print('刪除 {}'.format(item.text(0)))
# TODO 新增記錄
def add_table(self):
self.message_dialog('提示', '功能還沒開發')
print('新增記錄')
# TODO 刪除記錄
def delete_table(self):
try:
self.del_db_view = DelDB()
del_ui = Ui_delete_win()
del_ui.setupUi(self.del_db_view)
self.del_db_view.show()
except Exception as e:
print(e)
print('刪除記錄')
# TODO 更改記錄
def update_table(self):
self.message_dialog('提示', '功能還沒開發')
print('更改記錄')
# TODO 查詢記錄
def select_table(self):
self.message_dialog('提示', '功能還沒開發')
print('查詢記錄')
6、資料表顯示函數
- 定義表格控制元件是用來顯示資料表的
# 表格控制元件
def set_table_view(self):
self.cur.execute('show tables')
db_len = self.cur.fetchone()
self.cur.execute('select * from ' + db_len[0]) # 將資料從資料庫中拿出來
self.select_run()
- 讓所選表的資料顯示在表格控制元件裡
這裡的程式碼參考的是 PyQt實現讀取MySql資料庫表資料將其顯示在TableWidget並儲存為excel表格
# 表格填充內容
def table_data(self, i, j, data):
item = QtWidgets.QTableWidgetItem()
self.table_view.setItem(i, j, item)
item = self.table_view.item(i, j)
item.setText(str(data))
# 執行查詢
def select_run(self):
try:
total = self.cur.fetchall()
col_result = self.cur.description
self.row = self.cur.rowcount # 取得記錄個數，用於設定表格的行數
if self.row == 0:
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('資料表中沒有任何記錄')
else:
self.vol = len(total[0]) # 取得欄位數，用於設定表格的列數
col_result = list(col_result)
a = 0
self.table_view.setColumnCount(self.vol)
self.table_view.setRowCount(self.row)
for i in col_result: # 設定表頭資訊，將mysql資料表中的表頭資訊拿出來，放進TableWidget中
item = QtWidgets.QTableWidgetItem()
self.table_view.setHorizontalHeaderItem(a, item)
item = self.table_view.horizontalHeaderItem(a)
item.setText(i[0])
a = a + 1
total = list(total) # 將資料格式改為列表形式，其是將資料庫中取出的資料整體改為列表形式
for i in range(len(total)): # 將相關的資料
total[i] = list(total[i]) # 將獲取的資料轉為列表形式
for i in range(self.row):
for j in range(self.vol):
self.table_data(i, j, total[i][j])
except Exception as e:
print(e)
7、執行程式碼按鈕訊號槽
- 執行程式碼按鈕需要識別文字方塊內輸入的操作是增、刪、改、查、建立資料表中的哪一個
# 執行按鈕
def run_program(self):
try:
# 獲取填寫的程式碼
text = self.text_edit.toPlainText()
# 刪掉所有的換行
text = text.replace('\n', '')
# 所有程式碼大寫
text = text.upper()
# 不同程式碼分片
texts = text.split(';')
for i in range(len(texts)):
try:
if texts[i][:6] == 'SELECT':
print('執行查詢{}'.format(texts[i]))
self.cur.execute(texts[i]) # 將資料從資料庫中拿出來
self.select_run()
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('查詢{}'.format(texts[i]))
self.row_ref()
elif texts[i][:6] == 'UPDATE':
print('執行更新{}'.format(texts[i]))
self.cur.execute(texts[i]) # 將資料從資料庫中拿出來
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('更新{}'.format(texts[i]))
self.row_ref()
elif texts[i][:6] == 'INSERT':
print('執行插入{}'.format(texts[i]))
self.cur.execute(texts[i]) # 將資料從資料庫中拿出來
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('插入{}'.format(texts[i]))
self.row_ref()
elif texts[i][:6] == 'DELETE':
print('執行刪除{}'.format(texts[i]))
self.cur.execute(texts[i]) # 將資料從資料庫中拿出來
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('刪除{}'.format(texts[i]))
self.row_ref()
elif texts[i][:6] == 'CREATE' and texts[i].find('TABLE') != -1:
print('建立資料表')
self.cur.execute(texts[i]) # 將資料從資料庫中拿出來
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('建立資料表{}'.format(texts[i]))
self.flash()
except Exception as e:
if '1096' in str(e):
print('沒有使用資料庫')
self.message_dialog('沒有使用資料庫', str(e))
elif '1054' in str(e):
print('沒有這個資料庫')
self.message_dialog('沒有這個資料庫', str(e))
elif '1064' in str(e):
print('語法錯誤')
self.message_dialog('語法錯誤', str(e))
else:
print('rr', e)
self.message_dialog('其他錯誤', str(e))
print('run', text)
except Exception as e:
print('e:', e)
- 執行 SQL 語句之後，檢視影響行，把結果列印在富文字瀏覽器中
# 檢視受影響行
def row_ref(self):
cur_count = self.cur.rowcount
if cur_count > 0:
self.conn.commit()
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('執行成功')
else:
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('執行失敗，影響0條記錄')
8、程式碼輸入框
- 顯示初始值
# 文字方塊
def set_text_edit(self):
font = QtGui.QFont()
font.setFamily("Times New Roman")
font.setPointSize(14)
self.text_edit.setFont(font)
self.cur.execute('show tables;')
db_len = self.cur.fetchone()
self.text_edit.setPlaceholderText('SELECT * FROM {};\nGO;\n\n按F5執行程式碼'.format(db_len[0]))
9、清空按鈕與富文字瀏覽器
- 這兩個控制元件比較簡單，按一下清空程式碼按鈕就在富文字瀏覽器中顯示資訊
# 富文字瀏覽器
def set_text_browser(self):
self.text_browser.setPlaceholderText('操作記錄：')
# 清空按鈕
def set_clear_button(self):
pass
# 清空按鈕左鍵
def clear_all(self):
self.text_edit.setText('')
self.text_browser.append('清空程式碼區')
四、新建資料表對話方塊
1、新增控制元件
- 介面簡單，就用 Designer 新增相應控制元件
- 先弄成最多隻能新增三個欄位
2、初始化對話方塊
class Ui_add_db_object(object):
def __init__(self):
super().__init__()
self.conn = pymysql.connect(host=gl_host, port=gl_port, user=gl_user, password=gl_pwd, db=gl_db)
self.cur = self.conn.cursor()
# 警告資訊
@staticmethod
def message_dialog(title, text):
msg_box = QtWidgets.QMessageBox(QtWidgets.QMessageBox.Warning, title, text)
msg_box.exec_()
3、設定控制元件屬性
- 設定字元長度最大值
- 繫結確定按鈕和取消按鈕的訊號
- 新增下拉選項
# 設定字元長度最大值
if self.label_1_comboBox.currentText() == 'char' or 'text' or 'varchar':
self.label_1_spinBox.setMaximum(255)
else:
self.label_1_spinBox.setMaximum(2 ** 20)
if self.label_2_comboBox.currentText() == 'char' or 'text' or 'varchar':
self.label_2_spinBox.setMaximum(255)
else:
self.label_2_spinBox.setMaximum(2 ** 20)
if self.label_3_comboBox.currentText() == 'char' or 'text' or 'varchar':
self.label_3_spinBox.setMaximum(255)
else:
self.label_3_spinBox.setMaximum(2 ** 20)
# 繫結訊號
self.retranslateUi(add_db_object)
self.add_no_pushButton_2.clicked.connect(add_db_object.close) # type: ignore
self.add_yes_pushButton.clicked.connect(lambda: self.add_true(add_db_object)) # type: ignore
QtCore.QMetaObject.connectSlotsByName(add_db_object)
# 新增資料型別下拉選項
item_attribute = ['', 'char', 'int', 'float', 'text', 'varchar']
self.label_1_comboBox.addItems(item_attribute)
self.label_2_comboBox.addItems(item_attribute)
self.label_3_comboBox.addItems(item_attribute)
4、確定按鈕訊號槽
- 按下確定按鈕後，檢查輸入的資料是否符合規範，包括：
(1) 只有一個主鍵
(2) 資料表名和欄位名符合規範
(3) 是否填入了資料
def add_true(self, add_db_object):
try:
# 每個欄位的所有屬性新增進一個列表
label_1 = [self.label_1_lineEdit.text(), self.label_1_comboBox.currentText(), self.label_1_spinBox.text(),
self.label_1_checkBox.isChecked()]
label_2 = [self.label_2_lineEdit.text(), self.label_2_comboBox.currentText(), self.label_2_spinBox.text(),
self.label_2_checkBox.isChecked()]
label_3 = [self.label_3_lineEdit.text(), self.label_3_comboBox.currentText(), self.label_3_spinBox.text(),
self.label_3_checkBox.isChecked()]
print(label_1, label_2, label_3)
add_count = 0
add_item = []
word = r'^\w+$'
# 資料表名必填
if len(self.table_name_lineEdit.text()) == 0:
print(self.table_name_lineEdit.text())
match_tana = re.match(word, self.label_1_lineEdit.text())
self.message_dialog('警告', '資料表名必填')
return
if match_tana is None:
self.message_dialog('警告', '資料表名只能是英文、數位、下劃線')
return
# 主鍵只能有一個
if self.label_1_checkBox.isChecked() and self.label_2_checkBox.isChecked() \
or self.label_1_checkBox.isChecked() and self.label_3_checkBox.isChecked() \
or self.label_2_checkBox.isChecked() and self.label_3_checkBox.isChecked():
print('主鍵只能有一個')
self.message_dialog('警告', '主鍵只能有一個')
return
else:
# 每個欄位的欄位名、欄位型別、欄位長度必填
if "" not in label_1:
print(label_1)
# if len(self.label_1_lineEdit.text()) > 0:
match_1 = re.match(word, self.label_1_lineEdit.text())
if match_1 is None:
self.message_dialog('警告', '欄位名只能是英文、數位、下劃線')
return
# 判斷主鍵是否選上
for i in range(len(label_1) - 1):
add_item.append(label_1[i])
if self.label_1_checkBox.isChecked():
add_item.append('primary key')
else:
add_item.append(' ')
add_count += 1
if "" not in label_2:
print(label_2)
match_2 = re.match(word, self.label_2_lineEdit.text())
if match_2 is None:
self.message_dialog('警告', '欄位名只能是英文、數位、下劃線')
return
for i in range(len(label_2) - 1):
add_item.append(label_2[i])
if self.label_2_checkBox.isChecked():
add_item.append('primary key')
else:
add_item.append(' ')
add_count += 1
if "" not in label_3:
print(label_3)
match_3 = re.match(word, self.label_3_lineEdit.text())
if match_3 is None:
self.message_dialog('警告', '欄位名只能是英文、數位、下劃線')
return
for i in range(len(label_3) - 1):
add_item.append(label_3[i])
if self.label_3_checkBox.isChecked():
add_item.append('primary key')
else:
add_item.append(' ')
add_count += 1
if add_count == 0:
self.message_dialog('警告', '必填欄位名、欄位型別、欄位長度')
return
# 執行 SQL 語句
if len(add_item) == 4:
self.cur.execute(
'create table ' + self.table_name_lineEdit.text() + '(' + add_item[0] + ' ' + add_item[1] + '(' +
add_item[2] + ') ' + add_item[3] + ');')
self.conn.commit()
self.message_dialog('提示', '新增完成，重新整理資料表')
self.cur.close()
add_db_object.close()
elif len(add_item) == 8:
self.cur.execute(
'create table ' + self.table_name_lineEdit.text() + '(' + add_item[0] + ' ' + add_item[1] + '(' +
add_item[2] + ') ' + add_item[3] + ', ' + add_item[4] + ' ' + add_item[5] + '(' + add_item[
6] + ') ' +
add_item[7] + ');')
self.conn.commit()
self.cur.close()
self.message_dialog('提示', '新增完成，重新整理資料表')
add_db_object.close()
elif len(add_item) == 12:
self.cur.execute(
'create table ' + self.table_name_lineEdit.text() + '(' + add_item[0] + ' ' + add_item[1] + '(' +
add_item[2] + ') ' + add_item[3] + ', ' + add_item[4] + ' ' + add_item[5] + '(' + add_item[
6] + ') ' +
add_item[7] + ' , ' + add_item[8] + ' ' + add_item[9] + '(' + add_item[10] + ') ' + add_item[
11] + ');')
self.conn.commit()
self.message_dialog('提示', '新增完成，重新整理資料表')
self.cur.close()
add_db_object.close()
except Exception as e:
self.message_dialog('錯誤', e)
5、連線 UI 表單
class AdDB(QWidget):
def __init__(self):
super().__init__()
self.setFixedSize(441, 511) # 禁止拖動
self.setWindowIcon(QtGui.QIcon('./img/001.ico')) # 設定表單標題圖示
self.setWindowFlags(QtCore.Qt.WindowMinimizeButtonHint) # 禁用最大化
五、刪除記錄對話方塊
- 只建立了一個表單，沒有操作程式碼
class Ui_delete_win(object):
def __init__(self):
super().__init__()
self.conn = pymysql.connect(host=gl_host, port=gl_port, user=gl_user, password=gl_pwd, db=gl_db)
self.cur = self.conn.cursor()
def setupUi(self, delete_win):
delete_win.setObjectName("delete_win")
delete_win.resize(400, 260)
self.delete_yes = QtWidgets.QPushButton(delete_win)
self.delete_yes.setGeometry(QtCore.QRect(80, 200, 81, 31))
self.delete_yes.setObjectName("delete_yes")
self.delete_no = QtWidgets.QPushButton(delete_win)
self.delete_no.setGeometry(QtCore.QRect(220, 200, 81, 31))
self.delete_no.setObjectName("delete_no")
self.delete_header = QtWidgets.QTextBrowser(delete_win)
self.delete_header.setGeometry(QtCore.QRect(120, 20, 171, 31))
self.delete_header.setObjectName("delete_header")
self.widget = QtWidgets.QWidget(delete_win)
self.widget.setGeometry(QtCore.QRect(40, 70, 331, 111))
self.widget.setObjectName("widget")
self.gridLayout = QtWidgets.QGridLayout(self.widget)
self.gridLayout.setContentsMargins(0, 0, 0, 0)
self.gridLayout.setObjectName("gridLayout")
self.delete_where_vue3 = QtWidgets.QLineEdit(self.widget)
self.delete_where_vue3.setObjectName("delete_where_vue3")
self.gridLayout.addWidget(self.delete_where_vue3, 2, 2, 1, 1)
self.delete_where_vue2 = QtWidgets.QLineEdit(self.widget)
self.delete_where_vue2.setObjectName("delete_where_vue2")
self.gridLayout.addWidget(self.delete_where_vue2, 1, 2, 1, 1)
self.delete_where_item3 = QtWidgets.QComboBox(self.widget)
self.delete_where_item3.setObjectName("delete_where_item3")
self.gridLayout.addWidget(self.delete_where_item3, 2, 1, 1, 1)
self.delete_where = QtWidgets.QLabel(self.widget)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Preferred)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(3)
sizePolicy.setHeightForWidth(self.delete_where.sizePolicy().hasHeightForWidth())
self.delete_where.setSizePolicy(sizePolicy)
self.delete_where.setObjectName("delete_where")
self.gridLayout.addWidget(self.delete_where, 0, 0, 1, 1)
self.delete_where_vue1 = QtWidgets.QLineEdit(self.widget)
self.delete_where_vue1.setObjectName("delete_where_vue1")
self.gridLayout.addWidget(self.delete_where_vue1, 0, 2, 1, 1)
self.delete_where_item2 = QtWidgets.QComboBox(self.widget)
self.delete_where_item2.setObjectName("delete_where_item2")
self.gridLayout.addWidget(self.delete_where_item2, 1, 1, 1, 1)
self.delete_where_item1 = QtWidgets.QComboBox(self.widget)
self.delete_where_item1.setObjectName("delete_where_item1")
self.gridLayout.addWidget(self.delete_where_item1, 0, 1, 1, 1)
self.delete_and = QtWidgets.QLabel(self.widget)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Preferred)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(3)
sizePolicy.setHeightForWidth(self.delete_and.sizePolicy().hasHeightForWidth())
self.delete_and.setSizePolicy(sizePolicy)
self.delete_and.setObjectName("delete_and")
self.gridLayout.addWidget(self.delete_and, 1, 0, 1, 1)
self.delete_and_2 = QtWidgets.QLabel(self.widget)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Preferred)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(3)
sizePolicy.setHeightForWidth(self.delete_and_2.sizePolicy().hasHeightForWidth())
self.delete_and_2.setSizePolicy(sizePolicy)
self.delete_and_2.setObjectName("delete_and_2")
self.gridLayout.addWidget(self.delete_and_2, 2, 0, 1, 1)
self.retranslateUi(delete_win)
self.delete_no.clicked.connect(delete_win.close) # type: ignore
QtCore.QMetaObject.connectSlotsByName(delete_win)
self.delete_yes.clicked.connect(lambda: self.delete_fun()) # type: ignore
delete_win.setTabOrder(self.delete_header, self.delete_where_item1)
delete_win.setTabOrder(self.delete_where_item1, self.delete_where_vue1)
delete_win.setTabOrder(self.delete_where_vue1, self.delete_where_item2)
delete_win.setTabOrder(self.delete_where_item2, self.delete_where_vue2)
delete_win.setTabOrder(self.delete_where_vue2, self.delete_where_item3)
delete_win.setTabOrder(self.delete_where_item3, self.delete_where_vue3)
delete_win.setTabOrder(self.delete_where_vue3, self.delete_yes)
delete_win.setTabOrder(self.delete_yes, self.delete_no)
# TODO 刪除記錄
def delete_fun(self):
print('555')
def retranslateUi(self, delete_win):
_translate = QtCore.QCoreApplication.translate
delete_win.setWindowTitle(_translate("delete_win", "刪除記錄"))
self.delete_yes.setText(_translate("delete_win", "確定"))
self.delete_no.setText(_translate("delete_win", "取消"))
self.delete_where.setText(_translate("delete_win", "where"))
self.delete_and.setText(_translate("delete_win", "and"))
self.delete_and_2.setText(_translate("delete_win", "and"))
class DelDB(QWidget):
def __init__(self):
super().__init__()
self.setFixedSize(400, 260) # 禁止拖動
self.setWindowIcon(QtGui.QIcon('./img/001.ico')) # 設定表單標題圖示
self.setWindowFlags(QtCore.Qt.WindowMinimizeButtonHint) # 禁用最大化
六、全部程式碼
#!/bin/sh
# !/usr/bin/python
# !/usr/bin/env
# -*- coding: utf-8 -*-
"""
Author: Fulling
Function: 學生管理系統
Date: 2021-12-31
"""
import sys
import pymysql
import re
from PyQt5 import QtGui, QtWidgets, QtCore
from PyQt5.Qt import *
class Fulling(QWidget):
def __init__(self):
super().__init__()
# 視窗標題
self.setWindowTitle('學生管理系統')
# 視窗大小
self.resize(720, 600)
# 視窗居中
self.center()
# 圖示
self.setWindowIcon(QIcon('./img/001.ico'))
# 連線資料庫
self.conn = pymysql.connect(host=gl_host, port=gl_port, user=gl_user, password=gl_pwd, db=gl_db)
self.tree_view = None
self.table_view = None
self.queryModel = None
self.text_edit = None
self.run_button = None
self.row = None
self.vol = None
self.text_browser = None
self.clear_button = None
self.add_db_view = None
self.del_db_view = None
self.cur = self.conn.cursor()
self.init_ui()
# 設定視窗主要部件和訊號
def init_ui(self):
# 建立視窗
self.create_window()
# 設定樹
self.set_tree_view()
# 設定表格
self.set_table_view()
# 設定文字方塊
self.set_text_edit()
# 建立執行按鈕
self.set_run_button()
# 建立清空按鈕
self.set_clear_button()
# 建立檢視文字
self.set_text_browser()
# TODO 訊號槽
self.tree_view.clicked.connect(self.on_tree_clicked)
self.run_button.clicked.connect(self.run_program)
self.clear_button.clicked.connect(self.clear_all)
# 右鍵
self.tree_view.setContextMenuPolicy(Qt.CustomContextMenu)
self.tree_view.customContextMenuRequested.connect(self.right_menu_show)
# self.text_edit.setContextMenuPolicy(Qt.CustomContextMenu)
# self.text_edit.customContextMenuRequested[QtCore.QPoint].connect(self.text_right_menu)
# 快捷鍵
self.run_button.setShortcut('F5')
# 視窗居中
def center(self):
"""
視窗居中
:return:
"""
screen = QDesktopWidget().screenGeometry()
size = self.geometry()
self.move(round((screen.width() - size.width()) / 2), round((screen.height() - size.height()) / 2))
# 視窗佈局
def create_window(self):
# 設定樹屬性
self.tree_view = QTreeWidget()
# 設定表格屬性
self.table_view = QTableWidget()
# 設定文字方塊
self.text_edit = QTextEdit()
# 設定執行按鈕
self.run_button = QPushButton('執行所有程式碼')
# 設定清空按鈕
self.clear_button = QPushButton('清空程式碼')
# 設定檢視文字
self.text_browser = QTextBrowser()
# 表格寬度自適應
self.table_view.horizontalHeader().setStretchLastSection(True)
self.table_view.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)
# 左側佈局
left_layout = QVBoxLayout()
left_layout.addWidget(self.tree_view, 15)
left_layout.addWidget(self.text_browser, 9)
# 右中
mid_layout = QHBoxLayout()
mid_layout.addWidget(self.run_button)
mid_layout.addWidget(self.clear_button)
mid_layout.addWidget(QSplitter())
# 右側佈局
right_layout = QVBoxLayout()
right_layout.addWidget(self.table_view, 15)
right_layout.addLayout(mid_layout, 1)
right_layout.addWidget(self.text_edit, 8)
# 建立介面
layout = QHBoxLayout(self)
layout.addLayout(left_layout, 1)
layout.addLayout(right_layout, 3)
self.setLayout(layout)
# 表格填充內容
def table_data(self, i, j, data):
item = QtWidgets.QTableWidgetItem()
self.table_view.setItem(i, j, item)
item = self.table_view.item(i, j)
item.setText(str(data))
# 執行查詢
def select_run(self):
try:
total = self.cur.fetchall()
col_result = self.cur.description
self.row = self.cur.rowcount # 取得記錄個數，用於設定表格的行數
if self.row == 0:
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('資料表中沒有任何記錄')
else:
self.vol = len(total[0]) # 取得欄位數，用於設定表格的列數
col_result = list(col_result)
a = 0
self.table_view.setColumnCount(self.vol)
self.table_view.setRowCount(self.row)
for i in col_result: # 設定表頭資訊，將mysql資料表中的表頭資訊拿出來，放進TableWidget中
item = QtWidgets.QTableWidgetItem()
self.table_view.setHorizontalHeaderItem(a, item)
item = self.table_view.horizontalHeaderItem(a)
item.setText(i[0])
a = a + 1
total = list(total) # 將資料格式改為列表形式，其是將資料庫中取出的資料整體改為列表形式
for i in range(len(total)): # 將相關的資料
total[i] = list(total[i]) # 將獲取的資料轉為列表形式
for i in range(self.row):
for j in range(self.vol):
self.table_data(i, j, total[i][j])
except Exception as e:
print(e)
# 表格
def set_table_view(self):
self.cur.execute('show tables')
db_len = self.cur.fetchone()
self.cur.execute('select * from ' + db_len[0]) # 將資料從資料庫中拿出來
self.select_run()
# 樹
def set_tree_view(self):
# 樹行數
self.tree_view.setColumnCount(1)
# 樹標題
self.tree_view.setHeaderLabel(gl_db + '.db')
# 設定根節點
root = QtWidgets.QTreeWidgetItem(self.tree_view)
root.setText(0, '表') # 只有一列
root.setIcon(0, QIcon('img/db_logo.png'))
# 建立遊標
cursor = self.conn.cursor()
cursor.execute("show tables;")
res = cursor.fetchall()
# 遍歷表
for i in range(len(res)):
child = QtWidgets.QTreeWidgetItem(root) # 指定父目錄
child.setText(0, res[i][0])
child.setText(1, '{}'.format(i + 1))
child.setIcon(0, QIcon('img/table_logo.png'))
# 樹預設收縮
root.setExpanded(False)
# 樹根節點
self.tree_view.addTopLevelItem(root)
# 文字方塊
def set_text_edit(self):
font = QtGui.QFont()
font.setFamily("Times New Roman")
font.setPointSize(14)
self.text_edit.setFont(font)
self.cur.execute('show tables;')
db_len = self.cur.fetchone()
self.text_edit.setPlaceholderText('SELECT * FROM {};\nGO;\n\n按F5執行程式碼'.format(db_len[0]))
# 文字瀏覽
def set_text_browser(self):
self.text_browser.setPlaceholderText('操作記錄：')
# 清空按鈕
def set_clear_button(self):
pass
# 清空按鈕左鍵
def clear_all(self):
self.text_edit.setText('')
self.text_browser.append('清空程式碼區')
# 警告資訊
@staticmethod
def message_dialog(title, text):
msg_box = QtWidgets.QMessageBox(QtWidgets.QMessageBox.Warning, title, text)
msg_box.exec_()
# 查詢影響行
def row_ref(self):
cur_count = self.cur.rowcount
if cur_count > 0:
self.conn.commit()
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('執行成功')
else:
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('執行失敗，影響0條記錄')
# 執行按鈕樣式
def set_run_button(self):
pass
# 執行左鍵
def run_program(self):
try:
# 獲取填寫的程式碼
text = self.text_edit.toPlainText()
# 刪掉所有的換行
text = text.replace('\n', '')
# 所有程式碼大寫
text = text.upper()
# 不同程式碼分片
texts = text.split(';')
for i in range(len(texts)):
try:
if texts[i][:6] == 'SELECT':
print('執行查詢{}'.format(texts[i]))
self.cur.execute(texts[i]) # 將資料從資料庫中拿出來
self.select_run()
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('查詢{}'.format(texts[i]))
self.row_ref()
elif texts[i][:6] == 'UPDATE':
print('執行更新{}'.format(texts[i]))
self.cur.execute(texts[i]) # 將資料從資料庫中拿出來
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('更新{}'.format(texts[i]))
self.row_ref()
elif texts[i][:6] == 'INSERT':
print('執行插入{}'.format(texts[i]))
self.cur.execute(texts[i]) # 將資料從資料庫中拿出來
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('插入{}'.format(texts[i]))
self.row_ref()
elif texts[i][:6] == 'DELETE':
print('執行刪除{}'.format(texts[i]))
self.cur.execute(texts[i]) # 將資料從資料庫中拿出來
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('刪除{}'.format(texts[i]))
self.row_ref()
elif texts[i][:6] == 'CREATE' and texts[i].find('TABLE') != -1:
print('建立資料表')
self.cur.execute(texts[i]) # 將資料從資料庫中拿出來
self.text_browser.moveCursor(QTextCursor.End)
self.text_browser.append('建立資料表{}'.format(texts[i]))
self.flash()
except Exception as e:
if '1096' in str(e):
print('沒有使用資料庫')
self.message_dialog('沒有使用資料庫', str(e))
elif '1054' in str(e):
print('沒有這個資料庫')
self.message_dialog('沒有這個資料庫', str(e))
elif '1064' in str(e):
print('語法錯誤')
self.message_dialog('語法錯誤', str(e))
else:
print('rr', e)
self.message_dialog('其他錯誤', str(e))
print('run', text)
except Exception as e:
print('e:', e)
# 樹左鍵單擊
def on_tree_clicked(self):
"""
樹左鍵單擊
:return:
"""
try:
item = self.tree_view.currentItem()
if item.text(0) == '表':
print('左鍵單擊{}'.format(item.text(0)))
if self.tree_view.currentItem().isExpanded():
self.tree_view.collapseAll()
else:
self.tree_view.expandAll()
else:
# 資料表操作
item = self.tree_view.currentItem()
self.cur.execute('select * from ' + item.text(0))
self.select_run()
print('左鍵單擊{}'.format(item.text(0)))
except Exception as e:
print('樹左鍵單擊{}'.format(e))
self.message_dialog('提示', '請先輸入資料')
# 樹右鍵單擊
def right_menu_show(self):
"""
樹右鍵單擊
:return:
"""
try:
item = self.tree_view.currentItem()
if item.text(0) == '表':
print('右鍵單擊{}'.format(item.text(0)))
self.contextMenu = QMenu()
self.add_db = self.contextMenu.addAction(u'新建資料表')
self.flash_db = self.contextMenu.addAction(u'重新整理')
self.close_db = self.contextMenu.addAction(u'退出')
self.contextMenu.popup(QCursor.pos())
self.add_db.triggered.connect(self.add_database) # type:ignore
self.flash_db.triggered.connect(self.flash) # type:ignore
self.close_db.triggered.connect(self.close_database) # type:ignore
self.contextMenu.show()
# elif id(item.parent()) == tree_root_id:
else:
# TODO 資料表的右鍵
print('右鍵單擊{},序號是{}'.format(item.text(0), item.text(1)))
self.contextMenu = QMenu()
self.open = self.contextMenu.addAction(u'開啟表')
self.drop = self.contextMenu.addAction(u'刪除表')
self.add = self.contextMenu.addAction(u'新增記錄')
self.delete = self.contextMenu.addAction(u'刪除記錄')
self.update = self.contextMenu.addAction(u'更改記錄')
self.select = self.contextMenu.addAction(u'查詢記錄')
self.open.triggered.connect(self.open_table) # type:ignore
self.drop.triggered.connect(self.drop_table) # type:ignore
self.add.triggered.connect(self.add_table) # type:ignore
self.delete.triggered.connect(self.delete_table) # type:ignore
self.update.triggered.connect(self.update_table) # type:ignore
self.select.triggered.connect(self.select_table) # type:ignore
self.contextMenu.popup(QCursor.pos())
self.contextMenu.show()
except Exception as e:
print(e)
# TODO 文字右鍵
def text_right_menu(self):
pass
# 樹重新整理
def flash(self):
"""
新增資料表後的重新整理操作
:return:
"""
print('重新整理')
item = self.tree_view.currentItem()
root = QtWidgets.QTreeWidgetItem(self.tree_view)
root.setText(0, '表') # 只有一列
root.setIcon(0, QIcon('img/db_logo.png'))
cursor = self.conn.cursor()
cursor.execute("show tables;")
res = cursor.fetchall()
# 清除樹
curr_node = self.tree_view.currentItem()
root_index = self.tree_view.indexOfTopLevelItem(curr_node)
self.tree_view.takeTopLevelItem(root_index)
for i in range(len(res)):
child = QtWidgets.QTreeWidgetItem(root) # 指定父目錄
child.setText(0, res[i][0])
child.setText(1, '{}'.format(i + 1))
child.setIcon(0, QIcon('img/table_logo.png'))
# 新建資料表
def add_database(self):
try:
self.add_db_view = AdDB()
add_ui = Ui_add_db_object()
add_ui.setupUi(self.add_db_view)
self.add_db_view.show()
except Exception as e:
print(e)
print('新建資料表')
# 退出資料表
def close_database(self):
reply = QMessageBox.question(self, '退出', '確定退出', QMessageBox.Yes | QMessageBox.No, QMessageBox.Yes)
if reply == QMessageBox.Yes:
sender = self.sender()
main_app_db = QApplication.instance()
main_app_db.quit()
print('退出資料表')
# 右鍵開啟
def open_table(self):
item = self.tree_view.currentItem()
self.cur.execute('select * from ' + item.text(0))
self.select_run()
print('開啟 {}'.format(item.text(0)))
# 右鍵刪除表
def drop_table(self):
item = self.tree_view.currentItem()
reply = QMessageBox.question(self, '刪除表', '確定要刪除嗎？', QMessageBox.Yes | QMessageBox.No, QMessageBox.Yes)
if reply == QMessageBox.Yes:
self.cur.execute('drop table ' + item.text(0))
self.text_browser.append('刪除表 {} 成功，右擊根目錄重新整理'.format(item.text(0)))
print('刪除 {}'.format(item.text(0)))
# TODO 新增記錄
def add_table(self):
self.message_dialog('提示', '功能還沒開發')
print('新增記錄')
# TODO 刪除記錄
def delete_table(self):
try:
self.del_db_view = DelDB()
del_ui = Ui_delete_win()
del_ui.setupUi(self.del_db_view)
self.del_db_view.show()
except Exception as e:
print(e)
print('刪除記錄')
# TODO 更改記錄
def update_table(self):
self.message_dialog('提示', '功能還沒開發')
print('更改記錄')
# TODO 查詢記錄
def select_table(self):
self.message_dialog('提示', '功能還沒開發')
print('查詢記錄')
class Ui_add_db_object(object):
def __init__(self):
super().__init__()
self.conn = pymysql.connect(host=gl_host, port=gl_port, user=gl_user, password=gl_pwd, db=gl_db)
self.cur = self.conn.cursor()
def setupUi(self, add_db_object):
add_db_object.setObjectName("add_db_object")
add_db_object.setEnabled(True)
add_db_object.resize(441, 511)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Fixed, QtWidgets.QSizePolicy.Fixed)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(add_db_object.sizePolicy().hasHeightForWidth())
add_db_object.setSizePolicy(sizePolicy)
add_db_object.setMaximumSize(QtCore.QSize(500, 600))
add_db_object.setWindowTitle("Form")
self.gridLayoutWidget = QtWidgets.QWidget(add_db_object)
self.gridLayoutWidget.setGeometry(QtCore.QRect(10, 20, 421, 431))
self.gridLayoutWidget.setObjectName("gridLayoutWidget")
self.gridLayout = QtWidgets.QGridLayout(self.gridLayoutWidget)
self.gridLayout.setContentsMargins(0, 0, 0, 0)
self.gridLayout.setObjectName("gridLayout")
self.label_1_len = QtWidgets.QLabel(self.gridLayoutWidget)
self.label_1_len.setObjectName("label_1_len")
self.gridLayout.addWidget(self.label_1_len, 4, 1, 1, 1)
self.label_2_checkBox = QtWidgets.QCheckBox(self.gridLayoutWidget)
self.label_2_checkBox.setObjectName("label_2_checkBox")
self.gridLayout.addWidget(self.label_2_checkBox, 10, 1, 1, 2)
self.label_10 = QtWidgets.QLabel(self.gridLayoutWidget)
self.label_10.setObjectName("label_10")
self.gridLayout.addWidget(self.label_10, 8, 1, 1, 1)
self.label_1_attribute = QtWidgets.QLabel(self.gridLayoutWidget)
self.label_1_attribute.setObjectName("label_1_attribute")
self.gridLayout.addWidget(self.label_1_attribute, 3, 1, 1, 1)
self.label_2 = QtWidgets.QLabel(self.gridLayoutWidget)
self.label_2.setObjectName("label_2")
self.gridLayout.addWidget(self.label_2, 6, 1, 1, 2)
self.label_3_comboBox = QtWidgets.QComboBox(self.gridLayoutWidget)
self.label_3_comboBox.setObjectName("label_3_comboBox")
self.gridLayout.addWidget(self.label_3_comboBox, 13, 2, 1, 1)
self.label_2_comboBox = QtWidgets.QComboBox(self.gridLayoutWidget)
self.label_2_comboBox.setObjectName("label_2_comboBox")
self.gridLayout.addWidget(self.label_2_comboBox, 8, 2, 1, 1)
self.label_2_spinBox = QtWidgets.QSpinBox(self.gridLayoutWidget)
self.label_2_spinBox.setObjectName("label_2_spinBox")
self.gridLayout.addWidget(self.label_2_spinBox, 9, 2, 1, 1)
self.label_1_lineEdit = QtWidgets.QLineEdit(self.gridLayoutWidget)
self.label_1_lineEdit.setObjectName("label_1_lineEdit")
self.gridLayout.addWidget(self.label_1_lineEdit, 2, 2, 1, 1)
self.label_2_len = QtWidgets.QLabel(self.gridLayoutWidget)
self.label_2_len.setObjectName("label_2_len")
self.gridLayout.addWidget(self.label_2_len, 9, 1, 1, 1)
self.label_2_lineEdit = QtWidgets.QLineEdit(self.gridLayoutWidget)
self.label_2_lineEdit.setObjectName("label_2_lineEdit")
self.gridLayout.addWidget(self.label_2_lineEdit, 7, 2, 1, 1)
self.label_3_spinBox = QtWidgets.QSpinBox(self.gridLayoutWidget)
self.label_3_spinBox.setObjectName("label_3_spinBox")
self.gridLayout.addWidget(self.label_3_spinBox, 14, 2, 1, 1)
self.label_3_name = QtWidgets.QLabel(self.gridLayoutWidget)
self.label_3_name.setObjectName("label_3_name")
self.gridLayout.addWidget(self.label_3_name, 12, 1, 1, 1)
self.label_3_checkBox = QtWidgets.QCheckBox(self.gridLayoutWidget)
self.label_3_checkBox.setObjectName("label_3_checkBox")
self.gridLayout.addWidget(self.label_3_checkBox, 15, 1, 1, 2)
self.label_3_lineEdit = QtWidgets.QLineEdit(self.gridLayoutWidget)
self.label_3_lineEdit.setObjectName("label_3_lineEdit")
self.gridLayout.addWidget(self.label_3_lineEdit, 12, 2, 1, 1)
self.label_6 = QtWidgets.QLabel(self.gridLayoutWidget)
self.label_6.setObjectName("label_6")
self.gridLayout.addWidget(self.label_6, 13, 1, 1, 1)
self.label_3_len = QtWidgets.QLabel(self.gridLayoutWidget)
self.label_3_len.setObjectName("label_3_len")
self.gridLayout.addWidget(self.label_3_len, 14, 1, 1, 1)
self.label_1 = QtWidgets.QLabel(self.gridLayoutWidget)
self.label_1.setObjectName("label_1")
self.gridLayout.addWidget(self.label_1, 1, 1, 1, 2)
self.label_3 = QtWidgets.QLabel(self.gridLayoutWidget)
self.label_3.setObjectName("label_3")
self.gridLayout.addWidget(self.label_3, 11, 1, 1, 2)
self.label_1_spinBox = QtWidgets.QSpinBox(self.gridLayoutWidget)
self.label_1_spinBox.setObjectName("label_1_spinBox")
self.gridLayout.addWidget(self.label_1_spinBox, 4, 2, 1, 1)
self.label_1_comboBox = QtWidgets.QComboBox(self.gridLayoutWidget)
self.label_1_comboBox.setMaximumSize(QtCore.QSize(16777211, 16777215))
self.label_1_comboBox.setObjectName("label_1_comboBox")
self.gridLayout.addWidget(self.label_1_comboBox, 3, 2, 1, 1)
self.label_1_name = QtWidgets.QLabel(self.gridLayoutWidget)
self.label_1_name.setObjectName("label_1_name")
self.gridLayout.addWidget(self.label_1_name, 2, 1, 1, 1)
self.label_1_checkBox = QtWidgets.QCheckBox(self.gridLayoutWidget)
self.label_1_checkBox.setObjectName("label_1_checkBox")
self.gridLayout.addWidget(self.label_1_checkBox, 5, 1, 1, 2)
self.label_2_name = QtWidgets.QLabel(self.gridLayoutWidget)
self.label_2_name.setObjectName("label_2_name")
self.gridLayout.addWidget(self.label_2_name, 7, 1, 1, 1)
self.table_name_label = QtWidgets.QLabel(self.gridLayoutWidget)
self.table_name_label.setObjectName("table_name_label")
self.gridLayout.addWidget(self.table_name_label, 0, 1, 1, 1)
self.table_name_lineEdit = QtWidgets.QLineEdit(self.gridLayoutWidget)
self.table_name_lineEdit.setObjectName("table_name_lineEdit")
self.gridLayout.addWidget(self.table_name_lineEdit, 0, 2, 1, 1)
self.add_yes_pushButton = QtWidgets.QPushButton(add_db_object)
self.add_yes_pushButton.setGeometry(QtCore.QRect(90, 460, 91, 31))
self.add_yes_pushButton.setObjectName("add_yes_pushButton")
self.add_no_pushButton_2 = QtWidgets.QPushButton(add_db_object)
self.add_no_pushButton_2.setGeometry(QtCore.QRect(230, 460, 91, 31))
self.add_no_pushButton_2.setObjectName("add_no_pushButton_2")
add_db_object.setTabOrder(self.table_name_lineEdit, self.label_1_lineEdit)
add_db_object.setTabOrder(self.label_1_lineEdit, self.label_1_comboBox)
add_db_object.setTabOrder(self.label_1_comboBox, self.label_1_spinBox)
add_db_object.setTabOrder(self.label_1_spinBox, self.label_1_checkBox)
add_db_object.setTabOrder(self.label_1_checkBox, self.label_2_lineEdit)
add_db_object.setTabOrder(self.label_2_lineEdit, self.label_2_comboBox)
add_db_object.setTabOrder(self.label_2_comboBox, self.label_2_spinBox)
add_db_object.setTabOrder(self.label_2_spinBox, self.label_2_checkBox)
add_db_object.setTabOrder(self.label_2_checkBox, self.label_3_lineEdit)
add_db_object.setTabOrder(self.label_3_lineEdit, self.label_3_comboBox)
add_db_object.setTabOrder(self.label_3_comboBox, self.label_3_spinBox)
add_db_object.setTabOrder(self.label_3_spinBox, self.label_3_checkBox)
add_db_object.setTabOrder(self.label_3_checkBox, self.add_yes_pushButton)
add_db_object.setTabOrder(self.add_yes_pushButton, self.add_no_pushButton_2)
if self.label_1_comboBox.currentText() == 'char' or 'text' or 'varchar':
self.label_1_spinBox.setMaximum(255)
else:
self.label_1_spinBox.setMaximum(2 ** 20)
if self.label_2_comboBox.currentText() == 'char' or 'text' or 'varchar':
self.label_2_spinBox.setMaximum(255)
else:
self.label_2_spinBox.setMaximum(2 ** 20)
if self.label_3_comboBox.currentText() == 'char' or 'text' or 'varchar':
self.label_3_spinBox.setMaximum(255)
else:
self.label_3_spinBox.setMaximum(2 ** 20)
self.retranslateUi(add_db_object)
self.add_no_pushButton_2.clicked.connect(add_db_object.close) # type: ignore
self.add_yes_pushButton.clicked.connect(lambda: self.add_true(add_db_object)) # type: ignore
QtCore.QMetaObject.connectSlotsByName(add_db_object)
item_attribute = ['', 'char', 'int', 'float', 'text', 'varchar']
self.label_1_comboBox.addItems(item_attribute)
self.label_2_comboBox.addItems(item_attribute)
self.label_3_comboBox.addItems(item_attribute)
# 警告資訊
@staticmethod
def message_dialog(title, text):
msg_box = QtWidgets.QMessageBox(QtWidgets.QMessageBox.Warning, title, text)
msg_box.exec_()
def add_true(self, add_db_object):
try:
label_1 = [self.label_1_lineEdit.text(), self.label_1_comboBox.currentText(), self.label_1_spinBox.text(),
self.label_1_checkBox.isChecked()]
label_2 = [self.label_2_lineEdit.text(), self.label_2_comboBox.currentText(), self.label_2_spinBox.text(),
self.label_2_checkBox.isChecked()]
label_3 = [self.label_3_lineEdit.text(), self.label_3_comboBox.currentText(), self.label_3_spinBox.text(),
self.label_3_checkBox.isChecked()]
print(label_1, label_2, label_3)
add_count = 0
add_item = []
word = r'^\w+$'
if len(self.table_name_lineEdit.text()) == 0:
print(self.table_name_lineEdit.text())
match_tana = re.match(word, self.label_1_lineEdit.text())
self.message_dialog('警告', '資料表名必填')
return
if match_tana is None:
self.message_dialog('警告', '資料表名只能是英文、數位、下劃線')
return
if self.label_1_checkBox.isChecked() and self.label_2_checkBox.isChecked() \
or self.label_1_checkBox.isChecked() and self.label_3_checkBox.isChecked() \
or self.label_2_checkBox.isChecked() and self.label_3_checkBox.isChecked():
print('主鍵只能有一個')
self.message_dialog('警告', '主鍵只能有一個')
return
else:
if "" not in label_1:
print(label_1)
# if len(self.label_1_lineEdit.text()) > 0:
match_1 = re.match(word, self.label_1_lineEdit.text())
if match_1 is None:
self.message_dialog('警告', '欄位名只能是英文、數位、下劃線')
return
for i in range(len(label_1) - 1):
add_item.append(label_1[i])
if self.label_1_checkBox.isChecked():
add_item.append('primary key')
else:
add_item.append(' ')
add_count += 1
if "" not in label_2:
print(label_2)
match_2 = re.match(word, self.label_2_lineEdit.text())
if match_2 is None:
self.message_dialog('警告', '欄位名只能是英文、數位、下劃線')
return
for i in range(len(label_2) - 1):
add_item.append(label_2[i])
if self.label_2_checkBox.isChecked():
add_item.append('primary key')
else:
add_item.append(' ')
add_count += 1
if "" not in label_3:
print(label_3)
match_3 = re.match(word, self.label_3_lineEdit.text())
if match_3 is None:
self.message_dialog('警告', '欄位名只能是英文、數位、下劃線')
return
for i in range(len(label_3) - 1):
add_item.append(label_3[i])
if self.label_3_checkBox.isChecked():
add_item.append('primary key')
else:
add_item.append(' ')
add_count += 1
if add_count == 0:
self.message_dialog('警告', '必填欄位名、欄位型別、欄位長度')
return
if len(add_item) == 4:
self.cur.execute(
'create table ' + self.table_name_lineEdit.text() + '(' + add_item[0] + ' ' + add_item[1] + '(' +
add_item[2] + ') ' + add_item[3] + ');')
self.conn.commit()
self.message_dialog('提示', '新增完成，重新整理資料表')
self.cur.close()
add_db_object.close()
elif len(add_item) == 8:
self.cur.execute(
'create table ' + self.table_name_lineEdit.text() + '(' + add_item[0] + ' ' + add_item[1] + '(' +
add_item[2] + ') ' + add_item[3] + ', ' + add_item[4] + ' ' + add_item[5] + '(' + add_item[
6] + ') ' +
add_item[7] + ');')
self.conn.commit()
self.cur.close()
self.message_dialog('提示', '新增完成，重新整理資料表')
add_db_object.close()
elif len(add_item) == 12:
self.cur.execute(
'create table ' + self.table_name_lineEdit.text() + '(' + add_item[0] + ' ' + add_item[1] + '(' +
add_item[2] + ') ' + add_item[3] + ', ' + add_item[4] + ' ' + add_item[5] + '(' + add_item[
6] + ') ' +
add_item[7] + ' , ' + add_item[8] + ' ' + add_item[9] + '(' + add_item[10] + ') ' + add_item[
11] + ');')
self.conn.commit()
self.message_dialog('提示', '新增完成，重新整理資料表')
self.cur.close()
add_db_object.close()
except Exception as e:
self.message_dialog('錯誤', e)
def retranslateUi(self, add_db_object):
_translate = QtCore.QCoreApplication.translate
self.label_1_len.setText(_translate("add_db_object", "欄位長度"))
self.label_2_checkBox.setText(_translate("add_db_object", "設為主鍵"))
self.label_10.setText(_translate("add_db_object", "欄位屬性"))
self.label_1_attribute.setText(_translate("add_db_object", "欄位屬性"))
self.label_2.setText(_translate("add_db_object", "欄位2"))
self.label_2_len.setText(_translate("add_db_object", "欄位長度"))
self.label_3_name.setText(_translate("add_db_object", "欄位名"))
self.label_3_checkBox.setText(_translate("add_db_object", "設為主鍵"))
self.label_6.setText(_translate("add_db_object", "欄位屬性"))
self.label_3_len.setText(_translate("add_db_object", "欄位長度"))
self.label_1.setText(_translate("add_db_object", "欄位1"))
self.label_3.setText(_translate("add_db_object", "欄位3"))
self.label_1_name.setText(_translate("add_db_object", "欄位名"))
self.label_1_checkBox.setText(_translate("add_db_object", "設為主鍵"))
self.label_2_name.setText(_translate("add_db_object", "欄位名"))
self.table_name_label.setText(_translate("add_db_object", "資料表名"))
self.add_yes_pushButton.setText(_translate("add_db_object", "確定"))
self.add_no_pushButton_2.setText(_translate("add_db_object", "取消"))
class AdDB(QWidget):
def __init__(self):
super().__init__()
self.setFixedSize(441, 511) # 禁止拖動
self.setWindowIcon(QtGui.QIcon('./img/001.ico')) # 設定表單標題圖示
self.setWindowFlags(QtCore.Qt.WindowMinimizeButtonHint) # 禁用最大化
class Ui_delete_win(object):
def __init__(self):
super().__init__()
self.conn = pymysql.connect(host=gl_host, port=gl_port, user=gl_user, password=gl_pwd, db=gl_db)
self.cur = self.conn.cursor()
def setupUi(self, delete_win):
delete_win.setObjectName("delete_win")
delete_win.resize(400, 260)
self.delete_yes = QtWidgets.QPushButton(delete_win)
self.delete_yes.setGeometry(QtCore.QRect(80, 200, 81, 31))
self.delete_yes.setObjectName("delete_yes")
self.delete_no = QtWidgets.QPushButton(delete_win)
self.delete_no.setGeometry(QtCore.QRect(220, 200, 81, 31))
self.delete_no.setObjectName("delete_no")
self.delete_header = QtWidgets.QTextBrowser(delete_win)
self.delete_header.setGeometry(QtCore.QRect(120, 20, 171, 31))
self.delete_header.setObjectName("delete_header")
self.widget = QtWidgets.QWidget(delete_win)
self.widget.setGeometry(QtCore.QRect(40, 70, 331, 111))
self.widget.setObjectName("widget")
self.gridLayout = QtWidgets.QGridLayout(self.widget)
self.gridLayout.setContentsMargins(0, 0, 0, 0)
self.gridLayout.setObjectName("gridLayout")
self.delete_where_vue3 = QtWidgets.QLineEdit(self.widget)
self.delete_where_vue3.setObjectName("delete_where_vue3")
self.gridLayout.addWidget(self.delete_where_vue3, 2, 2, 1, 1)
self.delete_where_vue2 = QtWidgets.QLineEdit(self.widget)
self.delete_where_vue2.setObjectName("delete_where_vue2")
self.gridLayout.addWidget(self.delete_where_vue2, 1, 2, 1, 1)
self.delete_where_item3 = QtWidgets.QComboBox(self.widget)
self.delete_where_item3.setObjectName("delete_where_item3")
self.gridLayout.addWidget(self.delete_where_item3, 2, 1, 1, 1)
self.delete_where = QtWidgets.QLabel(self.widget)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Preferred)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(3)
sizePolicy.setHeightForWidth(self.delete_where.sizePolicy().hasHeightForWidth())
self.delete_where.setSizePolicy(sizePolicy)
self.delete_where.setObjectName("delete_where")
self.gridLayout.addWidget(self.delete_where, 0, 0, 1, 1)
self.delete_where_vue1 = QtWidgets.QLineEdit(self.widget)
self.delete_where_vue1.setObjectName("delete_where_vue1")
self.gridLayout.addWidget(self.delete_where_vue1, 0, 2, 1, 1)
self.delete_where_item2 = QtWidgets.QComboBox(self.widget)
self.delete_where_item2.setObjectName("delete_where_item2")
self.gridLayout.addWidget(self.delete_where_item2, 1, 1, 1, 1)
self.delete_where_item1 = QtWidgets.QComboBox(self.widget)
self.delete_where_item1.setObjectName("delete_where_item1")
self.gridLayout.addWidget(self.delete_where_item1, 0, 1, 1, 1)
self.delete_and = QtWidgets.QLabel(self.widget)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Preferred)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(3)
sizePolicy.setHeightForWidth(self.delete_and.sizePolicy().hasHeightForWidth())
self.delete_and.setSizePolicy(sizePolicy)
self.delete_and.setObjectName("delete_and")
self.gridLayout.addWidget(self.delete_and, 1, 0, 1, 1)
self.delete_and_2 = QtWidgets.QLabel(self.widget)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Preferred, QtWidgets.QSizePolicy.Preferred)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(3)
sizePolicy.setHeightForWidth(self.delete_and_2.sizePolicy().hasHeightForWidth())
self.delete_and_2.setSizePolicy(sizePolicy)
self.delete_and_2.setObjectName("delete_and_2")
self.gridLayout.addWidget(self.delete_and_2, 2, 0, 1, 1)
self.retranslateUi(delete_win)
self.delete_no.clicked.connect(delete_win.close) # type: ignore
QtCore.QMetaObject.connectSlotsByName(delete_win)
self.delete_yes.clicked.connect(lambda: self.delete_fun()) # type: ignore
delete_win.setTabOrder(self.delete_header, self.delete_where_item1)
delete_win.setTabOrder(self.delete_where_item1, self.delete_where_vue1)
delete_win.setTabOrder(self.delete_where_vue1, self.delete_where_item2)
delete_win.setTabOrder(self.delete_where_item2, self.delete_where_vue2)
delete_win.setTabOrder(self.delete_where_vue2, self.delete_where_item3)
delete_win.setTabOrder(self.delete_where_item3, self.delete_where_vue3)
delete_win.setTabOrder(self.delete_where_vue3, self.delete_yes)
delete_win.setTabOrder(self.delete_yes, self.delete_no)
# TODO 刪除記錄
def delete_fun(self):
print('555')
def retranslateUi(self, delete_win):
_translate = QtCore.QCoreApplication.translate
delete_win.setWindowTitle(_translate("delete_win", "刪除記錄"))
self.delete_yes.setText(_translate("delete_win", "確定"))
self.delete_no.setText(_translate("delete_win", "取消"))
self.delete_where.setText(_translate("delete_win", "where"))
self.delete_and.setText(_translate("delete_win", "and"))
self.delete_and_2.setText(_translate("delete_win", "and"))
class DelDB(QWidget):
def __init__(self):
super().__init__()
self.setFixedSize(400, 260) # 禁止拖動
self.setWindowIcon(QtGui.QIcon('./img/001.ico')) # 設定表單標題圖示
self.setWindowFlags(QtCore.Qt.WindowMinimizeButtonHint) # 禁用最大化
class Ui_widget(object):
def __init__(self):
super().__init__()
self.main_show = None
def setupUi(self, widget):
widget.setObjectName("widget")
widget.setEnabled(True)
widget.resize(600, 400)
sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Expanding)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(widget.sizePolicy().hasHeightForWidth())
widget.setSizePolicy(sizePolicy)
self.formLayoutWidget_2 = QtWidgets.QWidget(widget)
self.formLayoutWidget_2.setGeometry(QtCore.QRect(160, 100, 281, 201))
self.formLayoutWidget_2.setObjectName("formLayoutWidget_2")
self.formLayout_2 = QtWidgets.QFormLayout(self.formLayoutWidget_2)
self.formLayout_2.setContentsMargins(0, 0, 0, 0)
self.formLayout_2.setObjectName("formLayout_2")
self.label = QtWidgets.QLabel(self.formLayoutWidget_2)
font = QtGui.QFont()
font.setFamily("楷體")
font.setPointSize(18)
self.label.setFont(font)
self.label.setObjectName("label")
self.formLayout_2.setWidget(0, QtWidgets.QFormLayout.LabelRole, self.label)
self.lineEdit = QtWidgets.QLineEdit(self.formLayoutWidget_2)
font = QtGui.QFont()
font.setFamily("楷體")
font.setPointSize(18)
self.lineEdit.setFont(font)
self.lineEdit.setObjectName("lineEdit")
self.formLayout_2.setWidget(0, QtWidgets.QFormLayout.FieldRole, self.lineEdit)
self.label_2 = QtWidgets.QLabel(self.formLayoutWidget_2)
font = QtGui.QFont()
font.setFamily("楷體")
font.setPointSize(18)
self.label_2.setFont(font)
self.label_2.setObjectName("label_2")
self.formLayout_2.setWidget(1, QtWidgets.QFormLayout.LabelRole, self.label_2)
self.lineEdit_2 = QtWidgets.QLineEdit(self.formLayoutWidget_2)
font = QtGui.QFont()
font.setFamily("楷體")
font.setPointSize(18)
self.lineEdit_2.setFont(font)
self.lineEdit_2.setObjectName("lineEdit_2")
self.formLayout_2.setWidget(1, QtWidgets.QFormLayout.FieldRole, self.lineEdit_2)
self.label_4 = QtWidgets.QLabel(self.formLayoutWidget_2)
font = QtGui.QFont()
font.setFamily("楷體")
font.setPointSize(18)
self.label_4.setFont(font)
self.label_4.setObjectName("label_4")
self.formLayout_2.setWidget(2, QtWidgets.QFormLayout.LabelRole, self.label_4)
self.label_5 = QtWidgets.QLabel(self.formLayoutWidget_2)
font = QtGui.QFont()
font.setFamily("楷體")
font.setPointSize(18)
self.label_5.setFont(font)
self.label_5.setObjectName("label_5")
self.formLayout_2.setWidget(3, QtWidgets.QFormLayout.LabelRole, self.label_5)
self.label_6 = QtWidgets.QLabel(self.formLayoutWidget_2)
font = QtGui.QFont()
font.setFamily("楷體")
font.setPointSize(18)
self.label_6.setFont(font)
self.label_6.setObjectName("label_6")
self.formLayout_2.setWidget(4, QtWidgets.QFormLayout.LabelRole, self.label_6)
self.lineEdit_3 = QtWidgets.QLineEdit(self.formLayoutWidget_2)
font = QtGui.QFont()
font.setFamily("楷體")
font.setPointSize(18)
self.lineEdit_3.setFont(font)
self.lineEdit_3.setObjectName("lineEdit_3")
self.formLayout_2.setWidget(2, QtWidgets.QFormLayout.FieldRole, self.lineEdit_3)
self.lineEdit_4 = QtWidgets.QLineEdit(self.formLayoutWidget_2)
font = QtGui.QFont()
font.setFamily("楷體")
font.setPointSize(18)
self.lineEdit_4.setFont(font)
self.lineEdit_4.setObjectName("lineEdit_4")
self.formLayout_2.setWidget(3, QtWidgets.QFormLayout.FieldRole, self.lineEdit_4)
self.lineEdit_5 = QtWidgets.QLineEdit(self.formLayoutWidget_2)
font = QtGui.QFont()
font.setFamily("楷體")
font.setPointSize(18)
self.lineEdit_5.setFont(font)
self.lineEdit_5.setObjectName("lineEdit_5")
self.formLayout_2.setWidget(4, QtWidgets.QFormLayout.FieldRole, self.lineEdit_5)
self.pushButton = QtWidgets.QPushButton(widget)
self.pushButton.setGeometry(QtCore.QRect(170, 320, 120, 40))
font = QtGui.QFont()
font.setFamily("黑體")
font.setPointSize(12)
self.pushButton.setFont(font)
self.pushButton.setObjectName("pushButton")
self.pushButton_2 = QtWidgets.QPushButton(widget)
self.pushButton_2.setGeometry(QtCore.QRect(310, 320, 120, 40))
font = QtGui.QFont()
font.setFamily("黑體")
font.setPointSize(12)
self.pushButton_2.setFont(font)
self.pushButton_2.setObjectName("pushButton_2")
self.label_3 = QtWidgets.QLabel(widget)
self.label_3.setGeometry(QtCore.QRect(230, 40, 151, 31))
font = QtGui.QFont()
font.setFamily("黑體")
font.setPointSize(20)
self.label_3.setFont(font)
self.label_3.setObjectName("label_3")
# 退出事件
self.retranslateUi(widget)
self.pushButton_2.clicked.connect(widget.close) # type: ignore
QtCore.QMetaObject.connectSlotsByName(widget)
# 登入事件
self.pushButton.clicked.connect(self.login_in) # type: ignore
self.pushButton.setShortcut('Return')
# 驗證登入
def login_in(self):
global gl_db
global gl_host
global gl_pwd
global gl_user
global gl_port
gl_db = self.lineEdit_5.text()
gl_host = self.lineEdit_3.text()
gl_pwd = self.lineEdit_2.text()
gl_user = self.lineEdit.text()
try:
port = int(self.lineEdit_4.text())
try:
conn = pymysql.connect(host=gl_host, port=gl_port, db=gl_db, user=gl_user, password=gl_pwd)
print('登入資料庫{}成功'.format(gl_db))
self.messageDialog('提示', '登入資料庫{}成功'.format(gl_db))
conn.close()
del conn
self.main_show = Fulling()
self.main_show.show()
mainWindow.close()
except pymysql.err.OperationalError:
print('由於目標計算機積極拒絕，無法連線。')
self.messageDialog('警告', '由於目標計算機積極拒絕，無法連線。')
except ValueError:
print('埠號錯誤')
self.messageDialog('警告', '埠號錯誤')
except Exception as err:
print('錯誤：', err)
self.messageDialog('警告', str(err))
# print(db, port, host, pwd, user)
# print(type(db), type(port), type(host), type(pwd), type(user))
def messageDialog(self, title, text):
# 提示資訊
msg_box = QtWidgets.QMessageBox(QtWidgets.QMessageBox.Warning, title, text)
msg_box.exec_()
def retranslateUi(self, widget):
_translate = QtCore.QCoreApplication.translate
widget.setWindowTitle(_translate("widget", "登入 MySQL"))
self.label.setText(_translate("widget", "賬 號："))
self.label_2.setText(_translate("widget", "密 碼："))
self.label_4.setText(_translate("widget", "主 機："))
self.label_5.setText(_translate("widget", "埠號："))
self.label_6.setText(_translate("widget", "資料庫："))
self.pushButton.setText(_translate("widget", "登入"))
self.pushButton_2.setText(_translate("widget", "退出"))
self.label_3.setText(_translate("widget", "登入 MySQL"))
class Login(QMainWindow):
def __init__(self):
super().__init__()
self.setFixedSize(600, 400) # 禁止拖動
self.setWindowIcon(QtGui.QIcon('./img/001.ico')) # 設定表單標題圖示
self.setWindowFlags(QtCore.Qt.WindowMinimizeButtonHint) # 禁用最大化
# 背景圖片
image = QtGui.QPixmap()
image.load(r'./img/login_bg.jpg')
bg = QtGui.QPalette()
bg.setBrush(self.backgroundRole(), QtGui.QBrush(image))
self.setPalette(bg)
self.setAutoFillBackground(True)
if __name__ == '__main__':
gl_db = ''
gl_host = ''
gl_pwd = ''
gl_user = ''
gl_port = 0
# 建立 QApplication 類的範例
logapp = QApplication(sys.argv)
# 建立表單
mainWindow = Login()
# 關聯login
ui = Ui_widget()
ui.setupUi(mainWindow)
# 開啟表單
mainWindow.show()
# 退出表單
sys.exit(logapp.exec_())