图书管理系统
登录(加密)
import xlrd
from xlutils.copy import copy
impot hashlib
def login(username,password):
#读取excel信息
book = xlrd.open_workbook("book.xls")
sheet = book.sheet_by_name("user")
r = sheet.nrows
c = sheet.ncols
flag = False
'''
m--username的列下标
p--password的列下标
q--state的列下标
'''
m = 0
p = 0
q = 0
for j in range(c):
if sheet.cell(0,j).value == "username":
m = j
elif sheet.cell(0,j).value == "password":
p = j
elif sheet.cell(0,j).value == "state"
q = j
password = hashlib.md5(password.encode("utf-8")).hexdigest()
for i in range(1,r):
if sheet.cell(i,q).value == "0" and sheet.cell(i,m).value == username and sheet.cell(i,p).value == "password"
flag = True
break
return flag