%@ page contentType="text/html;charset=euc-kr" %>
<%@ include file="/include/in_Import.jsp" %>
<%@ include file="/include/in_Function.jsp" %>
JDCConnectionDriver Error : " + e.toString());
}
}
%>
<%
/*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SESSION
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
String spage = request.getParameter("spage");
if (spage == null)
spage = "1";
int iPage = Integer.parseInt(spage);
String keytype = request.getParameter("keytype");
String keyword = request.getParameter("keyword");
String passkey = request.getParameter("passkey");
String appYn = "";
if ( keytype == null || keytype.equals("") ) {
keytype = "subject";
}
if ( keyword == null || keyword.equals("") ) {
keyword = "";
} else {
keyword = sutil.toEucKr(keyword);
}
if(passkey == null) passkey = "";
int totalCnt = 0; //±ÛÀÇ ÃÑ °¹¼ö
int totalPage; //ÃÑ ÆäÀÌÁö °¹¼ö
int pageSize = 10; //ÇÑÆäÀÌÁö¿¡ º¸¿©ÁÙ ±ÛÀÇ ÃÖ´ë °¹¼ö
int blockSize = 10; //ÇÑ È¸é¿¡ º¸¿©ÁÙ ÃÖ´ë ÆäÀÌÁö °¹¼ö
int blockPage; //ÇÑ È¸é¿¡ º¸¿©Áö´Â ÆäÀÌÁö Áß Ã¹¹ø° ÆäÀÌÁö ¹øÈ£
int start_no = (iPage-1)*pageSize + 1; //ÇØ´ç ÆäÀÌÁöÀÇ Ã¹¹ø° row number
int end_no = iPage*pageSize; //ÇØ´ç ÆäÀÌÁöÀÇ ¸¶Áö¸· row number(ÃÖ´ë°ª)
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ResultSet rtList = null;
try {
StringBuffer query = new StringBuffer();
StringBuffer query_cnt = new StringBuffer();
query_cnt.append("select count(*) from application_installation a, application b where a.no = b.no");
query.append("select * from application_installation a, application b where a.no = b.no");
query.append(" order by a.no desc ");
query.append(" limit ").append(pageSize).append(" offset ").append(start_no-1);
conn = DriverManager.getConnection("jdbc:jdc:jdcpool");
stmt = conn.createStatement();
rs = stmt.executeQuery(query_cnt.toString());
while ( rs.next() ) {
totalCnt = rs.getInt(1);
}
rs.close();
totalPage = ((int) (totalCnt - 1)/pageSize ) + 1;
blockPage = ((int) (iPage -1)/blockSize ) * blockSize + 1;
rtList = stmt.executeQuery(query.toString());
int loopSize = Math.min(blockPage + blockSize, totalPage + 1);
int rowNum = ((loopSize - iPage) * 10) + (totalCnt % 10) - 10;
%>
<%@ page contentType="text/html;charset=euc-kr" %>