Hi,
Create a abstract portal component and copy and paste the below code for the doContent () Method.
public void doContent(IPortalComponentRequest request, IPortalComponentResponse response)
{
DataSource dataSource= null;
ResultSet resultSet= null;
String sqlStatement =null;
ResultSetMetaData rsmd =null;
String nativesqlStatement=null;
try
{
sqlStatement = "select MAX(TIMESTAMPHOUR),LOGONID from WCR_USERSTAT GROUP BY LOGONID";
InitialContext initialContext= new InitialContext();
dataSource= (DataSource) initialContext.lookup("jdbc/SAP/EP_PCD");
java.sql.Connection connection= dataSource.getConnection();
java.sql.Statement statement= connection.createStatement();
Statement stmt=NativeSQLAccess.createNativeStatement(connection);
resultSet= statement.executeQuery(sqlStatement);
rsmd=resultSet.getMetaData();
if(resultSet!=null)
{
int m = 0;
response.write("<html>");
response.write("<body>");
response.write("<br>");
response.write("<TABLE width='100%' border='2' cellspacing='2'>");
response.write("<tr>");
response.write("<td>"+"LAST SUCCESSFULL LOGON" +"</td>" );
response.write("<td>"+"LOGONID"+"</td>" );
response.write("</tr>");
while (resultSet.next()) {
m++;
Timestamp ts = new Timestamp(resultSet.getLong(1));
response.write("<tr>");
response.write("<td>"+ts.toGMTString()+"</td>" );
response.write("<td>"+resultSet.getString(2)+ "</td>");
response.write("</tr>");
}
response.write("</table>");
response.write("<br>");
response.write("Record count is " + m);
}
}
catch (Exception e)
{
response.write("<br>Exception : " + e);
}
response.write("</body>");
response.write("</html>");
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.