Python Ui_Stu_reg Beispiele

Beispiel #1

Datei: Student_reg_window.py Projekt: SDSMT-CSC/dancesoft

class Stu_reg_window(QtGui.QMainWindow):
    def __init__(self):
        QtGui.QMainWindow.__init__(self)
        self.ui = Ui_Stu_reg()
        self.ui.setupUi(self)
        self.conn()
        Stu_query = QSqlQuery()
        Stu_query.exec_("select Student_name from Student")
        self.model = QSqlQueryModel()
        self.model.setQuery(Stu_query)
        self.ui.Stu_listView.setModel(self.model)
        self.ui.Update_btn.setEnabled(False)
        self.ui.Search_btn.clicked.connect(self.search_Stu)
        self.ui.Update_btn.clicked.connect(self.stu_info)
        self.ui.Stu_listView.clicked.connect(self.select_Stu)
        self.ui.Add_btn.clicked.connect(self.stu_add)
        self.ui.Refresh_btn.clicked.connect(self.refresh)

    def refresh(self):
        Stu_query = QSqlQuery()
        Stu_query.exec_("select Student_name from Student")
        self.model = QSqlQueryModel()
        self.model.setQuery(Stu_query)
        self.ui.Stu_listView.setModel(self.model)

    def stu_add(self):
        self.ui.stu_add = Stu_add_reg_dialog()
        self.ui.stu_add.show()

    def search_Stu(self):
        input_Stu_name = self.ui.Stu_lineEdit.text()
        Stu_query = QSqlQuery()
        Stu_query.exec_(
            "select Stu_name from Stu where Stu_name like '%%%s%%'" %
            input_Stu_name)
        model = QSqlQueryModel()
        model.setQuery(Stu_query)
        self.ui.Stu_listView.setModel(model)

    def stu_info(self):
        self.ui.stu_info = Stu_reg_dialog(self.ui.name)
        self.ui.stu_info.show()

    def select_Stu(self, index):
        self.ui.name = index.data()
        self.ui.Update_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()

Beispiel #2

Datei: Student_reg_window.py Projekt: SDSMT-CSC464-F15/dancesoft

class Stu_reg_window(QtGui.QMainWindow):
    def __init__(self):
        QtGui.QMainWindow.__init__(self)
        self.ui = Ui_Stu_reg()
        self.ui.setupUi(self)
        self.conn()
        Stu_query = QSqlQuery()
        Stu_query.exec_("select Student_name from Student")
        self.model = QSqlQueryModel()
        self.model.setQuery(Stu_query)
        self.ui.Stu_listView.setModel(self.model)
        self.ui.Update_btn.setEnabled(False)
        self.ui.Search_btn.clicked.connect(self.search_Stu)
        self.ui.Update_btn.clicked.connect(self.stu_info)
        self.ui.Stu_listView.clicked.connect(self.select_Stu)
        self.ui.Add_btn.clicked.connect(self.stu_add)
        self.ui.Refresh_btn.clicked.connect(self.refresh)


    def refresh(self):
        Stu_query = QSqlQuery()
        Stu_query.exec_("select Student_name from Student")
        self.model = QSqlQueryModel()
        self.model.setQuery(Stu_query)
        self.ui.Stu_listView.setModel(self.model)
        
    def stu_add(self):
        self.ui.stu_add = Stu_add_reg_dialog()
        self.ui.stu_add.show()

        
    def search_Stu(self):
        input_Stu_name = self.ui.Stu_lineEdit.text()
        Stu_query = QSqlQuery()
        Stu_query.exec_("select Stu_name from Stu where Stu_name like '%%%s%%'" % input_Stu_name)
        model = QSqlQueryModel()
        model.setQuery(Stu_query)
        self.ui.Stu_listView.setModel(model)
        
    def stu_info(self):
        self.ui.stu_info = Stu_reg_dialog(self.ui.name)
        self.ui.stu_info.show()
        
    def select_Stu(self, index):
        self.ui.name = index.data()
        self.ui.Update_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()

Beispiel #3

Datei: Student_reg_window.py Projekt: SDSMT-CSC/dancesoft

 def __init__(self):
     QtGui.QMainWindow.__init__(self)
     self.ui = Ui_Stu_reg()
     self.ui.setupUi(self)
     self.conn()
     Stu_query = QSqlQuery()
     Stu_query.exec_("select Student_name from Student")
     model = QSqlQueryModel()
     model.setQuery(Stu_query)
     self.ui.Stu_listView.setModel(model)
     self.ui.Update_btn.setEnabled(False)
     self.ui.Search_btn.clicked.connect(self.search_Stu)
     self.ui.Update_btn.clicked.connect(self.stu_info)
     self.ui.Stu_listView.clicked.connect(self.select_Stu)
     self.ui.Add_btn.clicked.connect(self.stu_add)

Beispiel #4

Datei: Student_reg_window.py Projekt: SDSMT-CSC464-F15/dancesoft

 def __init__(self):
     QtGui.QMainWindow.__init__(self)
     self.ui = Ui_Stu_reg()
     self.ui.setupUi(self)
     self.conn()
     Stu_query = QSqlQuery()
     Stu_query.exec_("select Student_name from Student")
     model = QSqlQueryModel()
     model.setQuery(Stu_query)
     self.ui.Stu_listView.setModel(model)
     self.ui.Update_btn.setEnabled(False)
     self.ui.Search_btn.clicked.connect(self.search_Stu)
     self.ui.Update_btn.clicked.connect(self.stu_info)
     self.ui.Stu_listView.clicked.connect(self.select_Stu)
     self.ui.Add_btn.clicked.connect(self.stu_add)