Advertisement
Guest User

Untitled

a guest
Dec 16th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.20 KB | None | 0 0
  1. try {
  2. Class.forName("com.mysql.jdbc.Driver");
  3. String baseDeDatos = "jdbc:mysql://pulloa-instancia.cxjya9vspzfo.sa-east-1.rds.amazonaws.com:3306/taller126?useUnicode=true&characterEncoding=utf-8";
  4. Connection cnn = DriverManager.getConnection(baseDeDatos, "taller126", "taller");
  5. if (cnn != null) {
  6. System.out.println("La conexiòn ha sido exitosa Charmeleon");
  7.  
  8. Statement stm = cnn.createStatement();
  9. ResultSet rstRegistros;
  10. rstRegistros = stm.executeQuery("Select * from celular");
  11.  
  12. while(rstRegistros.next()){
  13. Celular miCelulitico = new Celular();
  14. miCelulitico.setImei(rstRegistros.getInt("imei"));
  15. miCelulitico.setNumero(rstRegistros.getInt("numero"));
  16. miCelulitico.setMarca(rstRegistros.getString("marca"));
  17. miCelulitico.setModelo(rstRegistros.getString("modelo"));
  18. miCelulitico.setMinutosHablados(rstRegistros.getInt("minutosHablados"));
  19. miCelulitico.setMegasConsumidos(rstRegistros.getInt("megasConsumidos"));
  20. miCelulitico.setSaldo(rstRegistros.getInt("saldo"));
  21. miArray.add(miCelulitico);
  22. }
  23.  
  24. for(Celular varAux: miArray){
  25. System.out.println("Imei: " + varAux.getImei());
  26. System.out.println("Numero: " + varAux.getNumero());
  27. System.out.println("Marca: " + varAux.getMarca());
  28. System.out.println("Modelo: " + varAux.getModelo());
  29. System.out.println("");
  30. }
  31.  
  32. rstRegistros.close();
  33. stm.close();
  34.  
  35. }else{
  36. System.out.println("Error de Conexión");
  37. }
  38. cnn.close();
  39.  
  40. } catch (Exception ex) {
  41. Logger.getLogger(CelularDesde0.class.getName()).log(Level.SEVERE, null, ex);
  42. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement