String query  = "SELECT  DVRDAT, DVRSNU, DVRSEQ, TSTDAT, TSTSKB, JMNAM2, CARSNA,"
                   + "    DVRCUD, DVRCOD, DVRTIK, DVRCAD, TSTPAM, DVRMNO, DVRSKB, CUSYNA,"
                   + "    TSTQTY, TSTDAN, TSTAMT, TSTPAM"
                 + "  FROM SALLIBR.SAKKHT"
                     + "  LEFT OUTER JOIN TFTLIBR.INVNDR V1 ON DVRCUD = V1.CUSCOA||V1.CUSCOB"
                     + "  LEFT OUTER JOIN TFTLIBR.SACAMS C1 ON DVRCAD = C1.CARC1||C1.CARC2||C1.CARC3||C1.CARC4"
                     + "  LEFT OUTER JOIN TFTLIBR.INITEM I1 ON DVRCOD = I1.JMCOD1||I1.JMCOD2||I1.JMCOD3||I1.JMCOD4"
                     + "  WHERE DVRSKB LIKE '" + sGubun + "%' AND DVRSNU LIKE '" + sJunno + "%'"
                     + "  AND DVRCUD LIKE '" + sVnrCod + "%' AND DVRCOD LIKE '" + sItemCod + "%';

       if (sSelectg.equals("1")) {
            query = query + " AND SUBSTRING(TSTDAT,1,4)||SUBSTRING(TSTDAT,5,2)||SUBSTRING(TSTDAT,7,2) BETWEEN '"+sFDate+"' AND '"+sTDate+"'";
            query = query + " AND SUBSTRING(DVRDAT,1,4)||SUBSTRING(DVRDAT,5,2)||SUBSTRING(DVRDAT,7,2) BETWEEN '"+sCFDate+"' AND '"+sCTDate+"'";
          query = query + " ORDER BY TSTDAT, DVRCUD, DVRSNU,  DVRCOD, DVRSEQ, TSTSKB";

         }
       else if (sSelectg.equals("2")) {
            query = query + " AND SUBSTRING(TSTDAT,1,4)||SUBSTRING(TSTDAT,5,2)||SUBSTRING(TSTDAT,7,2) BETWEEN '"+sFDate+"' AND '"+sTDate+"'";
            query = query + " AND SUBSTRING(DVRDAT,1,4)||SUBSTRING(DVRDAT,5,2)||SUBSTRING(DVRDAT,7,2) BETWEEN '"+sCFDate+"' AND '"+sCTDate+"'";
          query = query + " ORDER BY DVRDAT, DVRSNU, TSTDAT,  DVRSEQ, DVRCOD, TSTSKB";
           }
       else if (sSelectg.equals("3")) {
            query = query + " AND SUBSTRING(TSTDAT,1,4)||SUBSTRING(TSTDAT,5,2) = '"+sTYMDate+"'";
            query = query + " AND SUBSTRING(DVRDAT,1,4)||SUBSTRING(DVRDAT,5,2)||SUBSTRING(DVRDAT,7,2) BETWEEN '"+sCFDate+"' AND '"+sCTDate+"'";
          query = query + " ORDER BY DVRCUD, TSTDAT, DVRSNU,  DVRCOD, DVRSEQ, TSTSKB";
         }


현재 jsp이용해서 프로그램 개발을 하고 있습니다.
그런데, 이것을 한 페이지에 보여주다 보니..기간설정이 크면 읽어오는 데이터 양이 많아서 그런지 뿌려주는 속도가 넘 느립니다.
그래서 페이징을 해보려고 하는데..

rownum이나 limit등..다른 문들도 상관은 없습니다.

표기 할 수 있는 방법이 없을까요..