Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Registro
- //Class.forName("oracle.jdbc.OracleDriver");
- Class.forName("com.mysql.jdbc.Driver");
- //Establecer conexión
- 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("Conexión exitosa");
- Statement stm = cnn.createStatement();
- //int eliminados = stm.executeUpdate("delete from celular");
- //System.out.println(eliminados + " registros borrados");
- ResultSet rstRegistros;
- rstRegistros = stm.executeQuery("Select * from celular where imei = 111555888");
- if(rstRegistros.next()){
- int num = rstRegistros.getInt("numero");
- System.out.println("Número " + num );
- }
- rstRegistros = stm.executeQuery("Select * from celular order by numero");
- while(rstRegistros.next()){
- System.out.println(rstRegistros.getInt("numero"));
- }
- stm.close();
- rstRegistros.close();
- }else
- System.out.println("Error de conexión");
- cnn.close();
- } catch (Exception ex) {
- Logger.getLogger(PruebaCelular.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement