Python对sqlite3操作的代码示例

import sqlite3
def Test1():
  #con =sqlite3.connect("D:\\test.db")
  con =sqlite3.connect(":memory:") #store in memory
  cur =con.cursor()
  try:
    cur.execute(&＃39;create table score(id integer primary key,name varchar(10),scores integer)&＃39;)
    cur.execute("insert into score values(0,&＃39;Rose&＃39;,87)")
    cur.execute("insert into score values(1,&＃39;Alice&＃39;,78)")
    cur.execute("insert into score values(2,&＃39;Helon&＃39;,100)")
    cur.execute("insert into score values(3,&＃39;Tom&＃39;,98)")
    cur.execute("insert into score values(4,&＃39;jack&＃39;,198)")
    cur.execute("insert into score values(5,&＃39;Tony&＃39;,198)")
    cur.execute("insert into score values(6,&＃39;David&＃39;,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(&＃39;select * from score&＃39;)
  print cur.fetchall()
  print "----------------------------------------"
  cur.execute("select count(*) from score")
  print "Current Rows is :",cur.fetchall()[0]
  cur.close()
  con.close()
if name ==&＃39;main&＃39;:
  Test1()
  print "hello world"

以上就是Python对sqlite3操作的代码示例的详细内容，更多请关注 第一PHP社区 其它相关文章！