Python簡單操作sqlite3的方法樣本,pythonsqlite3樣本
本文執行個體講述了Python簡單操作sqlite3的方法。分享給大家供大家參考,具體如下:
import sqlite3def 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"