python操作sqlite详解编程语言

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 database 
con = sqlite.connect('mydatabase.db3') 
cur = con.cursor() 
 
# Get row by row 
print "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()