def add_tro(self)->bool: """""" sql = """INSERT INTO tro(tro_no, tro_name, tro_size, department_no) VALUES ("{tro_no}","{tro_name}",{tro_size},"{department_no}")""".format(tro_no = self.tro_no ,tro_name = self.tro_name ,tro_size = self.tro_size ,department_no = self.department_no) return add_del_update(sql)
def add_course(self)->bool: """""" sql = """INSERT INTO course(course_no, course_name, period, credit, teacher_no) VALUES ("{course_no}", "{course_name}", {period}, {credit}, "{teacher_no}")""".format(course_no = self.course_no ,course_name = self.course_name ,period = self.period ,credit = self.credit ,teacher_no = self.teacher_no) return add_del_update(sql)
def add_collage(self)->bool: """""" sql = """INSERT INTO collage(collage_no, collage_name, dean, tel, address) VALUES ("{collage_no}","{collage_name}","{dean}","{tel}","{address}")""".format(collage_no = self.collage_no ,collage_name = self.collage_name ,dean = self.dean ,tel = self.tel ,address = self.address) return add_del_update(sql)
def add_class(self)->bool: """""" sql = """INSERT INTO class(class_no, class_name, class_size, professional, department_no) VALUES ("{class_no}", "{class_name}", "{class_size}", "{professional}", "{department_no}")""".format(class_no = self.class_no ,class_name = self.class_name ,class_size = self.class_size ,professional = self.professional ,department_no = self.department_no) return add_del_update(sql)
def add_teacher(self)->bool: """""" sql = """INSERT INTO teacher(teacher_no, teacher_name, gender, post, tro_no) VALUES ("{teacher_no}", "{teacher_name}", "{gender}", "{post}", "{tro_no}")""".format(teacher_no = self.teacher_no ,teacher_name = self.teacher_name ,gender = self.gender ,post = self.post ,tro_no = self.tro_no) return add_del_update(sql)
def add_department(self)->bool: """""" sql = """INSERT INTO department(department_no, name, tro_num, class_num, collage_no) VALUES ("{department_no}", "{name}", {tro_num}, {class_num}, "{collage_no}")""".format(department_no = self.department_no ,name = self.name ,tro_num = self.tro_num ,class_num = self.class_num ,collage_no = self.collage_no) return add_del_update(sql)
def add_student(self)->bool: """""" sql = """INSERT INTO student(student_no, student_name, gender, birthplace, class_no) VALUES ("{student_no}", "{student_name}", "{gender}", "{birthplace}", "{class_no}")""".format(student_no=self.student_no ,student_name=self.student_name ,gender=self.gender ,birthplace=self.birthplace ,class_no=self.class_no) return add_del_update(sql)
def update_tro(self, change_no=None): origin_no = self.tro_no if change_no: self.tro_no = change_no sql = """UPDATE tro SET tro_no = "{tro_no}", tro_name = "{tro_name}", tro_size = {tro_size}, department_no="{department_no}" WHERE tro_no = "{origin_no}" """.format(tro_no = self.tro_no ,tro_name = self.tro_name ,tro_size = self.tro_size ,department_no = self.department_no ,origin_no = origin_no) return add_del_update(sql)
def update_class(self, change_no=None): origin_no = self.class_no if change_no: self.class_no = change_no sql = """UPDATE class SET class_no = "{class_no}", class_name = "{class_name}", class_size = {class_size}, professional="{professional}", department_no = "{department_no}" WHERE class_no = "{origin_no}" """.format(class_no = self.class_no ,class_name = self.class_name ,class_size = self.class_size ,professional = self.professional ,department_no = self.department_no ,origin_no = origin_no) return add_del_update(sql)
def update_department(self, change_no=None): origin_no = self.department_no if change_no: self.department_no = change_no sql = """UPDATE department SET department_no = "{department_no}", name = "{name}", tro_num = {tro_num}, class_num={class_num}, collage_no = "{collage_no}" WHERE department_no = "{origin_no}" """.format(department_no = self.department_no ,name = self.name ,tro_num = self.tro_num ,class_num = self.class_num ,collage_no = self.collage_no ,origin_no = origin_no) return add_del_update(sql)
def update_collage(self, change_no=None): origin_no = self.collage_no if change_no: self.collage_no = change_no sql = """UPDATE collage SET collage_no = "{collage_no}", collage_name = "{collage_name}", dean = "{dean}", tel="{tel}", address = "{address}" WHERE collage_no = "{origin_no}" """.format(collage_no = self.collage_no ,collage_name = self.collage_name ,dean = self.dean ,tel = self.tel ,address = self.address ,origin_no = origin_no) return add_del_update(sql)
def update_course(self, change_no=None): origin_no = self.course_no if change_no: self.course_no = change_no sql = """UPDATE course SET course_no = "{course_no}", course_name = "{course_name}", period = {period}, credit = {credit}, teacher_no = "{teacher_no}" WHERE course_no = "{origin_no}" """.format(course_no = self.course_no ,course_name = self.course_name ,period = self.period ,credit = self.credit ,teacher_no = self.teacher_no ,origin_no = origin_no) return add_del_update(sql)
def update_teacher(self, change_no=None): origin_no = self.teacher_no if change_no: self.teacher_no = change_no sql = """UPDATE teacher SET teacher_no = "{teacher_no}", teacher_name = "{teacher_name}", gender = "{gender}", post="{post}", tro_no = "{tro_no}" WHERE teacher_no = "{origin_no}" """.format(teacher_no = self.teacher_no ,teacher_name = self.teacher_name ,gender = self.gender ,post = self.post ,tro_no = self.tro_no ,origin_no = origin_no) return add_del_update(sql)
def update_student(self, change_no=None): origin_no = self.student_no if change_no: self.student = change_no sql = """UPDATE student SET student_no = "{student_no}", student_name = "{student_name}", gender = "{gender}", birthplace="{birthplace}", class_no = "{class_no}" WHERE student_no = "{origin_no}" """.format(student_no=self.student_no ,student_name=self.student_name ,gender=self.gender ,birthplace=self.birthplace ,class_no=self.class_no ,origin_no = origin_no) return add_del_update(sql)
def del_teacher(self): sql = """DELETE FROM teacher WHERE teacher_no='{teacher_no}' """.format(teacher_no=self.teacher_no) return add_del_update(sql)
def del_collage(self): sql = """DELETE FROM collage WHERE collage_no='{collage_no}' """.format(collage_no=self.collage_no) return add_del_update(sql)
def del_class(self): sql = """DELETE FROM class WHERE class_no='{class_no}' """.format(class_no=self.class_no) return add_del_update(sql)
def del_account(self)->bool: """从数据库中删除类变量中的帐号""" sql = """DELETE FROM user WHERE account='{account}' """.format(account=self.account) return add_del_update(sql)
def add_account(self)->bool: """将类变量中的帐号添加""" sql = """INSERT INTO user(account, password) VALUES("{ac}","{pw}")""".format(ac=self.account, pw=self.password) return add_del_update(sql)
def update_source(self): sql = """UPDATE source SET source = "{source}" WHERE student_no = "{student_no}" AND course_no="{course_no}" """.format(source=self.source, student_no=self.student_no, course_no=self.course_no) return add_del_update(sql)
def del_source(self): sql = """DELETE FROM source WHERE student_no='{student_no}' AND course_no="{course_no}" """.format(student_no=self.student_no, course_no=self.course_no) return add_del_update(sql)
def add_source(self)->bool: """""" sql = """INSERT INTO source(student_no, course_no, source) VALUES ("{student_no}", "{course_no}", "{source}")""".format(student_no = self.student_no ,course_no = self.course_no ,source = self.source) return add_del_update(sql)
def update_password(self)->bool: """将密码修改为类变量中的值""" sql = """ UPDATE user SET password='******' WHERE account='{ac}' """.format(pw=self.password, ac=self.account) return add_del_update(sql)
def del_tro(self): sql = """DELETE FROM tro WHERE tro_no='{tro_no}' """.format(tro_no=self.tro_no) return add_del_update(sql)
def del_department(self): sql = """DELETE FROM department WHERE department_no='{department_no}' """.format(department_no=self.department_no) return add_del_update(sql)
def del_student(self): sql = """DELETE FROM student WHERE student_no='{student_no}' """.format(student_no=self.student_no) return add_del_update(sql)