%
/* *@ 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++;
%>
|
|
| <%=rsDet.getString(1)%> |
<%if(!rsDet.getString(3).equals("0")){%>
%>) |
<%}%>
| <%=rsDet.getString(2)%> |
|
<%
out.flush();
if(count%2==0)
{
%>
| |
<% }
}while(rsDet.next());
}
%>
|
|
|
<%@include file="right_menu.jsp"%>
|
|
|
<%@include file="bottom.jsp"%>
<%
}
catch(Exception e) {
System.out.println(e);
}
finally {
if(rsDet != null) rsDet.close();
icf.closeOnly();
}
%>