Python学习笔记Day5

Python学习笔记Day5

xlwt

在表格中写入内容

workbook = xlwt.Workbook(encoding="utf-8") #创建workBook对象
worksheet = workbook.add_sheet('sheet1') #创建工作表
worksheet.write(0,0,"hello") #矩阵上写入内容
workbook.save("student.xls")

九九乘法表写入表格

workBook = xlwt.Workbook(encoding="utf-8")
workSheet = workBook.add_sheet('sheet1')
for i in range(0,10):
    for j in range(0,10):
        if(i==9 | j == 9):
            break
        workSheet.write(i,j,"%d*%d=%d"%(i+1,j+1,(i+1)*(j+1)))
        if(i == j):
            break
workBook.save("九九乘法表.xls")

将爬取的豆瓣Top250影片信息导入表格中

def saveData(dataList,savePath):
    book = xlwt.Workbook(encoding="utf-8",style_compression=0)  # 创建workBook对象
    sheet = book.add_sheet('豆瓣评分Top250',cell_overwrite_ok=True)  # 创建工作表
    col = ("电影详情链接","图片链接","中文名","电影外文名","评分","评价数","概况","相关信息")
    for i in range(0,8):
        sheet.write(0, i, col[i])
    for i in range(0,250):
        print("第%d条"%i)
        data = dataList[i]
        for j in range(0,8):
            sheet.write(i+1,j,data[j])
    book.save(savePath)

sqlite数据库

导入包

import sqlite3

创建表

conn = sqlite3.connect("test.db") #打开或者创建
sql_create = '''
    create table company
    (id int primary key not null,
    name char(50) not null,
    age int not null,
    adress char(50),
    salary real);
    c = conn.cursor() #获取游标
c.execute(sql_create)
conn.commit() #提交数据库操作
conn.close() #关闭数据库连接
print("成功建表")

插入表

sql_insert = '''
    insert into company
    values(1,"张三",50,"重庆",15000)
'''
sql_insert1 = '''
    insert into company
    values(2,"李四",53,"大庆",10000)
'''
c = conn.cursor()
c.execute(sql_insert)
c.execute(sql_insert1)
conn.commit()
conn.close()

查询表

sql_find = '''
    select * from company
'''
c = conn.cursor()
result = c.execute(sql_find)
for i in result:
   # print(i[2])
     print("id=%d"%i[0])
     print("name= ",i[1])
     print("adress= ",i[3])
     print("salary= ",i[4],"\n")