python数据库连接例子
import sqlite3
conn = sqlite3.connect('food.db')
curs = conn.cursor()
curs.execute('''
CREATE TABLE IF NOT EXISTS food(
id TEXT PRIMARY KEY,
desc TEXT
)
''')
query = 'DELETE FROM food'
print query
curs.execute(query)
query = 'INSERT INTO food VALUES(1, 2)'
print query
curs.execute(query) # sqlite3.IntegrityError: UNIQUE constraint failed: food.id
sqlite3.OperationalError: no such column: A
val = 'a'
query = 'INSERT INTO food VALUES(2, ?)'
print query
curs.execute(query, val)
vals = ['A', 'xyz']
query = 'INSERT INTO food VALUES(?, ?)'
print query
curs.execute(query, vals)
query = 'select * from food'
print query
curs.execute(query)
names = [f[0] for f in curs.description]
print names
for row in curs.fetchall():
for pair in zip(names, row):
print '%s: %s' % pair
print
conn.commit()
conn.close()
food_query.py
import sqlite3, sys
conn = sqlite3.connect('food.db')
curs = conn.cursor()
# run as -> run configurations -> arguments id=1 do not blank!
query = 'select * from food where %s' % sys.argv[1]
print query
curs.execute(query)
names = [f[0] for f in curs.description]
print names
for row in curs.fetchall():
for pair in zip(names, row):
print '%s: %s' % pair
print
conn.commit()
conn.close()
参考:
《python基础教程》
最新文章
- 虚拟机中Linux系统盘空间不足
- LINQ To SQL
- [常见问题]在Linux下执行Redis命令不起作用.
- mysql 性能优化方案 (转)
- C语言中结构体的位域(bit-fields)
- DataGridView key points
- 证码识别--type1
- source insight 注册码
- JS中如何判断null、undefined与NaN
- 4.4 spring-自定义标签的解析
- Java基础知识强化之IO流笔记55:IO流练习之 自定义类模拟LineNumberReader的获取行号功能案例
- vim 编辑器笔记
- js中的两个数字a,b求s=a+aa+aaa+aaaa+aa...a的值,其中a是一个数字。一共b个数字相加,例如用户输入2,5 s=2+22+222+2222+22222
- 【转】Notepad++ 快捷键 大全 官方整理过来的
- [POJ 3150] Cellular Automaton (矩阵高速幂 + 矩阵乘法优化)
- 201521123007《Java程序设计》第13周学习总结
- codeforces 1066 B heater
- topcoder srm 560 div1
- 内联函数inline的用法
- mxonline实战5,用户注册的验证码