Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- Class.forName("com.mysql.jdbc.Driver");
- String baseDeDatos = "jdbc:mysql://pulloa-instancia.cxjya9vspzfo.sa-east-1.rds.amazonaws.com:3306/taller126?useUnicode=true&characterEncoding=utf-8";
- Connection cnn = DriverManager.getConnection(baseDeDatos, "taller126", "taller");
- if (cnn != null) {
- System.out.println("La conexiòn ha sido exitosa Charmeleon");
- Statement stm = cnn.createStatement();
- ResultSet rstRegistros;
- rstRegistros = stm.executeQuery("Select * from celular");
- while(rstRegistros.next()){
- Celular miCelulitico = new Celular();
- miCelulitico.setImei(rstRegistros.getInt("imei"));
- miCelulitico.setNumero(rstRegistros.getInt("numero"));
- miCelulitico.setMarca(rstRegistros.getString("marca"));
- miCelulitico.setModelo(rstRegistros.getString("modelo"));
- miCelulitico.setMinutosHablados(rstRegistros.getInt("minutosHablados"));
- miCelulitico.setMegasConsumidos(rstRegistros.getInt("megasConsumidos"));
- miCelulitico.setSaldo(rstRegistros.getInt("saldo"));
- miArray.add(miCelulitico);
- }
- for(Celular varAux: miArray){
- System.out.println("Imei: " + varAux.getImei());
- System.out.println("Numero: " + varAux.getNumero());
- System.out.println("Marca: " + varAux.getMarca());
- System.out.println("Modelo: " + varAux.getModelo());
- System.out.println("");
- }
- rstRegistros.close();
- stm.close();
- }else{
- System.out.println("Error de Conexión");
- }
- cnn.close();
- } catch (Exception ex) {
- Logger.getLogger(CelularDesde0.class.getName()).log(Level.SEVERE, null, ex);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement