class tb_AccountList: def __init__(self, user_name='', password='', user_role='', real_name='', class_code=''): self.user_name = user_name self.password = password self.user_role = user_role self.real_name = real_name self.class_code = class_code self.ms_sql = None def open_conn(self): self.ms_sql = MSSQL() def close(self): self.ms_sql.close_connection() def insert_data(self): sql = "INSERT INTO accountList VALUES('" + str( self.user_name) + "', '" + str(self.password) + "', '" + str( self.user_role) + "','" + str(self.real_name) + "','" + str( self.class_code) + "')" if self.ms_sql.ExecNonQuery(sql): return True else: print("---------- tb_AccountList 保存到数据库失败 ----------") return False def delete_data(self): sql = "DELETE FROM accountList WHERE user_name = '" + self.user_name + "'" if self.ms_sql.ExecNonQuery(sql): return True else: print("---------- tb_AccountList 删除到数据库失败 ----------") return False def select_data(self): sql = "SELECT * FROM accountList" return self.ms_sql.ExecQuery(sql) def update_data(self): sql = "UPDATE accountList SET password = '******' WHERE user_name = '" + self.user_name + "'" if self.ms_sql.ExecNonQuery(sql): return True else: print("---------- tb_AccountList 更新到数据库失败 ----------") return False
def freeExecute(sql_str, is_select): ms_sql = MSSQL() if is_select: return_content = ms_sql.ExecQuery(sql_str) else: if ms_sql.ExecNonQuery(sql_str): return_content = True else: print("---------- freeExecute 自由执行语句失败 ----------") return_content = False ms_sql.close_connection() return return_content
class tb_StudentList: def __init__(self, student_id='', student_name='', class_code=''): self.student_id = student_id self.student_name = student_name self.class_code = class_code self.ms_sql = None def open_conn(self): self.ms_sql = MSSQL() def close(self): self.ms_sql.close_connection() def insert_data(self): sql = "INSERT INTO studentList VALUES('" + str( self.student_id) + "', '" + str(self.student_name) + "','" + str( self.class_code) + "')" if self.ms_sql.ExecNonQuery(sql): return True else: print("---------- tb_StudentList 保存到数据库失败 ----------") return False def delete_data(self): sql = "DELETE FROM studentList WHERE student_id = '" + self.student_id + "'" if self.ms_sql.ExecNonQuery(sql): return True else: print("---------- tb_StudentList 删除到数据库失败 ----------") return False def select_data(self): sql = "SELECT * FROM studentList" return self.ms_sql.ExecQuery(sql) def select_data_by_classcode(self): sql = "SELECT * FROM studentList WHERE class_code = '" + str( self.class_code) + "'" return self.ms_sql.ExecQuery(sql)
class tb_ScoreList: def __init__(self, student_id='', eva_id='', s1='', s2='', s3='', s4='', s5='', s6='', eva_time=''): self.student_id = student_id self.eva_id = eva_id self.s1 = s1 self.s2 = s2 self.s3 = s3 self.s4 = s4 self.s5 = s5 self.s6 = s6 self.eva_time = eva_time self.ms_sql = None def open_conn(self): self.ms_sql = MSSQL() def close(self): self.ms_sql.close_connection() def insert_data(self): sql = "INSERT INTO scoreList VALUES('" + str( self.student_id) + "', '" + str(self.eva_id) + "', " + str( self.s1) + ", " + str(self.s2) + ", " + str( self.s3) + ", " + str(self.s4) + ", " + str( self.s5) + ", " + str(self.s6) + ", '" + str( self.eva_time) + "')" if self.ms_sql.ExecNonQuery(sql): return True else: print("---------- tb_ScoreList 保存到数据库失败 ----------") return False def select_data(self): sql = "SELECT * FROM scoreList" return self.ms_sql.ExecQuery(sql) def select_data_by_evaid(self): sql = "SELECT * FROM scoreList WHERE eva_id = '" + str( self.eva_id) + "'" return self.ms_sql.ExecQuery(sql)
class tb_LoginLog: def __init__(self, user_name='', login_time=''): self.user_name = user_name self.login_time = login_time self.ms_sql = None def open_conn(self): self.ms_sql = MSSQL() def close(self): self.ms_sql.close_connection() def insert_data(self): sql = "INSERT INTO loginLog VALUES('" + str( self.user_name) + "', '" + str(self.login_time) + "')" if self.ms_sql.ExecNonQuery(sql): return True else: print("---------- tb_LoginLog 保存到数据库失败 ----------") return False def select_data(self): sql = "SELECT * FROM loginLog" return self.ms_sql.ExecQuery(sql)
class tb_AccountDetail: def __init__(self, user_name='', slogan='', user_avatar=''): self.user_name = user_name self.slogan = slogan self.user_avatar = user_avatar self.ms_sql = None def open_conn(self): self.ms_sql = MSSQL() def close(self): self.ms_sql.close_connection() def insert_data(self): sql = "INSERT INTO accountDetail VALUES('" + str( self.user_name) + "', '" + str(self.slogan) + "','" + str( self.user_avatar) + "')" if self.ms_sql.ExecNonQuery(sql): return True else: print("---------- tb_AccountDetail 保存到数据库失败 ----------") return False def delete_data(self): sql = "DELETE FROM accountDetail WHERE user_name = '" + self.user_name + "'" if self.ms_sql.ExecNonQuery(sql): return True else: print("---------- tb_AccountDetail 删除到数据库失败 ----------") return False def select_data(self): sql = "SELECT * FROM accountDetail" return self.ms_sql.ExecQuery(sql) def select_data_by_username(self): sql = "SELECT * FROM accountDetail WHERE user_name = '" + self.user_name + "'" return self.ms_sql.ExecQuery(sql) def update_avatar(self): sql_0 = 'SELECT MAX(user_avatar)+1 FROM accountDetail' new_avatar_id = self.ms_sql.ExecQuery(sql_0)[0][0] avatar_list = self.select_data_by_username() if not avatar_list: if not self.insert_data(): return False sql = "UPDATE accountDetail SET user_avatar = '" + str( new_avatar_id) + "' WHERE user_name = '" + self.user_name + "'" if self.ms_sql.ExecNonQuery(sql): return new_avatar_id else: print( "---------- tb_AccountDetail 执行update_avatar到数据库失败 ----------") return False def update_slogan(self): sql = "UPDATE accountDetail SET slogan = '" + str( self.slogan) + "' WHERE user_name = '" + self.user_name + "'" if self.ms_sql.ExecNonQuery(sql): return True else: print( "---------- tb_AccountDetail 执行update_slogan到数据库失败 ----------") return False