<%@ 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" /> <%@ page contentType="text/html;charset=euc-kr" %> <% String textfield = request.getParameter("textfield"); textfield = sutil.toEucKr(textfield); if(textfield == null) textfield = ""; %> <%! 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); 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 zip_code"); if(textfield != null && !textfield.equals("")) { query_cnt.append(" where address like '%"+ textfield +"%' "); } else { query_cnt.append(" where 1 = 0 "); } query.append("select * from zip_code where address like '%"+ textfield +"%'"); 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()); %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=euc-kr" /> <link rel="stylesheet" href="Common/hstyle.css" type="text/css"> <title>우편번호 검색</title> <script language="javascript"> <!-- function onSearch() { var frm = document.form1; frm.action = "post_search.jsp"; frm.target = "_self"; frm.submit(); } function bbsList(spage, keytype, keyword) { location.href="post_search.jsp?spage=" + spage + "&keytype=" + keytype + "&textfield=" + keyword; return; } function onSetPostNo(postNo, addr) { opener.onSetPostNo(postNo,addr); self.close(); } function onLoad() { document.form1.textfield.focus(); } //--> </script> </head> <STYLE type=text/css> body { background-color:#ffffff; margin: 13px 0px; text-align:center; } --> </STYLE> <body onload="javascript:onLoad();"> <form name="form1" method="post"> <table width="448" border="0" cellspacing="0" cellpadding="0"> <tr> <td><img src="Image/ha_0sc05.gif" width="448" height="62"></td> </tr> <tr> <td height="200" align="center" valign="top" background="Image/ha_0sc09.gif"><br> <table width="90%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="30">찾고자 하는 주소의 동/읍/면 이름을 입력하세요.</td> </tr> <tr> <td id="ma1"> </td> </tr> <tr> <td> <table width="100%" border="0" cellspacing="0" cellpadding="0" style="padding:4 0 0 10"> <tr> <td height="2" colspan="2" background="Image/ha_backc01.gif"></td> </tr> <tr> <td width="50%" height="30">동(읍/면)</td> <td width="50%"> <input name="textfield" type="text" id="textfield" value="<%=textfield%>" size="20"> <a href="javascript:onSearch();"> <img src="Image/ha_but_s07.gif" width="36" height="17" align="absmiddle" border="0" /> </a> </td> </tr> <tr> <td height="2" colspan="2" background="Image/ha_backc01.gif"></td> </tr> </table> </td> </tr> <tr> <td> </td> </tr> </table> <table width="90%" border="0" cellspacing="0" cellpadding="0"> <% if (totalCnt > 0) { int i = totalCnt; int no = 0; String postNo = ""; String address = ""; String detail = ""; while (rtList.next()) { postNo = rtList.getString("zip_code"); address = rtList.getString("address"); detail = rtList.getString("detail"); %> <tr> <td width="16%" height="30"><%= postNo.substring(0, 3) %> - <%= postNo.substring(3, 6) %></td> <td width="84%" align="left"> <a href="javascript:onSetPostNo('<%=postNo%>','<%= address %><%=detail%>');"> <%= address %> <%=detail%></a> </td> </tr> <% } } else { %> <tr> <td colspan="2" align="center">주소가 없습니다.</td> </tr> <% } %> </table> </td> </tr> <tr> <td height="26" align="center" background="Image/ha_0sc09.gif"> <% //이전 페이지 if ( iPage == 1 ) { %> <img src="/images/ic_spre.gif" width="6" height="8"> <% } else { %> <a href="javascript:bbsList('<%=iPage-1%>', '', '<%=textfield%>')";> <img src="/images/ic_spre.gif" width="6" height="8" border="0"> </a> <% } // 페이지 Loop int loopSize = Math.min(blockPage + blockSize, totalPage + 1); for ( int j=blockPage; j<loopSize ; j++ ) { if (spage.equals(j+"")) { %> <a href="javascript:bbsList('<%=j%>', '', '<%=textfield%>')";><strong>[<%=j%>]</strong></a> <% } else { %> <a href="javascript:bbsList('<%=j%>', '', '<%=textfield%>')";>[<%=j%>]</a> <% } } /*----------------------------------------- 다음 페이지 -----------------------------------------*/ if ( iPage == totalPage ) { %> <img src="/images/ic_snex.gif" width="6" height="8"> <% } else { %> <a href="javascript:bbsList('<%=iPage+1%>', '', '<%=textfield%>')";><img src="/images/ic_snex.gif" width="6" height="8" border="0"></a> <% } %> </td> </tr> <tr> <td height="26" align="center" background="Image/ha_0sc09.gif"> <a href="javascript:self.close();"> <img src="Image/ha_but_l41.gif" width="59" height="21" border="0" /> </a> </td> </tr> <tr> <td><img src="Image/ha_0sc08.gif" width="448" height="11"></td> </tr> </table> <br /> </form> </body> </html> <% 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 >> Exception : " + e.toString()); } %>