#-*- encoding:utf-8 -*-
import sqlite3
打开数据库，如果文件不存在会自动创建
conn = sqlite3.connect("container.db")
数据库表是否已经存在
cur = conn.cursor()
cur.execute("select count(*) from sqlite_master where type='table' and name='container'")
cur.fetchone()
conn.commit()
conn.execute("create table container(container_name, account_id text)")
conn.execute("insert into container values ('code.ideais.net', 'jilili')")
conn.commit()
通过游标返回结果
cur = conn.cursor()
cur.execute("select * from container")
print cur.fetchall()
cur.close()
conn.close()