sqlite有一件事让我很吃惊,它竟然只有一个可执行文件,而且是那么的小。虽然之前早有耳闻sqlite是多么的轻量级,但确实想不到,竟然小到了这中地步。
python内建了对sqlite数据库的操作模块,一下代码是最最基本的一些使用。(第一次写操作数据库的代码,应该有很多问题,不过已经能够演示)
Python语言 : 临时自用代码
import
sqlite3
conn = sqlite3 . connect( "d:/sqlite/test.db")
cur = conn . cursor()
cur . execute( "drop table person")
cur . execute( """create table person
(id integer primary key,
name varchar(10) UNIQUE)""")
cur . execute( "insert into person values(1, 'Zhang')")
cur . execute( "insert into person values(2, 'Lee')")
cur . execute( "select * from person")
for item in cur . fetchall ():
print item
cur . close()
conn . close()
conn = sqlite3 . connect( "d:/sqlite/test.db")
cur = conn . cursor()
cur . execute( "drop table person")
cur . execute( """create table person
(id integer primary key,
name varchar(10) UNIQUE)""")
cur . execute( "insert into person values(1, 'Zhang')")
cur . execute( "insert into person values(2, 'Lee')")
cur . execute( "select * from person")
for item in cur . fetchall ():
print item
cur . close()
conn . close()