<%@ page contentType="text/html; charset=big5" language="java" import="java.sql.*" %> <%@ include file="../Connections/fmaweb.jsp" %> <% Driver Driverbultrn4 = (Driver)Class.forName(MM_fmaweb_DRIVER).newInstance(); Connection Connbultrn4 = DriverManager.getConnection(MM_fmaweb_STRING,MM_fmaweb_USERNAME,MM_fmaweb_PASSWORD); PreparedStatement Statementbultrn4 = Connbultrn4.prepareStatement("SELECT title, http_link FROM buletin_trans WHERE type = 'ACTV' and status = 'A' and (to_char(date_fr,'yyyymmdd') <= to_char(sysdate,'yyyymmdd') or date_fr is null) and (to_char(date_to,'yyyymmdd') >= to_char(sysdate,'yyyymmdd') or date_to is null) ORDER BY arrange, id"); ResultSet bultrn4 = Statementbultrn4.executeQuery(); boolean bultrn4_isEmpty = !bultrn4.next(); boolean bultrn4_hasData = !bultrn4_isEmpty; Object bultrn4_data; int bultrn4_numRows = 0; %> <% int Repeat1__numRows = 20; int Repeat1__index = 0; bultrn4_numRows += Repeat1__numRows; %> <% bultrn4.close(); Statementbultrn4.close(); Connbultrn4.close(); %>