java DAO代码如下
public List getPlantOrder(int pageIndex,int pageSize) {
int start=(pageIndex)*pageSize+1;
int end=(pageIndex+1)*pageSize;
System.out.println("start:"+start+" , end :"+end);
String sql="select * from (select ROWNUM rn,v.PDATE ,v.UNITNAME NAME,v.VALUE,v.PLANORDER"+
" from ops_osb.v_unit_planorder v) result "+
" where result.rn between ? and ?";
List list= getJdbcTemplate().queryForList(sql,start,end);
System.out.println("机组排序表查出条数:"+list.size());
return list;