sqlite3

sqlite3.connect(database [,timeout ,other optional arguments])
该API打开一个到SQLite数据库文件database的连接
如果给定的数据库名称 filename 不存在，则该调用将创建一个数据库。
conn = sqlite3.connect('test.db')
conn = sqlite3.connect(':memory:')#在RAM中创建一个数据库

connection.cursor([cursorClass])
该例程创建一个 cursor，将在 Python 数据库编程中用到。

cursor.execute(sql [, optional parameters])
该例程执行一个 SQL 语句。
例如：cursor.execute("insert into people values (?, ?)", (who, age))

以下c是cursor
conn是conncet

创建表
c = conn.cursor()#创建光标，光标用来执行SQL语言
c.execute('''CREATE TABLE COMPANY
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL);''')#创建表COMPANY

插入记录
c.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Paul', 32, 'California', 20000.00 )");向表COMPANY插入记录

读取记录
cursor = c.execute("SELECT id, name, address, salary from COMPANY")#从表COMPANY中获得记录

for row in cursor:
   print "ID = ", row[0]
   print "NAME = ", row[1]
   print "ADDRESS = ", row[2]
   print "SALARY = ", row[3], "\n"

修改某条记录
c.execute("UPDATE COMPANY set SALARY = 25000.00 where ID=1")

删除记录
c.execute("DELETE from COMPANY where ID=2;")

提交
conn.commit()

关闭
conn.commit()