 |
|
:: NEWS
LETTER ::
|
| Date
|
Description |
Action |
<%
MysqlBean db=new MysqlBean();
db.OpenConn("localhost/emtech","emtech","bumga680");
if(db!=null) {
String desc="",no="",date="",dtype="",savefile="";
int slno=0;
String nsql="select n_news_no,c_news_caption,date_format(d_news_date,'%e-%c-%Y') as ndate,c_savefile from newsletter where c_news_status='Y'";
ResultSet nrs=db.getResults(nsql);
while(nrs.next()) {
slno=slno+1;
desc=nrs.getString("c_news_caption");
no=""+nrs.getInt("n_news_no");
date=nrs.getString("ndate");
savefile=nrs.getString("c_savefile");
if(savefile.endsWith(".doc"))
dtype="1";
else
dtype="2";
%>
|
<%=date%>
|
<%=desc%>
|
|
<%
}
db.CloseStmt();
db.CloseConn();
}
%>
|
|
