Python初识（五）---图书管理系统

图书管理系统

登录（加密）

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