首页 > 代码库 > python连接数据库查询

python连接数据库查询

import sqlite3 as db

conn = db.connect(rD:/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()

 

python连接数据库查询