display data from the database to a jsp table

0

help please the idea is to compile compile the class and in the table show me all the records that are in the database I do not know what I have wrong or what I need

<%@page import="java.sql.Connection"%>
<%@page import="java.sql.SQLException"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.util.logging.Level"%>
<%@page import="java.util.logging.Logger"%>




<%
    clases.ConexionOracle con = new clases.ConexionOracle();
          Connection  cn = con.ConexionOracle();
            String sql1="select * from INFO_FINAL";
            Statement st;

                try {
                   st = cn.createStatement();
                   ResultSet r=st.executeQuery(sql1); %>
                   <table border="1">
                      <tr>
                <td>
                    <label>Numero de informe</label>
                </td>
                <td>
                    <label>Compañia</label>
                </td>
                <td>
                    <label>Rsulado</label>
                </td>
                <td>
                    <label>Subir informe</label>
                </td>

            </tr>
                    <%while(r.next()){%> 
                       <tr>
                <td>
                                    <label><%out.println(r.getString("numinfo_infoFINAL"));%></label>
                </td>
                <td>
                    <label><%out.println(r.getString("compa_infoFinal"));%></label>
                </td>
                <td>
                    <label><%out.println(r.getString("resul_infoFINALe"));%></label>
                </td>
                <td>
                    <label><%out.println(r.getString("subir_infoFINAL"));%></label>
                </td>

            </tr> 
                   <%}%>
                </table>
              <% } catch (SQLException ex) {
                    System.out.println("error: "+ex );
                }%>
    
asked by luisa suaza 07.06.2018 в 23:06
source

0 answers