<% /*============================================================================================== * Project Title : * File Name : * Include : * Used DB Table : notice * Used Class : * Description : °Ô½ÃÆÇ ¸®½ºÆ® * Programmer : °­ÁÖ¿ë * First Write : 2010.04.28 * Last Update : ==============================================================================================*/ %> <%@ page contentType="text/html;charset=euc-kr" %> <%@ include file="/include/in_Import.jsp" %> <%@ include file="/include/in_Function.jsp" %> <% int PageAuth = 1; String menuId = request.getParameter("menuId"); if(menuId == null || menuId.equals("")) menuId = "42"; %> <%! static { try { new kr.co.slight.jinhae.pool.JDCConnectionDriver("org.postgresql.Driver","jdbc:postgresql:hanmaum","postgres",""); } catch(Exception e) { System.out.println("

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"); if ( keytype == null || keytype.equals("") ) { keytype = "subject"; } if ( keyword == null || keyword.equals("") ) { keyword = ""; } else { keyword = sutil.toEucKr(keyword); } 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(); if ( keyword == null || keyword.equals("") ) { query_cnt.append(" SELECT COUNT(*) FROM ( "); query_cnt.append(" SELECT A.NO, A.SUBJECT, A.REG_DT, A.NAME, A.VIEW_CNT, A.STATE "); query_cnt.append(" FROM NOTICE A "); query_cnt.append(" WHERE A.STATE = '2' "); query_cnt.append(" UNION ALL "); query_cnt.append(" SELECT B.NO, '', NOW(), '', 0, '0' "); query_cnt.append(" FROM NOTICE_RPL B "); query_cnt.append(" ) A "); query_cnt.append(" LEFT OUTER JOIN NOTICE_RPL B "); query_cnt.append(" ON A.NO = B.NO "); query.append(" SELECT A.NO, A.SUBJECT, COALESCE(TO_CHAR(A.REG_DT,'YYYY-MM-DD'),'') AS REG_DT, A.NAME, A.VIEW_CNT, A.STATE FROM ( "); query.append(" SELECT A.NO, A.SUBJECT, A.REG_DT, A.NAME, A.VIEW_CNT, A.STATE "); query.append(" FROM NOTICE A "); query.append(" WHERE A.STATE = '2' "); query.append(" UNION ALL "); query.append(" SELECT B.NO, '', B.REG_DT, '', B.VIEW_CNT, '0' "); query.append(" FROM NOTICE_RPL B "); query.append(" ) A "); query.append(" LEFT OUTER JOIN NOTICE_RPL B "); query.append(" ON A.NO = B.NO "); query.append(" ORDER BY A.NO DESC , A.STATE DESC "); query.append(" limit ").append(pageSize).append(" offset ").append(start_no-1); } else { query_cnt.append("select count(*) "); query_cnt.append(" from notice "); query_cnt.append(" where ").append(keytype).append(" like '%").append(keyword).append("%'"); query_cnt.append(" and state = '2' "); query.append("select * "); query.append(" from notice "); query.append(" where ").append(keytype).append(" like '%").append(keyword).append("%' "); query.append(" and state ='2' "); query.append(" order by no desc "); query.append(" limit ").append(pageSize).append(" offset ").append(start_no-1); } conn = DriverManager.getConnection("jdbc:postgresql:hanmaum", "postgres", ""); 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; %> <%@ include file="/hanmaum/Cs/04_subimg.jsp" %>

<%@ include file="/hanmaum/Cs/left_menu.jsp" %>

Ȩ > °í°´¼¾ÅÍ > Áú¹®°ú´äº¯   <% if (totalCnt > 0) { int i = totalCnt; int no = 0; String subject = ""; String regdate = ""; String view_cnt = ""; String name = ""; String state = ""; while (rtList.next()) { no = rtList.getInt("no"); regdate = rtList.getString("reg_dt"); if(!regdate.equals("")){ regdate = rtList.getString("reg_dt").toString().substring(0, 10); } name = rtList.getString("name"); view_cnt = rtList.getString("view_cnt"); state = rtList.getString("state"); if(state.equals("2")){ //2À϶§¸¸ °ªÀ» ³Ö´Â´Ù. subject = rtList.getString("subject"); subject = cutoffString(subject, 80); } %> <% } } else { %> <% } %> <%= rowNum-- %> <%if(state.equals("0")){%>[´äº¯]<%}%> <%= subject %> <%if(state.equals("0")){%>°ü¸®ÀÚ<%}else{%><%= name %><%}%> <%if(regdate.equals("")){%> <%}else{%><%= regdate %><%}%> <%= view_cnt %> µî·ÏµÈ °Ô½Ã¹°ÀÌ ¾ø½À´Ï´Ù. <% //ÀÌÀü ÆäÀÌÁö if ( iPage == 1 ) { %> <% } else { %> <% } // ÆäÀÌÁö Loop for ( int j=blockPage; j [<%=j%>] <% } else { %> [<%=j%>] <% } } /*----------------------------------------- ´ÙÀ½ ÆäÀÌÁö -----------------------------------------*/ if ( iPage == totalPage ) { %> <% } else { %> <% } %>

<%@ include file="/hanmaum/bottom.jsp" %> <% rs.close(); stmt.close(); conn.close(); } catch (Exception e) { if ( rs != null ) rs.close(); if ( stmt != null ) stmt.close(); if ( conn != null ) conn.close(); // ¿¡·¯ÆäÀÌÁö·Î À̵¿............ out.println("JSP >> Slight Exception in /Cs/csnot01.jsp : " + e.toString()); } %>