package appbasica;

import org.apache.struts.action.*;
import java.sql.*;
import javax.sql.*;

/**
 * @author Roberto Canales rcanales@autentia.com
 */
public class poolAction extends Action {
    
    /** Creates a new instance of LoginAction */
    public poolAction() {
    }
    
    public org.apache.struts.action.ActionForward execute(

          org.apache.struts.action.ActionMapping actionMapping, 

          org.apache.struts.action.ActionForm actionForm, 

          javax.servlet.http.HttpServletRequest httpServletRequest, 

          javax.servlet.http.HttpServletResponse httpServletResponse) throws java.lang.Exception {
        

        java.util.Vector noticias = Noticia.getNoticiasPrueba();
        httpServletRequest.setAttribute("noticias",  noticias);
        
        
        java.sql.Connection con = null;
        
        String resultado = "";
        
        
        try {
            javax.sql.DataSource dataSource = getDataSource(httpServletRequest);
            con = dataSource.getConnection();
            PreparedStatement pstmt = con.prepareStatement("SELECT * FROM tutoriales WHERE id 
            
            while (results.next()) {
                String id = results.getString(1);
                String titulo = results.getString(2);
                resultado = resultado + "El titulo es " + titulo + " para id " + id + "";
            }
            
            httpServletRequest.setAttribute("listado",  resultado);
            
            
        } catch (java.sql.SQLException sqle) { getServlet().log("Connection.process", sqle); } 

           finally {
            try {
                con.close();
            } catch (java.sql.SQLException e) {
                getServlet().log("Connection.close", e);
            }
        }
        
        ActionForward retValue = actionMapping.findForward("respool");
        return retValue;
    }
    
}

      

</center>
</html>