Python 學習筆記五----使用sqlite資料庫

標籤：sqlite   python   sqlite3   

import sqlite3def 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 occurscur.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 Paramcur.execute("update score set name=? where id=?",("John",0)) #With Paramcur.execute("delete from score where id =1")except Exception,e:print "There are some except",econ.commit()print "Insert Complete"print "-----------------------------------------"print "Last row id is ",cur.lastrowidcur.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資料庫