%@ 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"), "1");
String galseason = toParamStr(request.getParameter("galseason"), "2");
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();
}
%>