def __init__(self, Class_name=None): QtGui.QDialog.__init__(self) self.ui = Ui_Addstu_detail() self.ui.setupUi(self) Stu_query = QSqlQuery() self.class_name = Class_name Stu_query.exec_( "Select S.Student_name from Student_Class as SC,Student as S where\ SC.Class_id = (Select Class_id from Class where Class_name = '%s') \ and SC.Student_id = S.Student_id and SC.Class_finished <> 1 and \ SC.Class_approval <> 1" % self.class_name) model = QSqlQueryModel() model.setQuery(Stu_query) self.ui.Addstu_detail_listView.setModel(model) self.ui.Addstu_detail_listView.clicked.connect(self.add_student) self.ui.Addstu_detail_btn.setEnabled(False) self.ui.Addstu_detail_btn.clicked.connect(self.set_student)