def login_check(self, username, passwd, table_name): ####检查数据库内的用户名和密码是否存在、匹配#### mysqlinfo = MysqlInfo() ######设置查询命令####### username_sql = "select Username from User where Username='******'" % username passwd_sql = "select Passwd from User where Username='******'" % username flag_sql = "select Flag from User where Username='******'" % username name_check = False passwd_check = False data_user = mysqlinfo.get_data(table_name, 2, username_sql) ####判断用户名是否存在###### if len(data_user) < 1: pass else: name_check = True ####判断对应的密码是否正确### data_passwd = mysqlinfo.get_data(table_name, 2, passwd_sql) if passwd == data_passwd[0].get('Passwd'): passwd_check = True data_flag = mysqlinfo.get_data(table_name, 2, flag_sql) ###返回一个判断值### #print name_check,passwd_check,data_flag return name_check, passwd_check, data_flag
def login_check(self,username,passwd,table_name): ####检查数据库内的用户名和密码是否存在、匹配#### mysqlinfo = MysqlInfo() ######设置查询命令####### username_sql = "select Username from User where Username='******'" % username passwd_sql = "select Passwd from User where Username='******'" %username flag_sql = "select Flag from User where Username='******'" %username name_check = False passwd_check = False data_user = mysqlinfo.get_data(table_name,2,username_sql) ####判断用户名是否存在###### if len(data_user)<1: pass else: name_check = True ####判断对应的密码是否正确### data_passwd = mysqlinfo.get_data(table_name,2,passwd_sql) if passwd==data_passwd[0].get('Passwd'): passwd_check = True data_flag = mysqlinfo.get_data(table_name,2,flag_sql) ###返回一个判断值### #print name_check,passwd_check,data_flag return name_check,passwd_check,data_flag
def Flag_name(self, username, passwd, table_name): ####返回一个权限判断值#### mysqlinfo = MysqlInfo() flag_sql = "select Flag from User where Username='******'" % username data_flag = mysqlinfo.get_data(table_name, 2, flag_sql) #print data_flag return data_flag
def login_check(self, username, passwd, table_name): mysqlinfo = MysqlInfo() username_sql = "select Username from User where Username='******'" % username passwd_sql = "select Passwd from User where Username='******'" % username name_check = False passwd_check = False data_user = mysqlinfo.get_data(table_name, 2, username_sql) if len(data_user) < 1: pass else: name_check = True data_passwd = mysqlinfo.get_data(table_name, 2, passwd_sql) if passwd == data_passwd[0].get('Passwd'): passwd_check = True return name_check, passwd_check
def Flag_name(self,username,passwd,table_name): ####返回一个权限判断值#### mysqlinfo = MysqlInfo() flag_sql = "select Flag from User where Username='******'" %username data_flag = mysqlinfo.get_data(table_name,2,flag_sql) #print data_flag return data_flag
def login_check(self,username,passwd,table_name): mysqlinfo = MysqlInfo() username_sql = "select Username from User where Username='******'" % username passwd_sql = "select Passwd from User where Username='******'" %username name_check = False passwd_check = False data_user = mysqlinfo.get_data(table_name,2,username_sql) if len(data_user)<1: pass else: name_check = True data_passwd = mysqlinfo.get_data(table_name,2,passwd_sql) if passwd==data_passwd[0].get('Passwd'): passwd_check = True return name_check,passwd_check
def Register_check(self, username, table_name): ###检查注册是否成功#### mysqlinfo = MysqlInfo() username_sql = "select Username from %s" % table_name data_user = mysqlinfo.get_data(table_name, 2, username_sql) j = 0 ###匹配数据库里面是否有相同的用户名### for i in data_user: if username == i['Username']: j += 1 if j != 0: register_check = True else: register_check = False #print register_check return register_check
def Register_check(self,username,table_name): ###检查注册是否成功#### mysqlinfo = MysqlInfo() username_sql = "select Username from %s" % table_name data_user = mysqlinfo.get_data(table_name,2,username_sql) j = 0 ###匹配数据库里面是否有相同的用户名### for i in data_user: if username == i['Username']: j+=1 if j !=0: register_check = True else: register_check = False #print register_check return register_check
def UserName_check(self,username,table_name): ##### 检查数据库内有没有同样的用户名 ##### mysqlinfo = MysqlInfo() username_sql = "select Username from %s" % table_name data_user = mysqlinfo.get_data(table_name,2,username_sql) j = 0 for i in data_user: if username == i['Username']: j+=1 if j == 0: name_check = True else: name_check = False print name_check return name_check
def UserName_check(self, username, table_name): ##### 检查数据库内有没有同样的用户名 ##### mysqlinfo = MysqlInfo() username_sql = "select Username from %s" % table_name data_user = mysqlinfo.get_data(table_name, 2, username_sql) j = 0 for i in data_user: if username == i['Username']: j += 1 if j == 0: name_check = True else: name_check = False print name_check return name_check
def User_info(self, table_name): ###获取数据库所有的用户信息### mysqlinfo = MysqlInfo() userinfo_sql = "select * from %s" % table_name data_userinfo = mysqlinfo.get_data(table_name, 2, userinfo_sql) #print data_userinfo return data_userinfo
def User_info(self,table_name): ###获取数据库所有的用户信息### mysqlinfo = MysqlInfo() userinfo_sql = "select * from %s" % table_name data_userinfo = mysqlinfo.get_data(table_name,2,userinfo_sql) #print data_userinfo return data_userinfo