最近需要用Python寫一個簡易通訊錄，但是對于數據存儲很發愁。大家都知道，使用 Python 中的列表和字典進行存儲數據是很不靠譜的，所以就想到Python有沒有內置的數據庫模塊。
SQLite3 可使用 sqlite3 模塊與 Python 進行集成。sqlite3 模塊是由 Gerhard Haring 編寫的。它提供了一個與 PEP 249 描述的 DB-API 2.0 規范兼容的 SQL 接口。您不需要單獨安裝該模塊，因為 Python 2.5.x 以上版本默認自帶了該模塊。 為了使用 sqlite3 模塊，您首先必須創建一個表示數據庫的連接對象，然后您可以有選擇地創建光標對象，這將幫助您執行所有的 SQL 語句。
怎么樣，聽起來不錯吧！那就快來學習使用吧。
下面的 Python 代碼顯示了如何連接到一個現有的數據庫。如果數據庫不存在，那么它就會被創建，最后將返回一個數據庫對象。
#-*- coding:utf-8 -*-import sqlite3conn = sqlite3.connect('MySQL_person.db')在這里，您也可以把數據庫名稱復制為特定的名稱 :memory:，這樣就會在 RAM 中創建一個數據庫。現在，讓我們來運行上面的程序，在當前目錄中創建我們的數據庫 mysql_person.db。您可以根據需要改變路徑。保存上面代碼到 sqlite.py 文件中，并按如下所示執行。如果數據庫成功創建，那么會顯示下面所示的消息：$chmod +x sqlite.py$./sqlite.pyOpen database successfully下面的 Python 代碼段將用于在先前創建的數據庫中創建一個表：
#-*- coding:utf-8 -*-import sqlite3conn = sqlite3.connect('mysql_person.db')print "Opened database successfully";conn.execute('''CREATE TABLE MT (ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50), SALARY REAL);''')print "Table created successfully";conn.close()上述程序執行時，它會在 test.db 中創建 MT 表，并顯示下面所示的消息：
Opened database successfullyTable created successfully下面的 Python 程序顯示了如何在上面創建的 MT 表中創建記錄：
#-*- coding:utf-8 -*-import sqlite3conn = sqlite3.connect('mysql_person.db')print "Opened database successfully";conn.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) / VALUES (1, 'Paul', 32, 'California', 20000.00 )");conn.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) / VALUES (2, 'Allen', 25, 'Texas', 15000.00 )");conn.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) / VALUES (3, 'Teddy', 23, 'Norway', 20000.00 )");conn.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) / VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 )");conn.commit()print "Records created successfully";conn.close()上述程序執行時，它會在 MT 表中創建給定記錄，并會顯示以下兩行：
Opened database successfullyRecords created successfully下面的 Python 程序顯示了如何從前面創建的 MT 表中獲取并顯示記錄：
#-*- coding:utf-8 -*-import sqlite3conn = sqlite3.connect('mysql_person.db')print "Opened database successfully";cursor = conn.execute("SELECT id, name, address, salary from MT")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 successfully下面的 Python 代碼顯示了如何使用 UPDATE 語句來更新任何記錄，然后從 COMPANY 表中獲取并顯示更新的記錄：
#-*- coding:utf-8 -*-import sqlite3conn = sqlite3.connect('mysql_person.db')print "Opened database successfully";conn.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 MT")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 successfully下面的 Python 代碼顯示了如何使用 DELETE 語句刪除任何記錄，然后從 COMPANY 表中獲取并顯示剩余的記錄：
#-*- coding:utf-8 -*-import sqlite3conn = sqlite3.connect('mysql_person.db')print "Opened database successfully";conn.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 MT")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新聞熱點
疑難解答
