<%@ page import="java.sql.*" %> <%@ page import="oracle.jdbc.driver.*" %> <%@ include file ="include/common.jsp"%> <%@ page contentType="text/html;charset=big5"%>

<%@ include file="include/c_header.html" %>

	認 識 默 沙 東

<% // 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, c_headline, c_content from news where status = 'C' and sysdate <= off_date and sysdate >= post_date order by a DESC"); %> <% while (rset.next()) { %> <% } conn.close(); %> 新 聞 中 心   <%=rset.getString("news_date")%> "><%=rset.getString("c_headline")%> <%=rset.getString("c_content")%>

<%@ include file="include/c_footer.html" %>