python3.4使用循环的实例详解

#!/usr/bin/env python# -*- coding:utf-8 -*-# __author__ = "blzhu""""python study
Date：2017"""import pymysql# import MySQLdb #python2中的产物try:# 获取一个数据库连接，注意如果是UTF-8类型的，需要制定数据库conn = pymysql.connect(host='localhost', user='root', passwd='root', db='zbltest1', port=3306, charset='utf8')
    cur = conn.cursor()  # 获取一个游标for i in range(1, 10):
        zbl_id = str(i)
        zbl_name = 'zbl'+str(i)
        zbl_gender = 'man'# print("%s,%s,%s" % (zbl_id,zbl_name,zbl_gender))# sql = "insert student VALUES (id='%s',name='%s',gender='%s')" % (zbl_id,zbl_name,zbl_gender)sql = "insert student VALUES ('%s','%s','%s')" % (zbl_id, zbl_name, zbl_gender)# print(sql)        
        cur.execute(sql)
    conn测试数据mit()# 将数据写入数据库# try:# cur.execute(sql)# cur测试数据mit()# except:
    #     cur.rollback()#cur.execute("""INSERT INTO 'student' ('id','name','gender') VALUES (%s,%s,%s ,(zbl_id,zbl_name,zbl_gender,))""")#cur.execute("""INSERT INTO 'student' ('id','name','gender') VALUES (zbl_id,zbl_name,zbl_gender)""")
    # cur.execute("INSERT student VALUES (zbl_id,zbl_name,zbl_gender)")# cur.execute("INSERT student VALUES ('4', 'zbl4', 'man')")# 正确#cur.execute("INSERT INTO 'student' ('id','name','gender') VALUES ('4', 'zbl4', 'man')")
    #错误#cur.execute("INSERT  student ('id','name','gender') VALUES ('4', 'zbl4', 'man')")cur.execute('select * from student')# data=cur.fetchall()for d in cur:
    # 注意int类型需要使用str函数转义print("ID: " + str(d[0]) + '  名字： ' + d[1] + "  性别： " + d[2])print("row_number:", (cur.rownumber))# print('hello')cur.close()  # 关闭游标conn.close()  
    # 释放数据库资源except  Exception:print("发生异常") 

查看更多关于python3.4使用循环的实例详解的详细内容...