在Python里操作sqlite

引入sqlite3模块，连接数据库，并创建游标。

>>> import sqlite3
>>> conn=sqlite3.connect (r'd:\python\actress')
>>> cur=conn.cursor()

创建一个演员表

>>> cur.execute ('''create table Actress(
	ID INTEGER PRIMARY KEY AUTOINCREMENT,
	Name varchar(10) NOT NULL,
	Age INTEGER NOT NULL)''')
<sqlite3.Cursor object at 0x000001BA54CA6570>

ID是integer 主键，且是自增的。

>>> cur.execute('''insert into Actress values
	(NULL,'王菲',47),
	(NULL,'柳岩',36),
	(NULL,'范冰冰',37)''')
<sqlite3.Cursor object at 0x000001BA54CA6570>

一次插入三个记录。

>>> cur.execute("select * from Actress")
<sqlite3.Cursor object at 0x000001BA54CA6570>
>>> cur.fetchall()
[(1, '王菲', 47), (2, '柳岩', 36), (3, '范冰冰', 37)]
>>> conn.commit ()

达到目的，并提交修改。

练习一下删除操作

>>> cur.execute ("delete from Actress where Name='王菲'")
<sqlite3.Cursor object at 0x000001BA54CA6570>
>>> cur.execute("select * from Actress")
<sqlite3.Cursor object at 0x000001BA54CA6570>
>>> cur.fetchall()
[(2, '柳岩', 36), (3, '范冰冰', 37)]
>>> conn.commit()

再增加一条记录

>>> cur.execute("insert into Actress values(NULL,'赵薇',41)")
<sqlite3.Cursor object at 0x000001BA54CA6570>
>>> conn.commit()
>>> cur.execute("select * from Actress")
<sqlite3.Cursor object at 0x000001BA54CA6570>
>>> cur.fetchall()
[(2, '柳岩', 36), (3, '范冰冰', 37), (4, '赵薇', 41)]

关闭连接，游标也会自动关闭。

>>> conn.close()

 

转载于:https://my.oschina.net/u/3243928/blog/895432