<%@ page contentType="text/html;charset=euc-kr" %> <%@ include file="/include/in_Import.jsp" %> <%@ include file="/include/in_Function.jsp" %> <jsp:useBean id="sutil" class="kr.co.slight.jinhae.util.GYUtil" scope="page" /> <% String menuId = request.getParameter("menuId"); if(menuId == null || menuId.equals("")) menuId = "35"; %> <%! static { try { new kr.co.slight.jinhae.pool.JDCConnectionDriver("org.postgresql.Driver","jdbc:postgresql:hanmaum","postgres",""); } catch(Exception e) { System.out.println("<br><br>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"); 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" %> <jsp:include page="/hanmaum/top.jsp" flush="false"/> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="ko" xml:lang="ko"> <head> <meta http-equiv="Content-Type" content="text/html; charset=euc-kr" /> <link rel="stylesheet" href="/hanmaum/Common/hstyle.css" type="text/css"> <title>무제 문서</title> <script type="text/javascript"> <!-- function onPass() { if("<%= passkey %>" == "") { alert('잘못된경로로 접근하셨습니다.'); location.href = "http://www.scgoneheart.co.kr/"; } } function onViewPage(no) { var frm = document.form1; frm.no.value = no; frm.target = "_new"; frm.action = "accou05_view.jsp"; frm.submit(); } function bbsList(spage, keytype, keyword) { location.href="accou05_list.jsp?spage=" + spage + "&keytype=" + keytype + "&keyword=" + keyword + "&passkey=<%= passkey %>"; return; } function onSubmit(cmdCode) { var frm = document.form1; if(confirm("선택된 게시물을 삭제하시겠습니까?")) { frm.cmd.value = cmdCode; frm.action = "accou05_list_ok.jsp"; frm.target = "_self"; frm.submit(); } } function onSubmitU(cmdCode) { var frm = document.form1; if(confirm("승인여부를 등록하시겠습니까?")) { frm.cmd.value = cmdCode; frm.action = "accou05_list_ok.jsp"; frm.target = "_self"; frm.submit(); } } //--> </script> </head> <body onload="mouseOnEvent('<%= menuId %>');onPass();"> <%@ include file="/hanmaum/Cs/04_subimg.jsp" %> <form name="form1" action=""> <input type="hidden" name="passkey" value="<%= passkey %>" /> <input type="hidden" name="cmd" value="" /> <input type="hidden" name="no" value="" /> <table width="940" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="239" valign="top" id="left"> <!--좌측메뉴--> <%@ include file="/hanmaum/Accou/left_menu.jsp" %> <!--좌측메뉴끝--> </td> <td width="701" align="center" valign="top"> <!--컨텐츠 시작--> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="25" align="right" valign="bottom" id="ma1"><img src="/hanmaum/Image/location.gif" width="51" height="13" align="absmiddle"> 홈 > 이용안내 > 신청서작성</td> </tr> <tr> <td><img src="/hanmaum/Image/03_centop05.gif" alt="" width="701" height="56" /></td> </tr> <tr> <td height="36"> </td> </tr> </table> <table width="680" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="14"><img src="/hanmaum/Image/04_cen01.gif" alt="" width="14" height="32" /></td> <td width="50" align="center" background="/hanmaum/Image/04_cen03.gif"><img src="/hanmaum/Image/04_cen07.gif" alt="" width="20" height="11" /></td> <td width="477" align="center" background="/hanmaum/Image/04_cen03.gif"><img src="/hanmaum/Image/04_cen08.gif" alt="" width="20" height="12" /></td> <td width="125" align="center" background="/hanmaum/Image/04_cen03.gif"><img src="/hanmaum/Image/04_cen10.gif" alt="" width="29" height="12" /></td> <td width="14"><img src="/hanmaum/Image/04_cen02.gif" alt="" width="14" height="32" /></td> </tr> </table> <table width="680" border="0" cellspacing="0" cellpadding="0" class="fqtable"> <% if (totalCnt > 0) { int i = totalCnt; int no = 0; String subject = ""; String regdate = ""; String appYn = ""; while (rtList.next()) { no = rtList.getInt("no"); subject = rtList.getString("company_name"); regdate = rtList.getString("reg_dt").toString().substring(0, 10); appYn = rtList.getString("app_yn"); subject = cutoffString(subject, 80); if(appYn == null) appYn = ""; %> <tr> <td width="64" height="26" align="center"> <input type="checkbox" name="chk" id="ch1" value="<%= no %>" /> <%= rowNum-- %> </td> <td width="400" align="left"> <a href="javascript:onViewPage('<%= no %>')"> <%= subject %> </a> </td> <td width="77" height="26" align="center"> <select name="appYn"> <option value="" <%= appYn.equals("")?"selected":"" %>>선택</option> <option value="N" <%= appYn.equals("N")?"selected":"" %>>불가</option> <option value="Y" <%= appYn.equals("Y")?"selected":"" %>>승인</option> <option value="S" <%= appYn.equals("S")?"selected":"" %>>완료</option> </select> <input type="hidden" name="seqNo" value="<%= no %>" /> </td> <td width="139" align="center"><%= regdate %></td> </tr> <% } } else { %> <tr> <td colspan="3" align="center">등록된 게시물이 없습니다.</td> </tr> <% } %> <tr> <td height="3" colspan="3" id="gc"></td> </tr> </table> <table width="680" border="0" cellspacing="0" cellpadding="0" border='1'> <tr> <td height="20" colspan="3" align="center" valign="bottom"> <% //이전 페이지 if ( iPage == 1 ) { %> <img src="/images/ic_spre.gif" width="6" height="8"> <% } else { %> <a href="javascript:bbsList('<%=iPage-1%>', '<%=keytype%>', '<%=keyword%>')";> <img src="/images/ic_spre.gif" width="6" height="8" border="0"> </a> <% } // 페이지 Loop for ( int j=blockPage; j<loopSize ; j++ ) { if (spage.equals(j+"")) { %> <a href="javascript:bbsList('<%=j%>', '<%=keytype%>', '<%=keyword%>')";><strong>[<%=j%>]</strong></a> <% } else { %> <a href="javascript:bbsList('<%=j%>', '<%=keytype%>', '<%=keyword%>')";>[<%=j%>]</a> <% } } /*----------------------------------------- 다음 페이지 -----------------------------------------*/ if ( iPage == totalPage ) { %> <img src="/images/ic_snex.gif" width="6" height="8"> <% } else { %> <a href="javascript:bbsList('<%=iPage+1%>', '<%=keytype%>', '<%=keyword%>')";><img src="/images/ic_snex.gif" width="6" height="8" border="0"></a> <% } %> </td> </tr> <tr> <td height="20" colspan="3" valign="bottom" align="right"> <a href="javascript:onSubmit('D');"> <img src="../Image/04_but17.gif" border="0"> </a> <a href="javascript:onSubmitU('U')"> <img src="../Image/04_but16.gif" border="0"> </a> </td> </tr> </table> <!--컨텐츠 끝--> </td> </tr> </table> </form> <%@ include file="/hanmaum/bottom.jsp" %> <% if ( rs != null ) rs.close(); if ( stmt != null ) stmt.close(); if ( conn != null ) 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()); } %>