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)
