Python+PyQt5实现数据库表格动态增删改

第Python+PyQt5实现数据库表格动态增删改ifself.button_save.isEnabled():

r=QMessageBox.warning(self,"警告","你还有操作没保存，现在保存下？",QMessageBox.Yes|QMessageBox.No,QMessageBox.Yes)

ifr==QMessageBox.No:

event.accept()

else:

event.ignore()

defcontext_menu(self,pos):

pop_menu=QMenu()

change_new_event=pop_menu.addAction("修改行")

delete_event=pop_menu.addAction("删除行")

action=pop_menu.exec_(self.tableWidget.mapToGlobal(pos))

ifaction==change_new_event:

item=self.tableWidget.selectedItems()

row=item[0].row()

id=self.tableWidget.item(row,0).text()

di=inputDialog(sid=id)

ok=di.exec_()

ifnotok:

return

name=di.line_name.text()

sid=di.line_id.text()

sex=di.line_sex.text()

address=di.line_address.text()

print("before:",id)

print("after:",sid)

self.tableWidget.item(row,0).setText(sid)

self.tableWidget.item(row,1).setText(name)

self.tableWidget.item(row,2).setText(sex)

self.tableWidget.item(row,3).setText(address)

data[sid]=[name,sex,address]

ifid!=sid:

deldata[id]

self.button_save.setEnabled(True)

elifaction==delete_event:

r=QMessageBox.warning(self,"注意","删除可不能恢复了哦！",QMessageBox.Yes|QMessageBox.No,QMessageBox.No)

ifr==QMessageBox.No:

return

items=self.tableWidget.selectedItems()

ifitems:

selected_rows=[]

foriinitems:

row=i.row()

ifrownotinselected_rows:

selected_rows.append(row)

selected_rows=sorted(selected_rows,reverse=True)

forrinselected_rows:

sid=self.tableWidget.item(r,0).text()

deldata[sid]

self.tableWidget.removeRow(r)

self.button_save.setEnabled(True)

classinputDialog(QDialog,Ui_Dialog_input):

def__init__(self,sid=None):

super(inputDialog,self).__init__()

self.setupUi(self)

self.sid=sid

self.buttonBox.accepted.connect(self.check)

ifsid:

self.line_id.setText(sid)

self.line_name.s