Advertisement
Guest User

Untitled

a guest
Jan 31st, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. <div class="container">
  2. <thead>
  3. <center><table class="table" border="1">
  4. <tr class="success">
  5. <%
  6. consulta conexion = new consulta (
  7. "jdbc:oracle:thin:@localhost:1521:XE","pasaportes","oppasaportes"
  8. );
  9. String consulta = "SELECT * FROM delegaciones WHERE id_delegacion ='1'";
  10. ResultSet rs = conexion.ejeSelect(consulta);
  11. ResultSetMetaData rsmd = rs.getMetaData();
  12. int col= rsmd.getColumnCount();
  13. for(int k=1;k<=col;k++){
  14. %>
  15. <td><h4> <%= rsmd.getColumnName(k) %></h4></td>
  16. <%
  17. }
  18. %>
  19. </tr>
  20. <%
  21. while(rs.next()){
  22. %>
  23. <tr class="info">
  24. <td><h4><%= rs.getString(1) %></h4> </td>
  25. <td><h4><%= rs.getString(2) %></h4> </td>
  26. <td><h4><%= rs.getString(3) %></h4> </td>
  27. <td><h4><%= rs.getString(4) %></h4> </td>
  28. <td><h4><%= rs.getString(5) %></h4> </td>
  29. <td><h4><%= rs.getString(6) %></h4> </td>
  30. <td><h4><%= rs.getString(7) %></h4> </td>
  31. </tr>
  32. <%
  33. }
  34. %>
  35. </table></center>
  36. </thead>
  37. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement