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 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
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 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 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 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
#!/usr/bin/python
#encoding=utf-8
import sys
reload(sys)
sys.setdefaultencoding('utf-8')
from mysql_m import MysqlInfo
mysqlinfo = MysqlInfo()
class MysqlOperate(object):
def __init__(self):
pass
def data_max(self):
table_name = 'user'
data_max = mysqlinfo.get_data(table_name, 1)
print data_max
if __name__ == '__main__':
mysql_operate = MysqlOperate()
mysql_operate.data_max()
