1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
#!/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() |
