详述 DB2 分页查询及 Java 实现的示例

SELECT * FROM 
(
SELECT B.*, ROWNUMBER() OVER() AS TN FROM  
(
SELECT * FROM 表名
) AS B
) AS A 
WHERE A.TN BETWEEN startNum AND endNum; 

 
  
  
  
  
 

 
  
  SELECT * FROM 
  (
  SELECT B.*, ROWNUMBER() OVER() AS TN FROM  
  (
  SELECT * FROM TBL_STORE
  ) AS B
  ) AS A 
  WHERE A.TN BETWEEN #{startNum} AND #{endNum}
 

/**
 * Dao 层代码
 */
@Repository("storeEntityDao")
public interface StoreEntityDao {
  List query4encrypt(Map paramMap);
}

/**
 * Service 层接口代码
 */
public interface StoreEntityService {
  public void query4encrypt();
}

/**
 * Service 层实现代码
 */
@Service("storeEntityService")
public interface StoreEntityServiceImpl implements StoreEntityService {
   @Override
  public void query4encrypt() {
    boolean flag = true;
    Long startNum = 0L;
    Long endNum = 0L;
    Map paramMap = new HashMap();
    while (flag) {
      endNum = startNum + 100;
      paramMap.put("startNum", startNum);
      paramMap.put("endNum", endNum);
      List storeEntityList = StoreEntityDao.query4encrypt(paramMap);
      if (storeEntityList != null && storeEntityList.size() > 0) {
        // 遍历加密数据
        for (StoreEntity storeEntity : storeEntityList) {
          // 加密及持久化处理
        }
      }
      if (storeEntityList != null && storeEntityList.size() >= 100) {
        startNum = endNum++;
      } else {
        flag = false;
      }
    }
  }
}