package bd;

import java.sql.*; // pack

public class Conexion {
    private Connection con; // Establecer la conexión
    private Statement sen;  // Ejecutar consultas
    private ResultSet rs;   // Recorrer los resultados (Tabla)

    // localhost --> ip --> mysql --> afuera
    public Conexion(String server, String bd, String user, String pass) throws SQLException, ClassNotFoundException{
        String protocolo = "jdbc:mysql://";
        String lineaUser = "user="+user;
        String lineaPass = "password="+pass;

        String url = protocolo +
                server + "/" +
                bd + "?" +
                lineaUser + "&" +
                lineaPass;

        System.out.println(url);

        Class.forName("com.mysql.jdbc.Driver"); // jar, INCLUIR!!!!!
        con = DriverManager.getConnection(url);
    }

    /*
    consultas actualizan los datos --> delete, insert, update
    ver datos --> select
    */

    // insert, delete, update
    public void ejecutar(String query) throws SQLException{
        sen = con.createStatement();
        sen.executeUpdate(query);
        desconectar();
    }

    // select
    public ResultSet ejecutarSelect(String query) throws SQLException{
        sen = con.createStatement();
        rs = sen.executeQuery(query);
        return rs;
    }

    public void desconectar() throws SQLException{
        sen.close();
    }
}