package mostrardatoseje49;
import java.sql.*;
public class Main {

    public static void main(String[] args) {
       try{
           Class.forName("com.mysql.jdbc.Driver");
           Connection cn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:8889/Pruebas", "root", "root");
           Statement st = cn.createStatement();
           String sql = "select cliente, saldo from Preubas1";
           ResultSet rs = st.executeQuery(sql);
           System.out.println(rs.getInt("codigo"));
          while(rs.next()){
               System.out.println("Nombre del cliente " + rs.getString("cliente"));
               System.out.println("El codigo del cliente es" + rs.getDouble("saldo"));
           }
           //Cierre de objetos
           st.close();
           rs.close();
           cn.close();
       }
       catch (Exception e){
           System.out.println("No se pudieron recuperar los datos");
       }

    }

}