-- 取数据
count = cursor.execute("select * from goods;")
print("查询到%d条数据"% count)
print(cursor.fetchone()) #取一条数据
print(cursor.fetchmany()) #取一条
print(cursor.fetchmany(3)) # 传几取几条
print(cursor.fetchall()) #取所有
print(cursor.fetchall())#取所有
取两次所有的结果
line_content = cursor.fetchone()
print(line_content)（显示元组（））
-- 索引
print(line_content[0])
print(line_content[1])
print(line_content[2])
-- 循环line_content:
for temp in line_content:
print(temp)
-- fetchmany循环
lines = cursor.fetchmany(5)
for temp in lines:
print(temp)
# 关闭Cursor对象
cursor.close() #关闭游标
conn.close()
print(cursor.fetchone(),'-------------->')
count = cursor.execute("select * from goods;")
