一般情况下数据库数据量太大的时候,不宜全部读取到内存中。所以这里做一个简单的上下翻页的程序。
# !/usr/bin/python
# -*- coding:utf-8 -*-
# ++++++++++++++++++++
# author: FMspider
# time: 2018-5-28 13:54
# function: 翻页
import pymysql
# 执行SQL语句获取数据库数据
def sqlexec(last_nid,is_is):
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='****', db='***', charset='utf8' )
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
if is_is:
cursor.execute('select * from image where id>%s limit 10',last_nid)
result = cursor.fetchall()
else:
cursor.execute('select * from image where id<%s order by id desc limit 10 ', last_nid)
result = cursor.fetchall() # 获取的数据是反的
result = list(reversed(result)) # 翻转一下
conn.c