Python操作splite3的例子

__author__ = 'Administrator'
import sqlite3
def inser(*args,**kwargs):
    '''
    增加数据输入
    '''
    #print(args)
    cour.execute("insert into mytest(name,telephone,phone,email,qq)values(?,?,?,?,?)",args,)
def insertManyInfo(*args,**kwargs):
    pass

def getInfo():
    cour.execute("select * from mytest")
    for k,n,te,ph,em,q in cour:
        print(k," ",n," ",te," ",ph," ",em," ",q)
def getAllInfo():
    cour.execute("select * from mytest")
    for item in cour.fetchall():
        print(item)
con=sqlite3.connect(r"F:\\baidu download\\test.db")
cour=con.cursor()
try:

    cour.execute("drop table mytest")
except:
    print()
cour.execute("create table mytest(id INTEGER primary key autoincrement not null,"
             "name text not null,"
             "telephone int not null,"
             "phone int not null,"
             "email text not null,"
             "qq int not null)")

if __name__=="__main__":
    inser("Liming","13532100265","010-4565892","[e-mail]","619617021")

    getInfo()#显示信息#显示单个信息
    getAllInfo()#返回的是Tuple