#coding=gbk

import sqlite3

#数据库文件路径

path = "test.db"

#以字典形式输出字段

def dict_factory(cursor, row):

d = {}

for idx, col in enumerate(cursor.description):

d[col[0]] = row[idx]

return d

#获取数据库连接

def GetConn():

conn = sqlite3.connect(path)

conn.row_factory = dict_factory

return conn

#执行简单查询

def Query(sql):

conn = GetConn()

cursor = conn.cursor()

cursor.execute(sql)

result = cursor.fetchall()

cursor.close()

conn.close()

return result

#执行带参数的查询

def QueryWithParms(sql,parms):

conn = GetConn()

cursor = conn.cursor()

cursor.execute(sql,parms)

result = cursor.fetchall()

cursor.close()

conn.close()

return result

#执行简单SQL

def ExecSQL(sql):

conn = GetConn()

cursor = conn.cursor()

cursor.execute(sql)

conn.commit()

cursor.close()

conn.close()

return cursor.rowcount

#执行带参数的SQL

def ExecSQLWithParms(sql,parms):

conn = GetConn()

cursor = conn.cursor()

cursor.execute(sql,parms)

conn.commit()

cursor.close()

conn.close()

return cursor.rowcount

#执行多参数的SQL

def ExecSQLMany(sql,parms):

conn = GetConn()

cursor = conn.cursor()

cursor.executemany(sql,parms)

conn.commit()

cursor.close()

conn.close()

return cursor.rowcount

#调用事例

# import SQLiteHelper

# import datetime

#执行简单查询和带参数的查询

# result = SQLiteHelper.Query("select * from t1 where id = 1")

# result = SQLiteHelper.Query("select * from t1 where name like '%张%'")

# result = SQLiteHelper.QueryWithParms("select * from t1 where name like ?",('%张%',))

# result = SQLiteHelper.QueryWithParms("select * from t1 where id = ?",(1,))

# result = SQLiteHelper.QueryWithParms("select * from t1 where id in (?,?,?,?)",(2,3,4,5,))

# for row in result:

#     print(row["id"])

#     print(row["name"])

#     print(row["addtime"],"\n")

#     print(datetime.datetime.strptime(row["addtime"],"%Y-%m-%d %H:%M:%S"),"\n")

#执行简单SQL

# row = SQLiteHelper.ExecSQL("insert into t1(name,addtime) values('小丁','2018-09-18')")

# print(row)

#执行带参数的SQL

# parms = ('韩梅梅','2018-09-18')

# row = SQLiteHelper.ExecSQLWithParms("insert into t1(name,addtime) values(?,?)",parms)

# print(row)

#执行多参数的SQL

# parms = (('雷锋','2018-09-18'),('小丁','2018-09-19'),('小胡','2018-09-20'))

# row = SQLiteHelper.ExecSQLMany("insert into t1(name,addtime) values(?,?)",parms)

# print(row)

源码下载：SQLiteHelper.zip