%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*"%>
<%@ include file="../../../Connections/cicero.jsp" %>
<%
String lastch__MMColParam = "1";
if (request.getParameter("MM_EmptyValue") !=null) {lastch__MMColParam = (String)request.getParameter("MM_EmptyValue");}
%>
<%
Driver Driverlastch = (Driver)Class.forName(MM_cicero_DRIVER).newInstance();
Connection Connlastch = DriverManager.getConnection(MM_cicero_STRING,MM_cicero_USERNAME,MM_cicero_PASSWORD);
PreparedStatement Statementlastch = Connlastch.prepareStatement("SELECT datum, link, titel FROM dbo.ro_lastchanges WHERE span = " + lastch__MMColParam + " ORDER BY datum DESC");
ResultSet lastch = Statementlastch.executeQuery();
boolean lastch_isEmpty = !lastch.next();
boolean lastch_hasData = !lastch_isEmpty;
Object lastch_data;
int lastch_numRows = 0;
%>
<%
int Repeat1__numRows = 10;
int Repeat1__index = 0;
lastch_numRows += Repeat1__numRows;
%>
<%!
public String DoDateTime(java.lang.Object aObject,int nNamedFormat,java.util.Locale aLocale) throws Exception{
if ((aObject != null) && (aObject instanceof java.util.Date)){
if (aLocale!=null){
java.text.DateFormat df = java.text.DateFormat.getDateInstance(nNamedFormat,aLocale);
return df.format(aObject);
}
else{
java.text.DateFormat df = java.text.DateFormat.getDateInstance(nNamedFormat);
return df.format(aObject);
}
}
return "";
}
%>
Índice
<%
lastch.close();
Connlastch.close();
%>