import sqlite3

def Test1():
	con = sqlite3.connect("D:\\test.db")
	con = sqlite3.connect("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(4,'jack',198)") #Don't execute the following statement when except occurs
		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)) #With Param
		cur.execute("update score set name=? where id=?",("John",0)) #With Param
		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 学习笔记五----使用sqlite数据库