sqlserver翻页

List list_params = new ArrayList();

sql.append(" SELECT tab.id,tab.party_name,tab.party_pic FROM ( ");

sql.append(" select TOP " + pageSize*pageNum );sql.append(" tal.*, ROW_NUMBER() OVER(Order by tal.publish_time DESC ) AS RowNumber ");

sql.append(" from ( SELECT DISTINCT cp.id,cp.party_name,cp.party_pic ,cp.publish_time FROM ");

sql.append(" WDJ_CONTACTS_PARTY as cp,WDJ_CONTACTS_PARTY_DEPT _dep ");

sql.append(" WHERE cp.state=1 AND _dep.contacts_party_id = cp.id ");

if(party_name!=null&&!"".equals(party_name)){sql.append(" AND cp.party_name like ? ");

list_params.add( "%" + party_name + "%");}

sql.append(" AND _dep.department_id IN ( ");

sql.append(" SELECT con_dep.department_id FROM contacts_dep con_dep,Contacts con WHERE ");

sql.append(" con.contacts_id = con_dep.contacts_id AND con_dep.contacts_id = ? ");

list_params.add(from.getContacts_id());

sql.append(" ) ) AS tal) as tab WHERE tab.RowNumber > " + (pageNum-1)*pageSize);