<%@ page language = "java" contentType = "text/html; charset=EUC-KR" pageEncoding = "EUC-KR" %>
<%@ include file ="cmm/public.jsp" %>
<%@ page language="java" import="java.sql.*,java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="board.*" %>
<%@ page import="dbpool.*" %>
<%@ page import="kr.co.kdbc.pop.PopupEntity,kr.co.kdbc.pop.PopupFacade,kr.co.kdbc.ResourceManager"%>
<%
DBConnectionMgr dbmgr = DBConnectionMgr.getInstance();
if( dbmgr == null)
{
out.println("");
return;
}
java.sql.Connection conn = dbmgr.getConnection();
if( conn == null)
{
out.println("");
return;
}
Statement st = null;
PreparedStatement stmt = null;
ResultSet rs = null;
String sql = null;
%>
<%
Vector List = new Vector();
// PopupEntity pe = new PopupFacade().getPopupElement();
try{
st = conn.createStatement();
sql = " select kdbcseqn, DATE_FORMAT(kdbcrgdt,'%Y.%m.%d')as dd, kdbctitl, 'A' as gubn from kdbc_notice "
+ " union all "
+ " select kdbcseqn, DATE_FORMAT(kdbcrgdt,'%Y.%m.%d')as dd, kdbctitl, 'B' as gubn from kdbc_report "
+ " order by kdbcseqn desc ";
rs = st.executeQuery(sql);
while (rs.next()) {
BoardBean tempBean = new BoardBean();
tempBean.setNum(rs.getInt("kdbcseqn"));
tempBean.setSubject(rs.getString("kdbctitl"));
tempBean.setSubject(rs.getString("kdbctitl"));
tempBean.setRegdate(rs.getString("dd"));
tempBean.setKdbcgubn(rs.getString("gubn"));
List.addElement(tempBean);
}
}catch(SQLException e1){
out.println("");
return;
}finally{
if(rs != null){
try{
rs.close();
}catch(SQLException e) {}
}
if(st != null){
try{
st.close();
}catch(SQLException e) {}
}
if(stmt != null){
try{
stmt.close();
}catch(SQLException e) {}
}
if(conn != null)
dbmgr.freeConnection(conn);
if(dbmgr != null)
dbmgr.releaseFreeConnections();
}
%>
:: KDB CAPITAL
