|
|
 |
|
HEALTH
FORUM |
|
|
| |
|
<%
int cnt = 0;
// Connection of JDBC
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(gbl_cnn,gbl_usr,gbl_pwd);
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery ("select ID, E_HEADLINE HEADLINE from health_forum where status = 'C' and post_date < sysdate and sysdate < off_date and E_HEADLINE is not null order by news_date");
while (rset.next()) {
cnt = cnt + 1;
%>
| - |
"><%=rset.getString("HEADLINE")%> |
<% } %>
<% if (cnt == 0 ) { %>
| |
We are sorry!
No english version available currently!
Please go to Chinese version for Health Forum!
|
<% } %>
<% conn.close(); %>
|
 |
|
|
