CONSULTA 1 EN MYSQL

import javax.swing.*;
import java.sql.*;
public class conectar_base_mysql
{
    public static void main(String[] args) throws InstantiationException, IllegalAccessException
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            Connection c=DriverManager.getConnection("jdbc:mysql://localhost/clientes","root","rorro");
            //conectate a la base clientes que es local
            Statement est=c.createStatement();
            ResultSet consulta=est.executeQuery("select * from contactos");
            while(consulta.next())
            {
            System.out.print(consulta.getInt("id")+" "+consulta.getString("nombre")+" "
                    +consulta.getString("telefono")+" "+consulta.getString("email")+"\n");
            JOptionPane.showMessageDialog(null, consulta.getInt("id")+" "+consulta.getString("nombre")+" "
                    +consulta.getString("telefono")+" "+consulta.getString("email")+"\n");
            }
           
          
            c.close();
           
        }
       
        catch(ClassNotFoundException e)
        {
            System.err.print(e);
        }
        catch(SQLException sql)
        {
           System.out.print(sql);
        }

    }//main
}//clase