很多时候，我们需要将数据存储到sqlite数据库中以便后期分析研究所用，下面就是我最常用到的代码，大家可以直接使用

import re
import sqlite3
import os
def mdx2db(dbname,paraList):

    if os.path.isfile(dbname):
        os.remove(dbname)

    createdb(dbname)
        
    #sqlite
    import sqlite3
    conn = sqlite3.connect(dbname)
    c = conn.cursor()
    for item in paraList:
        
        msql='''INSERT INTO gupinfenlei (id,mkey,minglu ) VALUES (?,?,?)''' 
        para=item
        c.execute(msql,para)
        
    conn.commit()
    conn.close()


def  createdb(dbname):
    conn = sqlite3.connect(dbname)
    c = conn.cursor()
    
    c.execute('''CREATE TABLE gupinfenlei
        (ID INTEGER PRIMARY KEY  AUTOINCREMENT,
        mkey           TEXT    NOT NULL,
        minglu          TEXT    

         );''')
    conn.commit()
    conn.close()
    return 'ok'

更多精彩代码请关注我的专栏

• selenium & python 源码大全
• reportlab教程和源码大全
• python源码大全