%@ page contentType="text/html; charset=big5" %> <% request.setCharacterEncoding("Big5");%> <%@ include file="../InitObj.inc" %> <% String[] stitle = {"最新消息","產業消息","企業團訊息","Q&A","遠雄人花絮"}; String spage = request.getParameter("p"); int ipage = 0; try{ ipage = Integer.parseInt(spage) - 1; }catch(Exception er){ out.print("參數錯誤"); return; } conn = getConn(); boolean login_success = false; try{ stmt = conn.createStatement(); }catch(Exception e){ out.print("資料庫連線錯誤"); return; } StringBuffer sql = new StringBuffer(); sql.append("select * from news where status='Y' and news_type='") .append(spage) .append("' and TO_CHAR(sysdate,'yyyymmdd') between begin_date and end_date order by SERIAL_NO desc"); rs = stmt.executeQuery(String.valueOf(sql)); %>