<%
/*==============================================================================================
* Project Title : 한마음연수원
* File Name : main.jsp
* Include :
* Used DB Table : notice
* Used Class :
* Description : 메인
* Programmer : 강주용
* First Write : 2010.05.10
* Last Update :
==============================================================================================*/
%>
<%@ page contentType="text/html;charset=euc-kr" %>
<%@ 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" />
<%
int PageAuth = 1;
String menuId = request.getParameter("menuId");
if(menuId == null || menuId.equals("")) menuId = "00";
%>
<%!
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());
}
}
%>
<%
Connection conn = null;
Statement stmt = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
try {
StringBuffer query1 = new StringBuffer();
StringBuffer query2 = new StringBuffer();
query1.append("select * from notice where state = '1' order by no desc limit 5 offset 0 ");
query2.append("select * from notice where state = '2' order by no desc limit 5 offset 0 ");
conn = DriverManager.getConnection("jdbc:jdc:jdcpool");
stmt = conn.createStatement();
rs1 = stmt.executeQuery(query1.toString());
%>
<%@ page contentType="text/html;charset=euc-kr" %>
<jsp:include page="/hanmaum/mtop.jsp" flush="false"/>
<script src="Scripts/swfobject_modified.js" type="text/javascript"></script>
<script language="javascript">
<!--
function onGoPage(url) {
if(url == "notice") {
location.href = "Cs/csnot01.jsp?menuId=41";
} else {
location.href = "Cs/csqa01.jsp?menuId=42";
}
}
function onSetPage(cmd) {
if(cmd == "notice") {
document.all.noticeTable.style.display = "";
document.all.qandaTable.style.display = "none";
} else {
document.all.qandaTable.style.display = "";
document.all.noticeTable.style.display = "none";
}
}
function onViewPage(cmd, no) {
if(cmd == "1") {
location.href = "Cs/csnot02.jsp?menuId=41&no="+no;
} else {
location.href = "Cs/csqa02.jsp?menuId=42&no="+no;
}
}
//-->
</script>
<table width="940" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<object id="FlashID" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="940" height="360">
<param name="movie" value="main.swf" />
<param name="quality" value="high" />
<param name="wmode" value="opaque" />
<param name="swfversion" value="6.0.65.0" />
<!-- 이 param 태그는 Flash Player 6.0 r65 이후 버전 사용자에게 최신 버전의 Flash Player를 다운로드하라는 메시지를 표시합니다. 사용자에게 이러한 메시지를 표시하지 않으려면 이 태그를 삭제하십시오. -->
<param name="expressinstall" value="Scripts/expressInstall.swf" />
<!-- 다음 객체 태그는 IE 이외의 브라우저에 사용됩니다. IECC를 사용하여 IE에서 이 태그를 숨기십시오. -->
<!--[if !IE]>-->
<object type="application/x-shockwave-flash" data="main.swf" width="940" height="360">
<!--<![endif]-->
<param name="quality" value="high" />
<param name="wmode" value="opaque" />
<param name="swfversion" value="6.0.65.0" />
<param name="expressinstall" value="Scripts/expressInstall.swf" />
<!-- Flash Player 6.0 이전 버전 사용자의 브라우저에는 다음과 같은 대체 내용이 표시됩니다. -->
<div>
<h4>이 페이지의 내용을 보려면 최신 버전의 Adobe Flash Player가 필요합니다.</h4>
<p><a href="http://www.adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Adobe Flash Player 내려받기" width="112" height="33" /></a></p>
</div>
<!--[if !IE]>-->
</object>
<!--<![endif]-->
</object>
</td>
</tr>
</table>
<br />
<div name="noticeTable" id="noticeTable">
<table width="940" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="346" align="right" valign="top"><img src="Image/ma_con01.gif" alt="" width="326" height="141" border="0" usemap="#acc" /></td>
<td width="390" align="center" valign="top">
<table width="339" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="339">
<img src="Image/ma_not01.gif" alt="" width="339" height="28" border="0" usemap="#nnot" />
</td>
</tr>
</table>
<table width="339" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10"> </td>
<td width="259"> </td>
<td width="70"> </td>
</tr>
<%
if (rs1 != null) {
int no = 0;
String subject = "";
String regdate = "";
while (rs1.next()) {
no = rs1.getInt("no");
subject = rs1.getString("subject");
regdate = rs1.getString("reg_dt").toString().substring(0, 10);
subject = cutoffString(subject, 30);
%>
<tr>
<td> </td>
<td height="20" align="left">
<a href="javascript:onViewPage('1','<%= no %>');">
<%= subject %>
</a>
</td>
<td align="right"><%= regdate %></td>
</tr>
<%
}
} else {
%>
<tr>
<td colspan="3" align="center">등록된 게시물이 없습니다.</td>
</tr>
<%
}
rs1.close();
rs2 = stmt.executeQuery(query2.toString());
%>
</table>
</td>
<td width="204" valign="top"><img src="Image/ma_but03.gif" alt="" width="184" height="141" border="0" usemap="#Map" />
</td>
</tr>
</table>
</div>
<div name="qandaTable" id="qandaTable" style="display:none;">
<table width="940" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="346" align="right" valign="top"><img src="Image/ma_con01.gif" alt="" width="326" height="141" border="0" usemap="#acc" /></td>
<td width="390" align="center" valign="top">
<table width="339" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="339">
<!--img src="Image/ma_not01.gif" alt="" width="339" height="28" border="0" usemap="#nnot" /-->
<img src="Image/ma_not02.gif" alt="" width="339" height="28" border="0" usemap="#nqan" />
</td>
</tr>
</table>
<table width="339" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10"> </td>
<td width="259"> </td>
<td width="70"> </td>
</tr>
<%
if (rs2 != null) {
int no = 0;
String subject = "";
String regdate = "";
while (rs2.next()) {
no = rs2.getInt("no");
subject = rs2.getString("subject");
regdate = rs2.getString("reg_dt").toString().substring(0, 10);
subject = cutoffString(subject, 30);
%>
<tr>
<td> </td>
<td height="20" align="left">
<a href="javascript:onViewPage('2','<%= no %>');">
<%= subject %>
</a>
</td>
<td align="right"><%= regdate %></td>
</tr>
<%
}
} else {
%>
<tr>
<td colspan="3" align="center">등록된 게시물이 없습니다.</td>
</tr>
<%
}
%>
</table>
</td>
<td width="204" valign="top">
<a href="#">
<img src="Image/ma_but01.gif" alt="" width="184" height="61" border="0" />
</a>
<a href="#">
<img src="Image/ma_but02.gif" alt="" width="184" height="62" border="0" />
</a>
</td>
</tr>
</table>
</div>
<map name="Map" id="nnot">
<area shape="rect" coords="302,12,337,27" href="javascript:onGoPage('notice');" alt="더보기" />
<!--area shape="rect" coords="1,2,83,28" href="#" alt="" /-->
<area shape="rect" coords="83,2,166,27" href="javascript:onSetPage('qanda')" alt="" />
</map>
<map name="Map" id="nqan">
<area shape="rect" coords="302,12,337,27" href="javascript:onGoPage('qanda');" alt="더보기" />
<area shape="rect" coords="1,2,83,28" href="javascript:onSetPage('notice')" alt="" />
<!--area shape="rect" coords="83,2,166,27" href="#" alt="" /-->
</map>
<map name="Map2" id="acc">
<area shape="rect" coords="20,73,152,128" HREF="/hanmaum/Accou/accou01.jsp?menuId=31" target="viewframe" />
<area shape="rect" coords="157,73,316,127" HREF="/hanmaum/Accou/accou04.jsp?menuId=34" target="viewframe" />
</map>
<%@ include file="/hanmaum/bottom1.jsp" %>
<%
if ( rs1 != null ) rs1.close();
if ( rs2 != null ) rs2.close();
if ( stmt != null ) stmt.close();
if ( conn != null ) conn.close();
} catch (Exception e) {
if ( rs1 != null ) rs1.close();
if ( rs2 != null ) rs2.close();
if ( stmt != null ) stmt.close();
if ( conn != null ) conn.close();
// 에러페이지로 이동............
out.println("JSP >> Exception in /hanmaum/main.jsp : " + e.toString());
}
%>
<map name="Map" id="Map">
<area shape="rect" coords="59,79,113,99" href="#" alt="다운로드" />
<area shape="rect" coords="115,77,178,99" href="#" alt="브로셔" />
<area shape="rect" coords="4,3,181,42" href="#" alt="사용신청서 다운" />
<area shape="rect" coords="4,106,180,139" href="#" alt="에코끼리링크" />
</map>
<script type="text/javascript">
<!--
swfobject.registerObject("FlashID");
//-->
</script>