def __init__(self): QtGui.QMainWindow.__init__(self) self.ui = Ui_Teacher_history() self.ui.setupUi(self) self.conn() Teacher_query = QSqlQuery() Teacher_query.exec_("select Teacher_name from Teacher") model = QSqlQueryModel() model.setQuery(Teacher_query) self.ui.Teacher_listView.setModel(model) self.ui.history_btn.setEnabled(False) self.ui.Search_btn.clicked.connect(self.search_teacher) self.ui.history_btn.clicked.connect(self.print_history) self.ui.Teacher_listView.clicked.connect(self.select_teacher)
class Teacher_history_window(QtGui.QMainWindow): def __init__(self): QtGui.QMainWindow.__init__(self) self.ui = Ui_Teacher_history() self.ui.setupUi(self) self.conn() Teacher_query = QSqlQuery() Teacher_query.exec_("select Teacher_name from Teacher") model = QSqlQueryModel() model.setQuery(Teacher_query) self.ui.Teacher_listView.setModel(model) self.ui.history_btn.setEnabled(False) self.ui.Search_btn.clicked.connect(self.search_teacher) self.ui.history_btn.clicked.connect(self.print_history) self.ui.Teacher_listView.clicked.connect(self.select_teacher) def search_teacher(self): input_teacher_name = self.ui.Teacher_lineEdit.text() Teacher_query = QSqlQuery() Teacher_query.exec_("select Teacher_name from Teacher where Teacher_name like '%%%s%%'" % input_teacher_name) model = QSqlQueryModel() model.setQuery(Teacher_query) self.ui.Teacher_listView.setModel(model) def print_history(self): self.ui.history = Teacher_history_dialog(self.ui.name) self.ui.history.show() def select_teacher(self, index): self.ui.name = index.data() self.ui.history_btn.setEnabled(True) def conn(self): self.db = QSqlDatabase.addDatabase("QMYSQL") self.db.setHostName("services1.mcs.sdsmt.edu") self.db.setDatabaseName("db_dancesoft_f15") self.db.setUserName("dancesoft_f15") self.db.setPassword("DanceSoft") return self.db.open()