关于Python操作SQLite数据库的方法步骤详解

这篇文章主要介绍了Python操作SQLite数据库的方法,较为详细的分析了Python安装sqlite数据库模块及针对sqlite数据库的常用操作技巧,需要的朋友可以参考下

# Never do this -- insecure 会导致注入攻击
pid=200
c.execute("... where pid = '%s'" % pid) 

for t in[(0,10,'abc','Yu'),(1,20,'cba','Xu')]:
  cx.execute("insert into catalog values (?,?,?,?)", t) 

In [10]: cu.fetchall()
Out[10]: [(0, 10, u'abc', u'Yu'), (1, 20, u'cba', u'Xu')] 

In [12]: cu.execute("update catalog set name='Boy' where id = 0")
In [13]: cx.commit() 

cu.execute("delete from catalog where id = 1") 
cx.commit() 

x=u'鱼'
cu.execute("update catalog set name=? where id = 0",x)
cu.execute("select * from catalog")
cu.fetchall()
[(0, 10, u'\u9c7c', u'Yu'), (1, 20, u'cba', u'Xu')] 

In [26]: for item in cu.fetchall():
  ....:   for element in item:
  ....:     print element,
  ....:   print
  ....: 
0 10 鱼 Yu
1 20 cba Xu 

In [30]: cx.row_factory = sqlite3.Row
In [31]: c = cx.cursor()
In [32]: c.execute('select * from catalog')
Out[32]: <sqlite3.Cursor object at 0x05666680>
In [33]: r = c.fetchone()
In [34]: type(r)
Out[34]: <type 'sqlite3.Row'>
In [35]: r
Out[35]: <sqlite3.Row object at 0x05348980>
In [36]: print r
(0, 10, u'\u9c7c', u'Yu')
In [37]: len(r)
Out[37]: 4
In [39]: r[2]      #使用索引查询
Out[39]: u'\u9c7c'
In [41]: r.keys()
Out[41]: ['id', 'pid', 'name', 'nickname']
In [42]: for e in r:
  ....:   print e,
  ....: 
0 10 鱼 Yu 

In [43]: r['id']
Out[43]: 0
In [44]: r['name']
Out[44]: u'\u9c7c' 

以上就是关于Python操作SQLite数据库的方法步骤详解的详细内容，更多请关注Gxl网其它相关文章！

查看更多关于关于Python操作SQLite数据库的方法步骤详解的详细内容...