SQLite – Python

VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 )");conn.commit()print "Records created successfully";conn.close()上述程序执行时，它会在 COMPANY 表中创建给定记录，并会显示以下两行：Opened database successfullyRecords created successfullySELECT 操作下面的 Python 程序显示了如何从前面创建的 COMPANY 表中获取并显示记录：#!/usr/bin/pythonimport sqlite3conn = sqlite3.connect('test.db')c = conn.cursor()print "Opened database successfully";cursor = c.execute("SELECT id, name, address, salary from COMPANY")for row in cursor: print "ID = ", row[0] print "NAME = ", row[1] print "ADDRESS = ", row[2] print "SALARY = ", row[3], "\n"print "Operation done successfully";conn.close()上述程序执行时，它会产生以下结果：Opened database successfullyID = 1NAME = PaulADDRESS = CaliforniaSALARY = 20000.0ID = 2NAME = AllenADDRESS = TexasSALARY = 15000.0ID = 3NAME = TeddyADDRESS = NorwaySALARY = 20000.0ID = 4NAME = MarkADDRESS = Rich-MondSALARY = 65000.0Operation done successfullyUPDATE 操作下面的 Python 代码显示了如何使用 UPDATE 语句来更新任何记录，然后从 COMPANY 表中获取并显示更新的记录：#!/usr/bin/pythonimport sqlite3conn = sqlite3.connect('test.db')c = conn.cursor()print "Opened database successfully";c.execute("UPDATE COMPANY set SALARY = 25000.00 where ID=1")conn.commit()print "Total number of rows updated :", conn.total_changescursor = conn.execute("SELECT id, name, address, salary from COMPANY")for row in cursor: print "ID = ", row[0] print "NAME = ", row[1] print "ADDRESS = ", row[2] print "SALARY = ", row[3], "\n"print "Operation done successfully";conn.close()上述程序执行时，它会产生以下结果：Opened database successfullyTotal number of rows updated : 1ID = 1NAME = PaulADDRESS = CaliforniaSALARY = 25000.0ID = 2NAME = AllenADDRESS = TexasSALARY = 15000.0ID = 3NAME = TeddyADDRESS = NorwaySALARY = 20000.0ID = 4NAME = MarkADDRESS = Rich-MondSALARY = 65000.0Operation done successfullyDELETE 操作下面的 Python 代码显示了如何使用 DELETE 语句删除任何记录，然后从 COMPANY 表中获取并显示剩余的记录：#!/usr/bin/pythonimport sqlite3conn = sqlite3.connect('test.db')c = conn.cursor()print "Opened database successfully";c.execute("DELETE from COMPANY where ID=2;")conn.commit()print "Total number of rows deleted :", conn.total_changescursor = conn.execute("SELECT id, name, address, salary from COMPANY")for row in cursor: print "ID = ", row[0] print "NAME = ", row[1] print "ADDRESS = ", row[2] print "SALARY = ", row[3], "\n"print "Operation done successfully";conn.close()上述程序执行时，它会产生以下结果：Opened database successfullyTotal number of rows deleted : 1ID = 1NAME = PaulADDRESS = CaliforniaSALARY = 20000.0ID = 3NAME = TeddyADDRESS = NorwaySALARY = 20000.0ID = 4NAME = MarkADDRESS = Rich-MondSALARY = 65000.0Operation done successfully