python连接数据库查询
标签：nbsp 连接 div sqlite cursor rom sel pen tab
python连接数据库查询
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()