<%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.SQLException"%> <%@page import="java.util.ArrayList" %> <%@page import="java.util.Iterator" %> <%@page import="java.util.List" %> <%@page import="br.com.addvisorconsulting.Database" %> <%! ResultSet resultado, rs2; ArrayList al; List list; String sql; Database appl = new Database(); // Database db = new Database(); %> <% sql = "SELECT * FROM tbl_noticias ORDER BY DATA DESC LIMIT 1"; //appl appl.conecta(); resultado = appl.execute(sql); %> <%@ include file="header.html" %>

<% } else { %> Nenhuma noticia nova. <% } %>

Notícias

<% if( resultado.next() ) { %> <% sql = "SELECT * FROM tbl_noticias ORDER BY DATA DESC LIMIT 1, 4"; rs2 = appl.execute(sql); if( rs2.next() ) { %>

<% rs2.first(); while( rs2.next() ) { out.print(""); } %>

Noticias anteriores

"); out.print( "" + rs2.getString("TITULO") + "" ); out.println("
"); out.println( rs2.getString("NOTICIA").substring(0, 100) ); out.print("

<% } try{ rs2.close(); } catch( SQLException ex ) { // ex.printStackTrace(); } %> <%= resultado.getString("TITULO") %>

<%= resultado.getString("NOTICIA") %>

<% appl.closeConn(); try{ resultado.close(); } catch( SQLException ex ) { // ex.printStackTrace(); } %> <%@ include file="footer.html" %>