python操作sqlite,pythonsqlite,#!/usr/bin/p
文章由Byrx.net分享于2019-03-23 10:03:11
python操作sqlite,pythonsqlite,#!/usr/bin/p
#!/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()
评论关闭