<%-- ¢Ã JSP ±â´É : ºñ³ª½Å ¿µ¹® »çÀÌÆ® Ãʱâ È­¸é ¢Ã ±¸ÇöÀÏÀÚ : 2001-06-27 11:30 ¿ÀÀü ¢Ã ±¸ÇöÀÚ : ¿ÀÁöÈñ(minerva@402lab.com) --%> <%@ page import="com.lab402.*" %> <%@ page import="java.sql.*" %> <%-- Init Variable Area --%> <%@ include file = "/common/initVariable.inc" %> <%-- Init DB Variable Area --%> <%@ include file="/common/initDBVariable.inc" %> <%-- Init List Variable Area --%> <%@ include file="/common/initGetList.inc" %> <% SearchOption option = null; urlJSP = "/english/index.jsp"; try{ //¸®½ºÆ®¿¡ »Ñ·ÁÁÙ Äõ¸®¹® ÀÛ¼º sql = "select SEQNO, TITLE, WRITER, WRITE_DATE, COUNT, CONTENT from HVS_NEWS_ENG"; sql += " order by SEQNO DESC"; currentPage = Utility.removeIntNull(request.getParameter("pg")); currentPage = 1; // out.println(Utility.debugCommentString(" sql : " + sql)); // out.println(Utility.debugScriptString(" totalPage : " + totalPage)); option = new SearchOption(); option.name = "hvsIndex"; option.currentPage = currentPage; colSize = 6; // listSize = 3; conn = DBConnectionBean.getConnection(); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); %> <%@ include file="/common/getList.inc" %> <% //} catch(BusinessException be) { // errMsg = be.errMsg; } catch(SQLException se) { errMsg = "DB Server ¿¡ ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù."; } catch(Exception e) { errMsg = "Server ¿¡ ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù."; } finally { try { if(rs != null) rs.close(); if(stmt != null) stmt.close(); if(conn != null) conn.close(); } catch(Exception e) { errMsg = "ÀÚ¿øÀ» ¹Ý³³ÇÏ´Â Áß Server ¿¡ ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù."; } } %> ¨Ô¨â¨ß : The worldwide Leader in Ship-Repairing Industry : ¨Ô¨â¨ß
 
<% if( list.size() <= 0 && errMsg.equals("") ) { errMsg = "°Ô½Ã±ÛÀÌ Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù."; } String[] bgColor = new String[2]; //String imageTag = ""; //int levelImage = 0; //int levelImageMax = 40; for(int i=0; i < listSize; i++) { if( i % 2 == 0 ) { bgColor[0] = "EBEBEB"; bgColor[1] = "#F0E4BB"; } else { bgColor[0] = "FFFFFF"; bgColor[1] = "#F9F1DF"; } if(i < list.size() ) { listObj = (String[]) list.get(i); // SEQNO, TITLE, WRITER, WRITE_DATE, COUNT from HVS_NEWS %> <% } else { %> <% } } %>
<%= Utility.ksc2iso(Utility.byteSubstring(listObj[1], 46)) %> / <%= listObj[3].substring(0,4)%>.<%= listObj[3].substring(4,6)%>.<%= listObj[3].substring(6,8)%>
<%= (i==0) ? errMsg : "" %>