python初识（四）

基本函数

基础样式

def 函数名(参数列表):
	函数体
	return

eg

def  add(a,b)
	c = a + b
	print(id(c))
	return c
d = add(1,2)
print(id(d))
print(d)

def showP(person):
	for item in person:
		print(item)
p = ["hjx",30,1.6,100]
showP(p)

包 模块

• 模块：文件名（.py）
• eg
• from 库 import 模块 as 别名
• name

# import  com.oracle.tools
# import com.oracle.tools as t
from com.oracle import tools

a = tools.add(1,1)
print(a)

if ___name__=="__main__":
	print("这是一个特别low计算器")
else:
	print("这是一个特别好计算器")
print(add(1,1))


import com.oracle.tools as t
a = t.add(1,1)
print(a)


import sys
import sys.os
print(os.path.join("org","oracle"))
print(sys.path)
print(sys.argv)

Excel表格操作

• 1，登陆（加密，锁定账户）
• 2，图书查看
• 3，添加图书信息
• 4，修改
• 5，删除（软删除）

import xlrd
def login(username,password):
    #加密
    #验证
    book = xlrd.open_workbook("e://person.xls")
    # sheet1 = book.sheet_by_index(0)
    sheet1 = book.sheet_by_name("person")
    # a = sheet1.cell(2,3).value
    # 一共多少行
    r = sheet1.nrows
    # 一共多少列
    c = sheet1.ncols
    flag = False
    for i in range(1, r):
        if username == sheet1.cell(i,1).value and password == sheet1.cell(i,2).value:
            flag = True
            break
    return flag

import xlrd,xlwt
from xlutils import copy

book = xlrd.open_workbook("d://person.xls")
book_copy = copy.copy(book)
sheet= book_copy.get_sheet(0)
sheet.write(2,1,"啧啧啧")
book_copy.save("d://person.xls")

import xlrd,xlwt
from xlutils import copy

book = xlrd.open_workbook("d://person.xls")
r = book.sheet_by_name("person").nrows
c = book.sheet_by_name("person").ncols
book_copy = copy.copy(book)
sheet = book_copy.get_sheet(0)

a = ["3","sdf","18","147","nu","0"]
for i in range(c):
    sheet.write(r,i,a[i])

book_copy.save("d://person.xls")

仅可创建
import xlwt
book = xlwt.Workbook()
sheet = book.add_sheet("user")
sheet.write(2,2,"nihao")
book.save("e://user.xls")