<%@ page import="java.sql.*" %> <%! public String toParamStr(String oldStr, String newStr) { try { if (oldStr == null || oldStr.equals("")) { return newStr; } else { return oldStr.trim(); } } catch (Exception e) { return oldStr; } } public String toEucKr(String s) { try { return new String(s.getBytes("iso-8859-1"), "EUC-KR"); } catch (Exception e) { return s; } } %> <% String menuId = request.getParameter("menuId"); if(menuId == null || menuId.equals("")) menuId = "61"; %> <%@ page contentType="text/html;charset=euc-kr" %> <% String spage = request.getParameter("spage"); if (spage == null) spage = "1"; int iPage = Integer.parseInt(spage); PreparedStatement ps = null; ResultSet rs = null; ResultSet rsList = null; String searchPage = toParamStr(request.getParameter("searchPage"), "1"); String searchType = toParamStr(request.getParameter("searchType"), "01"); String searchWord = toEucKr(toParamStr(request.getParameter("searchWord"), "")); String searchLine = toParamStr(request.getParameter("searchLine"), "10"); //한페이지에 보여줄 글의 최대 갯수 String galtype = toParamStr(request.getParameter("galtype"), "3"); String galseason = toParamStr(request.getParameter("galseason"), "0"); int totalCnt = 0; //글의 총 갯수 int totalPage; //총 페이지 갯수 int blockSize = 10; //한 화면에 보여줄 최대 페이지 갯수 int blockPage; //한 화면에 보여지는 페이지 중 첫번째 페이지 번호 int start_no = (Integer.parseInt(searchPage)-1)*Integer.parseInt(searchLine) + 1; //해당 페이지의 첫번째 row number int end_no = Integer.parseInt(searchPage)*Integer.parseInt(searchLine); //해당 페이지의 마지막 row number(최대값) int i = 0 ; String sql = ""; String pt_src = ""; Connection conn = null; try { // 클래스 로드 Class.forName("org.postgresql.Driver"); conn = DriverManager.getConnection("jdbc:postgresql:hanmaum", "postgres", ""); } catch(Exception e) { } sql = " select count(*) as cnt from gallery where type = ? and season = ? "; try { ps = conn.prepareStatement(sql); ps.setString(1, galtype); ps.setString(2, galseason); rs = ps.executeQuery (); if ( rs.next() ) { totalCnt = rs.getInt ("cnt"); } } catch (Exception e) { System.out.println("tqna_List Error : " + e.toString()); } finally { try { if (rs != null) rs.close(); if (ps != null) ps.close(); } catch (Exception e) { System.out.println("Close Error : " + e.toString()); } } totalPage = ( (int) (totalCnt - 1)/Integer.parseInt(searchLine) ) + 1; blockPage = ( (int) (Integer.parseInt(searchPage) -1)/blockSize ) * blockSize + 1; try { sql = " select no, type, title, photo1, photo2, photo3, article, writer, wdate, ip, passwd, hitcnt, state, rpl_no, season "; sql += " from gallery where type = ? and state = '1' and season = ? order by no desc "; ps = conn.prepareStatement(sql); ps.setString(1, galtype); ps.setString(2, galseason); rsList = ps.executeQuery (); } catch (Exception e) { if ( rs != null ) rs.close(); if ( ps != null ) ps.close(); if ( conn != null ) conn.close(); } %> <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 MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function bbsDetail(spage, pid, galtype, galseason) { location.href="./gallery_detail.jsp?spage=" + spage + "&no=" + pid + "&galtype=" + galtype + "&galseason=" + galseason; return; } //--> </script> </head> <body onload="mouseOnEvent('<%= menuId %>');"> <%@ include file="/hanmaum/Intro/01_subimg.jsp" %> <table width="940" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="239" valign="top" id="left"> <!--좌측메뉴--> <%@ include file="/hanmaum/gallery/left_menu.jsp" %> <!--좌측메뉴끝--> </td> <td width="701" align="center" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="gatable"> <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/06_centop01.gif" alt="" width="701" height="56" /></td> </tr> <tr> <td><img src="/hanmaum/Image/gallery_tbanner03.gif" alt="" width="701" height="110" /></td> </tr> <tr> <td height="36"> </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="gatable"> <tr> <td bgcolor="#434343" height="2" colspan="5"></td> </tr> <tr> <td height="6" colspan="5"></td> </tr> <tr> <% if(rsList != null) { while(rsList.next()) { i++; if(rsList.getString(4).length()>2){ pt_src = "./photo/"+rsList.getString(4); } else if(rsList.getString(5).length()>2){ pt_src = "./photo/"+rsList.getString(5); } else if(rsList.getString(6).length()>2){ pt_src = "./photo/"+rsList.getString(6); } %> <td width="20%" align="center"><table width="120" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="90" colspan="2" class="no"><A HREF="javascript:bbsDetail('<%= spage %>','<%= rsList.getString(1) %>','<%= galtype %>', '<%= galseason %>');"><img src="<%= pt_src %>" width="120" height="80" border="0"/></A></td> </tr> <tr> <td height="20" colspan="2" align="left" class="no"><font color="#000000"><%= rsList.getString(3) %></font></td> </tr> <tr> <td width="61" class="no"><%= rsList.getString(9) %></td> <td width="59" align="right" class="no"><%= rsList.getString(12) %></td> </tr> </table></td> <% if (i % 5 == 0) out.println ("</tr><tr><td colspan='5' height='10' class='no'></td></tr><tr><td colspan='5' height='1' bgcolor='#dcdcdc'></td></tr><tr><td colspan='5' height='10' class='no'></td></tr><tr>"); } } if (totalCnt > 0) { } else { %> <td height="24" align="center" bgcolor="#FFFFFF" colspan="5">등록된 게시물이 없습니다.</td> <% } %> </tr> <tr> <td colspan="5" height="10" class="no"></td> </tr> <tr> <td colspan="5" height="1" bgcolor="#dcdcdc"></td> </tr> <tr> <td colspan="5" height="10" class="no"></td> </tr> <tr> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td> <td align="center" class="no"> </td> </tr> </table> <table width="684" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="50" align="right" valign="bottom"> <A HREF="./gallery_write.jsp?galtype=<%= galtype %>&galseason=<%= galseason %>"> <img src="/hanmaum/Image/co_but09.gif" width="68" height="31" border="0"/></A> </td> </tr> </table> </td> </tr> </table> <!--컨텐츠 끝--> </td> </tr> </table> <%@ include file="/hanmaum/bottom.jsp" %>