python3查询mysql实例

#!/usr/bin/python
# -*- coding: GBK -*-
__author__ = 'Administrator'
import pymysql

con = pymysql.connect(host = 'localhost', user= 'sun', passwd = 'myoa888',port=3336,charset='gb2312',db='TD_OA')
cursor = con.cursor()# 获取操作游标

# SQL 查询语句

sql = """select * from user """
cursor.execute(sql)
ret = cursor.fetchone()  # 提取查询数据
#print(ret)

# SQL 查询语句
sql = "SELECT * FROM USER"
try:
   # 执行SQL语句
   cursor.execute(sql)
   # 获取所有记录列表
   results = cursor.fetchall()
   for row in results:
      fname = row[0]
      lname = row[1]
      age = row[2]
      sex = row[3]
      income = row[4]
       # 打印结果
      print ("fname=%s,lname=%s,age=%s,sex=%s,income=%s" % \
             (fname, lname, age, sex, income ))
except:
   print ("Error: unable to fetch data")
# 关闭数据库连接
con.close()


print ("程序结束,请检查!");