Python简单操作sqlite3的方法示例

importsqlite3

defTest1():

  #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")

  exceptException,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')

  printcur.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"