<% /* *@ name :index.jsp @ version :1.0 *@ author :SHIJU @ Dated :1/6/2006 *@ Modified on : @ Dated : */ %> <%@ page language="java" import="java.util.*"%> <% java.sql.ResultSet rsDet = null; try { icf.setConnection(); String sqlDet = ""; sqlDet = " SELECT title,description,image FROM tab_home WHERE publish = 1 ORDER BY priority ASC "; rsDet = icf.executeQuery(sqlDet); int count=0; java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd HH:MM:SS"); java.text.SimpleDateFormat sdfDB = new java.text.SimpleDateFormat("dd/MM/yyyy"); %> "Scuola padre di francia"
<%@include file="top.jsp"%>
 
<%@include file="menu.jsp"%>
 
<% out.flush(); if(rsDet.next()){ out.println(rsDet.getString("title")); } rsDet.beforeFirst(); %>
  <% out.flush(); if(rsDet.next()){ %> <% } rsDet.beforeFirst(); %>  
  <% out.flush(); if(rsDet.next()){ out.println(rsDet.getString("description")); } %>  
<% if(rsDet.next()) { out.flush(); do { count++; %> <% out.flush(); if(count%2==0) { %> <% } }while(rsDet.next()); } %>
  <%if(!rsDet.getString(3).equals("0")){%> <%}%>
<%=rsDet.getString(1)%>
<%=rsDet.getString(2)%>
  
  <%@include file="right_menu.jsp"%>
<%@include file="bottom.jsp"%>
<% } catch(Exception e) { System.out.println(e); } finally { if(rsDet != null) rsDet.close(); icf.closeOnly(); } %>