展开全部
基础参数为START和LIMIT ,这两个参数控制SQL语句进行分页,例如:
sqlstr = "select top " + limit + " * from EachStorageInfo where Dev_Mac not in (select top " + start + " Dev_Mac from EachStorageInfo where Client_Part = '" + cspname + "'and In_Time <> 'null' and Out_Time = 'null') and Client_Part = '" + cspname + "'and In_Time <> 'null' and Out_Time = 'null' and Dev_State = '" + state + "'";
这是后台数据库分页,还有一种是前台分页;
sqlstr = "select top " + limit + " * from EachStorageInfo where Dev_Mac not in (select top " + start + " Dev_Mac from EachStorageInfo where Client_Part = '" + cspname + "'and In_Time <> 'null' and Out_Time = 'null') and Client_Part = '" + cspname + "'and In_Time <> 'null' and Out_Time = 'null' and Dev_State = '" + state + "'";
这是后台数据库分页,还有一种是前台分页;
参考资料: http://blog.csdn.net/Brian_13402890424/article/details/4595498
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询