python2.7连接数据库如何关闭cursor

Question

cursor.close()
报错说IndentationError: Unexpected indent

#encoding:utf8
import sys
reload(sys)
sys.setdefaultencoding('utf8')
import MySQLdb
try:
conn=MySQLdb.connect(host='127.0.0.1',port=3306,user='root', passwd='123456',db='sjy1',charset='utf8')
sql="select * from flower"
cur=conn.cursor()
cur.execute(sql)
data=cur.fetchone()
cur.close() #就这句话
conn.close()
print data[2]
except Exception,e:
print e

Answer 1

错误是你的代码没有对齐
cur.close() 这一行前面是否跟其他行对齐的