import sqlite3
def Test1():
#con =sqlite3.connect("D:\\test.db")
con =sqlite3.connect(":memory:") #store in memory
cur =con.cursor()
try:
cur.execute('create table score(id integer primary key,name varchar(10),scores integer)')
cur.execute("insert into score values(0,'Rose',87)")
cur.execute("insert into score values(1,'Alice',78)")
cur.execute("insert into score values(2,'Helon',100)")
cur.execute("insert into score values(3,'Tom',98)")
cur.execute("insert into score values(4,'jack',198)")
cur.execute("insert into score values(5,'Tony',198)")
cur.execute("insert into score values(6,'David',99)")
cur.execute("update score set scores =? where id=?",(45,3))
cur.execute("update score set name=? where id=?",("John",0))
cur.execute("delete from score where id =1")
except Exception,e:
print "There are some except",e
con.commit()
print "Insert Complete"
print "-----------------------------------------"
print "Last row id is ",cur.lastrowid
cur.execute('select * from score')
print cur.fetchall()
print "----------------------------------------"
cur.execute("select count(*) from score")
print "Current Rows is :",cur.fetchall()[0]
cur.close()
con.close()
if __name__ =='__main__':
Test1()
print "hello world"
python操作 sqlite3的简单方法
最新推荐文章于 2024-08-14 08:42:30 发布