# -*- encoding=utf8 -*-
__author__ = "aaaaa"
import time
import sys
import pymysql
import traceback
#from DbConnect import *
def getData():
#conn = connect()
conn = pymysql.connect(user='root', password='root', database='test', charset='utf8')
result = ''
try:
cursor = conn.cursor()
query = ('select id,kind,remark from t_ttt order by id desc limit %s,%s')
cursor.execute(query,(0,10) )#可以不加第二个参数
#只取一条cursor.fetchone()
#全部结果集cursor.fetchall()
#print( cursor.fetchall() )
result = cursor.fetchall()
#也可以直接遍历
#for (id2,kind2) in cursor:
#print(id2, kind2)
cursor.close()
except:
info = sys.exc_info()#采用sys模块回溯最后的异常
print( info[0], ":", info[1])
conn.rollback()
finally:
conn.close()
return result
#返回x条数据被更新
def updateData():
conn = pymysql.connect('127.0.0.1',user='root', password='root', database='test', charset='utf8')
cursor = conn.cursor()
query = ('update w_cookie set token=%s where id=%s')
cursor.execute(query,('3333',7) )
conn.commit() #提交
cursor.close()
conn.close()
return cursor.rowcount
#sys.exit(0)
aa = getData()
print(aa)
print(len(aa))
for item in aa:
print(item[2])
#x = updateData()
#print("%s条记录已更新"%(x))
简单数据库连接,查询、更新数据库表操作