PyQt5+SQL server 数据库综合实验

最新推荐文章于 2024-08-16 15:46:52 发布

W0ShIzHeNDeCal

最新推荐文章于 2024-08-16 15:46:52 发布

阅读量2.5k

点赞数 1

分类专栏： MySQL python

本文链接：https://blog.csdn.net/w0shlzheNdecaI/article/details/97135100

版权

这篇博客是作者初次尝试使用Python的PyQt5库进行面向对象编程，结合SQL Server数据库进行综合实验。尽管代码可能显得较为冗余，作者在学习过程中导入了一些未使用的组件。

摘要由CSDN通过智能技术生成

 # -*- coding: utf-8 -*-
# python3.7 + sql server2012 + PyQt5+ eric6
# Form implementation generated from reading ui file 'C:\\Users\Administrator\Desktop\code\final\main.ui'
#
# Created by: PyQt5 UI code generator 5.11.3

from PyQt5 import QtCore, QtGui, QtWidgets
from PyQt5.QtGui import  QStandardItemModel,QStandardItem
from PyQt5.QtWidgets import QTableView,QVBoxLayout,QTableWidgetItem
import pymssql
import sys

class Ui_Update(object):
    def __init__(self):
        super(Ui_Update,self).__init__()
        Dialog = QtWidgets.QDialog()
        self.setupUi(Dialog)
        self.Ausername = ''
        self.Apassword = ''
        self.connect_to_sercer()
    def connect_to_sercer(self):
        try:
            self.conn = pymssql.connect(server = '127.0.0.1',user = self.Ausername,password = self.Apassword,database = 'Personnel')
            self.cursor = self.conn.cursor()
        except Exception:
            self.label_2.setText("网络错误！")

    def setupUi(self, Update):
        Update.setObjectName("Update")
        Update.resize(471, 361)
        Update.setSizeGripEnabled(True)
        self.tableWidget = QtWidgets.QTableWidget(Update)
        self.tableWidget.setGeometry(QtCore.QRect(15, 161, 431, 181))
        self.tableWidget.setObjectName("tableWidget")
        self.tableWidget.setColumnCount(0)
        self.tableWidget.setRowCount(0)
        self.pushButton = QtWidgets.QPushButton(Update)
        self.pushButton.setGeometry(QtCore.QRect(340, 30, 75, 23))
        self.pushButton.setObjectName("pushButton")
        self.pushButton_2 = QtWidgets.QPushButton(Update)
        self.pushButton_2.setGeometry(QtCore.QRect(340, 90, 75, 23))
        self.pushButton_2.setObjectName("pushButton_2")
        self.label = QtWidgets.QLabel(Update)
        self.label.setGeometry(QtCore.QRect(50, 10, 54, 12))
        self.label.setObjectName("label")
        self.label_2 = QtWidgets.QLabel(Update)
        self.label_2.setGeometry(QtCore.QRect(50, 40, 54, 12))
        self.label_2.setObjectName("label_2")
        self.label_3 = QtWidgets.QLabel(Update)
        self.label_3.setGeometry(QtCore.QRect(50, 70, 54, 12))
        self.label_3.setObjectName("label_3")
        self.lineEdit = QtWidgets.QLineEdit(Update)
        self.lineEdit.setGeometry(QtCore.QRect(110, 10, 113, 20))
        self.lineEdit.setObjectName("lineEdit")
        self.lineEdit_2 = QtWidgets.QLineEdit(Update)
        self.lineEdit_2.setGeometry(QtCore.QRect(110, 40, 113, 20))
        self.lineEdit_2.setObjectName("lineEdit_2")
        self.lineEdit_3 = QtWidgets.QLineEdit(Update)
        self.lineEdit_3.setGeometry(QtCore.QRect(110, 70, 113, 20))
        self.lineEdit_3.setObjectName("lineEdit_3")
        self.label_4 = QtWidgets.QLabel(Update)
        self.label_4.setGeometry(QtCore.QRect(380, 140, 54, 12))
        self.label_4.setText("")
        self.label_4.setObjectName("label_4")
        self.label_5 = QtWidgets.QLabel(Update)
        self.label_5.setGeometry(QtCore.QRect(50, 130, 54, 12))
        self.label_5.setObjectName("label_5")
        self.lineEdit_4 = QtWidgets.QLineEdit(Update)
        self.lineEdit_4.setGeometry(QtCore.QRect(110, 130, 113, 20))
        self.lineEdit_4.setObjectName("lineEdit_4")
        self.lineEdit_5 = QtWidgets.QLineEdit(Update)
        self.lineEdit_5.setGeometry(QtCore.QRect(110, 100, 113, 20))
        self.lineEdit_5.setObjectName("lineEdit_5")
        self.label_6 = QtWidgets.QLabel(Update)
        self.label_6.setGeometry(QtCore.QRect(50, 100, 54, 12))
        self.label_6.setObjectName("label_6")

        self.retranslateUi(Update)
        self.pushButton_2.clicked.connect(Update.close)
        self.pushButton.clicked.connect(self.update1)
        QtCore.QMetaObject.connectSlotsByName(Update)

    def retranslateUi(self, Update):
        _translate = QtCore.QCoreApplication.translate
        Update.setWindowTitle(_translate("Update", "Dialog"))
        self.pushButton.setText(_translate("Update", "Run"))
        self.pushButton_2.setText(_translate("Update", "Return"))
        self.label.setText(_translate("Update", "表名： "))
        self.label_2.setText(_translate("Update", "更新列："))
        self.label_3.setText(_translate("Update", "值："))
        self.label_5.setText(_translate("Update", "值："))
        self.label_6.setText(_translate("Update", "条件："))
    
    def update1(self):
        self.connect_to_sercer()
        table = self.lineEdit.text()
        title_em = ["EM_Id","EM_name","EM_age","salary","EntWorkDay","OutWorkDay","EM_leader"]
        title_DT_M = ["DEPT_id","DEPT_name","M_id","M_name"]
        title_DT = ["DEPT_id","DEPT_name","DEPT_setdate","DEPT_achi","DEPT_Surplusfunds","DEPT_target"]
        string = "update " + table +" set " + self.lineEdit_2.text() + " = " +self.lineEdit_3.text() + " where " + self.lineEdit_5.text() + " = " + self.lineEdit_4.text()+";"
        print(string)
        self.cursor.execute(string)
        self.cursor.execute("select * from "