python - 如何将按钮连接到使用 pyqt 在 python 中保存新条目的数据库？

Question

这是提交按钮的代码，假设将条目保存在数据库中。输入数据时没有任何保存，它什么也不做。

class Register(QtWidgets.QDialog):
    def __init__(self, parent=None):
        super(Register, self).__init__(parent)
        uic.loadUi("C:\\Users\\Li\\Desktop\\GUI\\LIC\\Register.ui", self)
        self.show()
        self.regbtn.clicked.connect(self.page)

    def page(self):
        firstname = self.Fname.text()
        lastname = self.Lname.text()
        address = self.address.text()
        email = self.Email.text()
        phone = self.phone.text()
        password = self.password.text()
        print(firstname,lastname,address,email,phone,password)
        # getting the currently selected radio button
        if self.male.isChecked():
            gender = 'Male'
        else:
            gender = 'Female'
        print(gender)

        # saving all the information entered into the database
        try:
            cur.execute('INSERT into Details(FirstName,LastName,Address,Gender,Email,PhoneNo,Password) values(?,?,?,?,?,?,?)',(firstname,lastname,address,gender,email,phone,password))
            db.commit()
        except:
            print("Not successful, Try again")

 

标签： pythondatabasebuttonpyqt