python爬虫6：将数据保存到数据库

python爬虫6：将数据保存到数据库

 注意：

1、切记一定要commit() ，否则存不到数据库

2、可以多条execute() 然后一次性commit()

3、使用完后记得close()

import sqlite3

def saveDataToDB(data):
    connect = sqlite3.connect("test.db")
    c = connect.cursor()  #获取游标
    # i=1
    # for title in data:
    #     sql = r"insert into t1 (id,title) values (%d,'%s');"%(i,title)
    #     i+=1
    #     print(sql)
    #     c.execute(sql)
    titleList = data['titleList']
    detailList = data['detailList']
    for key,value in titleList.items():
        sql = r"insert into title (id,title) values (%d,'%s');" %(key, value)
        c.execute(sql)
    for val in detailList:
        sql = r"insert into detail (`name`,titleId,url) values ('%s',%d,'%s');" %(val[1], val[0],val[2])
        c.execute(sql)
    connect.commit()
    c.close()