String sql_bl = " select distinct field28 from v_badnessName1 where field24='10' ";
if(!"".equals(star_date))sql_bl +=" and field9>='"+star_date+"'";
if(!"".equals(end_date))sql_bl +=" and field9<='"+end_date+"'";
if(!"".equals(kehu))sql_bl +=" and field23='"+kehu+"'";
if(!"".equals(liaohao))sql_bl +=" and field32='"+liaohao+"'";
rs_bl = df2_data_list.executeQueryDb(sql_bl);
while(rs_bl.next()){想把其中的RS结果集分页,但好像这没的ToP多少条把,该怎么做RS结果集,数据库分页java
if(!"".equals(star_date))sql_bl +=" and field9>='"+star_date+"'";
if(!"".equals(end_date))sql_bl +=" and field9<='"+end_date+"'";
if(!"".equals(kehu))sql_bl +=" and field23='"+kehu+"'";
if(!"".equals(liaohao))sql_bl +=" and field32='"+liaohao+"'";
rs_bl = df2_data_list.executeQueryDb(sql_bl);
while(rs_bl.next()){想把其中的RS结果集分页,但好像这没的ToP多少条把,该怎么做RS结果集,数据库分页java
FROM T043F040
WHERE (ID >
(SELECT MAX(id)
FROM (SELECT TOP 10 id
FROM T043F040
ORDER BY id) AS T))
ORDER BY ID 我的第二次怎么取呢 我用count(*)取到了总条数,但要怎么把他组进上面的语句里,实现分页