Remote dba, Oracle Remote dba, Oracle dba Services, Remote Database Monitoring, Server Monitoring, Oracle Tuning, Oracle Support, Oracle Consulting, Remote Database Administration, Web Server Monitoring, Linux Help, Linux \ Unix Consulting, Remote Linux \ Unix Administration, dba Support, Linux Help, Server Monitoring, Remote Server Maintenance, Remote Network Monitoring, Network Monitoring Supporting Services, Infrastructure Management Services, Network Monitoring Services

<%@ page import = "java.io.*"%> <%@ page import = "java.sql.*"%> <%@ page import = "java.util.Vector"%> <%@ page import = "dbinter.DBConnection" %> <%! private String newsid, title, description; private ResultSetMetaData rsmd; private Statement stmt; private ResultSet rs; private Connection conn; %> <%! public Vector listNews() { Vector columnNames = new Vector(); Vector data = new Vector(); try { stmt = conn.createStatement(); String sqlQuery = "select newsid, newstitle, newsdesc, newsdate from tblnews order by newsdate desc"; rs = stmt.executeQuery(sqlQuery); rsmd = rs.getMetaData(); for(int i=1; i<=rsmd.getColumnCount(); ++i) { columnNames.addElement(rsmd.getColumnName(i)); } while(rs.next()) { data.addElement(getNextRow(rs, rsmd)); } stmt.close(); } catch(Exception e) { System.out.println("Error "+e); } finally { try { if(stmt!= null ) { stmt.close(); stmt = null;} if(rs!= null ) { rs.close(); rs = null;} } catch(SQLException e) { } } return data; } %> <%! private Vector getNextRow(ResultSet rs, ResultSetMetaData rsmd) throws SQLException { Vector currentRow = new Vector(); java.text.DateFormat df = java.text.DateFormat.getDateInstance(java.text.DateFormat.FULL); String date; for(int i=1; i<=rsmd.getColumnCount(); ++i) { if(rsmd.getColumnTypeName(i).equalsIgnoreCase("DATE")) { date = df.format(rs.getDate(i)); currentRow.addElement(date); } else if(rsmd.getColumnTypeName(i).equalsIgnoreCase("BLOB")) currentRow.addElement(rs.getString(i)); else currentRow.addElement(rs.getObject(i)); } return currentRow; } %> Remote dba, Oracle Remote dba, Oracle dba Services, Remote Database Monitoring, Server Monitoring, Oracle Tuning, Oracle Support, Oracle Consulting, Remote Database Administration, Web Server Monitoring, Linux Help, Linux \ Unix Consulting, Remote Linux \ Unix Administration, dba Support, Linux Help, Server Monitoring, Remote Server Maintenance, Remote Network Monitoring, Network Monitoring Supporting Services, Infrastructure Management Services, Network Monitoring Services

<% conn = DBConnection.getConnection(); if (conn!=null) { Vector data = new Vector(); data = listNews(); if(!(data == null || data.size() == 0) ) { for(int i = 0;i

<%=((Vector)data.elementAt(i)).elementAt(3).toString()%>
<%=((Vector)data.elementAt(i)).elementAt(1).toString()%>

more..

<% } } } %>