무제 문서

<%@ 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 = "11"; %> <%@ page contentType="text/html;charset=euc-kr" %> <% Connection conn = null; try { // 클래스 로드 Class.forName("org.postgresql.Driver"); conn = DriverManager.getConnection("jdbc:postgresql:hanmaum", "postgres", ""); } catch(Exception e) { } 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 todate = ""; String galtype = toParamStr(request.getParameter("galtype"), "2"); String galseason = toParamStr(request.getParameter("galseason"), "1"); 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(최대값) String query = "select now() as sysdate "; ps = conn.prepareStatement(query); rs = ps.executeQuery (); while ( rs.next() ) { todate = rs.getString("sysdate"); } rs.close(); String sql = ""; sql = " select count(*) as cnt from gallery where type = '1' "; try { ps = conn.prepareStatement(sql); 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, article, writer, wdate, ip, passwd, hitcnt, state "; sql += " from qna where type = '1' and state = '1' "; ps = conn.prepareStatement(sql); rsList = ps.executeQuery (); } catch (Exception e) { if ( rs != null ) rs.close(); if ( ps != null ) ps.close(); if ( conn != null ) conn.close(); }*/ %> 무제 문서

<%@ include file="/hanmaum/Intro/01_subimg.jsp" %>

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

홈 > 갤러리 > <% if(galtype.equals("1")) { %>주변풍경<% } else if(galtype.equals("2")) { %>한마음연수원 전경<% } else if(galtype.equals("3")) { %>실내인테리어<% } else if(galtype.equals("4")) { %>사용자갤러리<% } %><% if(galtype.equals("1") || galtype.equals("2")) { %> > <% if(galseason.equals("1")) { %>봄<% } else if(galseason.equals("2")) { %>여름<% } else if(galseason.equals("3")) { %>가을<% } else if(galseason.equals("4")) { %>겨울<% } %><% } %>