python操作sqlite，pythonsqlite,python2.5以上版

python操作sqlite，pythonsqlite,python2.5以上版

python2.5以上版本已经集成了sqlite模块，下面是一些基本用法

#!/usr/bin/python# -*- coding: iso-8859-1 -*-from sqlite3 import dbapi2 as sqlite# Create a database:con = sqlite.connect('mydatabase.db3')cur = con.cursor()# Create a table:cur.execute('create table clients (id INT PRIMARY KEY, name CHAR(60))')# Insert a single line:client = (5,"John Smith")cur.execute("insert into clients (id, name) values (?, ?)", client )con.commit()# Insert several lines at once:clients = [ (7,"Ella Fitzgerald"),            (8,"Louis Armstrong"),            (9,"Miles Davis")          ]cur.executemany("insert into clients (id, name) values (?, ?)", clients )con.commit()cur.close()con.close()#下面的代码对数据库进行连接查询#!/usr/bin/python# -*- coding: iso-8859-1 -*-from sqlite3 import dbapi2 as sqlite# Connect to an existing databasecon = sqlite.connect('mydatabase.db3')cur = con.cursor()# Get row by rowprint "Row by row:"cur.execute('select id, name from clients order by name;')row = cur.fetchone()while row:    print row    row = cur.fetchone()# Get all rows at once:print "All rows at once:"cur.execute('select id, name from clients order by name;')print cur.fetchall()cur.close()con.close()