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등..다른 문들도 상관은 없습니다.
표기 할 수 있는 방법이 없을까요.. |