Advertisement
Guest User

Untitled

a guest
Apr 1st, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. try {
  2. //1. Conectarse a la base de datos.
  3. Connection coneccion = DriverManager.getConnection("jdbc:mysql://localhost:8889/Java", "root", "root");
  4.  
  5. //2.Crear el statement.
  6. Statement statement = coneccion.createStatement();
  7.  
  8. //3.Generar una consulta.
  9. ResultSet resultado = statement.executeQuery("SELECT * FROM Productos");
  10.  
  11. //4.Leer el resulset.
  12. while ( resultado.next() ) {
  13.  
  14. String idArt = resultado.getString(1);
  15. String seccionArt = resultado.getString(2);
  16. String nombreArt = resultado.getString(3);
  17.  
  18. System.out.println("ID: " + idArt + ". Seccion: " + seccionArt + ". Nombre: " + nombreArt );
  19.  
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement