python连接数据库查询

python连接数据库查询

import sqlite3 as db

conn = db.connect(r'D:/data/test.db')
print ('Opend database successfully \n')
#conn.row_factory = db.Row
cursor = conn.cursor()
results = cursor.execute("select * from Meter")
rows = cursor.fetchall()
for row in rows:
  print(row)#"%s %s %s" % (row["id"], row["No"], row["Name"])
  print('\n')
print ('close database successfully')
conn.close()

 

posted on 2017-06-28 17:33 Zing_Z 阅读(...) 评论(...) 编辑 收藏