Python json数据转换为Sqlite3 数据库表

只是一个代码，改一下就可以用

# -*- coding:utf-8 -*-
import json
import sqlite3

JSON_FILE = "data.json"
DB_FILE = "insaleader.db"

dicSet = json.load(open(JSON_FILE))
dicData = dicSet["data"]
conn = sqlite3.connect(DB_FILE)
c = conn.cursor()
c.execute('create table dic (id Text primary key , dicCode Text , dicName Text , groupCode Text , groupName Text)')
print 'create dic table success'
conn.commit()
for dic in dicData :
    idStr = dic["id"]
    dicCode = dic["dicCode"]
    dicName = dic["dicName"]
    groupCode = dic["groupCode"]
    groupName = dic["groupName"]

    data = [idStr, dicCode,dicName,groupCode,groupName]


    c.execute('insert into dic values (?,?,?,?,?)', data)

    conn.commit()
    print 'insert into dic values ' + str(data) +" success" 

c.close()