%
/*==============================================================================================
* Project Title :
* File Name :
* Include :
* Used DB Table : notice
* Used Class :
* Description : °Ô½ÃÆÇ ¸®½ºÆ®
* Programmer : °ÁÖ¿ë
* First Write : 2010.04.28
* Last Update :
==============================================================================================*/
%>
<%@ page contentType="text/html;charset=euc-kr" %>
<%@ include file="/include/in_Import.jsp" %>
<%@ include file="/include/in_Function.jsp" %>
<%
int PageAuth = 1;
String menuId = request.getParameter("menuId");
if(menuId == null || menuId.equals("")) menuId = "42";
%>
<%!
static {
try {
new kr.co.slight.jinhae.pool.JDCConnectionDriver("org.postgresql.Driver","jdbc:postgresql:hanmaum","postgres","");
} catch(Exception e) {
System.out.println("
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");
if ( keytype == null || keytype.equals("") ) {
keytype = "subject";
}
if ( keyword == null || keyword.equals("") ) {
keyword = "";
} else {
keyword = sutil.toEucKr(keyword);
}
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();
if ( keyword == null || keyword.equals("") ) {
query_cnt.append(" SELECT COUNT(*) FROM ( ");
query_cnt.append(" SELECT A.NO, A.SUBJECT, A.REG_DT, A.NAME, A.VIEW_CNT, A.STATE ");
query_cnt.append(" FROM NOTICE A ");
query_cnt.append(" WHERE A.STATE = '2' ");
query_cnt.append(" UNION ALL ");
query_cnt.append(" SELECT B.NO, '', NOW(), '', 0, '0' ");
query_cnt.append(" FROM NOTICE_RPL B ");
query_cnt.append(" ) A ");
query_cnt.append(" LEFT OUTER JOIN NOTICE_RPL B ");
query_cnt.append(" ON A.NO = B.NO ");
query.append(" SELECT A.NO, A.SUBJECT, COALESCE(TO_CHAR(A.REG_DT,'YYYY-MM-DD'),'') AS REG_DT, A.NAME, A.VIEW_CNT, A.STATE FROM ( ");
query.append(" SELECT A.NO, A.SUBJECT, A.REG_DT, A.NAME, A.VIEW_CNT, A.STATE ");
query.append(" FROM NOTICE A ");
query.append(" WHERE A.STATE = '2' ");
query.append(" UNION ALL ");
query.append(" SELECT B.NO, '', B.REG_DT, '', B.VIEW_CNT, '0' ");
query.append(" FROM NOTICE_RPL B ");
query.append(" ) A ");
query.append(" LEFT OUTER JOIN NOTICE_RPL B ");
query.append(" ON A.NO = B.NO ");
query.append(" ORDER BY A.NO DESC , A.STATE DESC ");
query.append(" limit ").append(pageSize).append(" offset ").append(start_no-1);
} else {
query_cnt.append("select count(*) ");
query_cnt.append(" from notice ");
query_cnt.append(" where ").append(keytype).append(" like '%").append(keyword).append("%'");
query_cnt.append(" and state = '2' ");
query.append("select * ");
query.append(" from notice ");
query.append(" where ").append(keytype).append(" like '%").append(keyword).append("%' ");
query.append(" and state ='2' ");
query.append(" order by no desc ");
query.append(" limit ").append(pageSize).append(" offset ").append(start_no-1);
}
conn = DriverManager.getConnection("jdbc:postgresql:hanmaum", "postgres", "");
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;
%>
¹«Á¦ ¹®¼
<%@ include file="/hanmaum/Cs/04_subimg.jsp" %>
<%@ include file="/hanmaum/Cs/left_menu.jsp" %>
|
Ȩ > °í°´¼¾ÅÍ > Áú¹®°ú´äº¯ |
 |
|
<%
if (totalCnt > 0) {
int i = totalCnt;
int no = 0;
String subject = "";
String regdate = "";
String view_cnt = "";
String name = "";
String state = "";
while (rtList.next()) {
no = rtList.getInt("no");
regdate = rtList.getString("reg_dt");
if(!regdate.equals("")){
regdate = rtList.getString("reg_dt").toString().substring(0, 10);
}
name = rtList.getString("name");
view_cnt = rtList.getString("view_cnt");
state = rtList.getString("state");
if(state.equals("2")){ //2À϶§¸¸ °ªÀ» ³Ö´Â´Ù.
subject = rtList.getString("subject");
subject = cutoffString(subject, 80);
}
%>
<%= rowNum-- %> |
<%if(state.equals("0")){%> [´äº¯]<%}%>
<%= subject %>
|
<%if(state.equals("0")){%>°ü¸®ÀÚ<%}else{%><%= name %><%}%> |
<%if(regdate.equals("")){%> <%}else{%><%= regdate %><%}%> |
<%= view_cnt %> |
<%
}
} else {
%>
µî·ÏµÈ °Ô½Ã¹°ÀÌ ¾ø½À´Ï´Ù. |
<%
}
%>
|
|
<%
//ÀÌÀü ÆäÀÌÁö
if ( iPage == 1 ) {
%>
<%
} else {
%>
<%
}
// ÆäÀÌÁö Loop
for ( int j=blockPage; j
[<%=j%>]
<%
} else {
%>
[<%=j%>]
<%
}
}
/*-----------------------------------------
´ÙÀ½ ÆäÀÌÁö
-----------------------------------------*/
if ( iPage == totalPage ) {
%>
<%
} else {
%>
<%
}
%>
|
|
<%@ include file="/hanmaum/bottom.jsp" %>
<%
rs.close();
stmt.close();
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());
}
%>