python注释与代码风格

【实例】
获取要用元组的下标索引，与插入不同的是要处理结果集

import pymysql
# 创建连接
con = pymysql.connect(host='localhost', password='root', user='root', database='testmysql', port=3306)
# 创建事务
cur = con.cursor()
# 编写查询的sql
sql = 'select * from student'
# 执行sql
try:
    cur.execute(sql)
    # 处理结果集
    stu = cur.fetchone()
    print(stu)
    students = cur.fetchall()
    for student in students:    # 获取要用下标，索引从0开始
        sno = student[0]
        sname = student[1]
        sex = student[2]
        age = student[3]
        score = student[4]
        print('sno:', sno, 'sname:', sname, 'age:', age, 'sex:', sex, 'age:', age,  'score:', score)
except Exception as e:
    print(e)
    print('查询失败')
finally:
    cur.close()
    con.close()

---

转载请注明来源，欢迎指出任何有错误或不够清晰的表达。可以邮件至gxnucgb@qq.com