|
|
 |
|
<%
// 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 news_date a, id, to_char(news_date,'YY.MM.DD HH24:MI') news_date, e_headline, e_content from news where status = 'C' and sysdate <= off_date and sysdate >= post_date order by a");
%>
|
|
