package conectabasedato;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author Javier
 */

public class Conectar {

    //primero es abrir la coneccion
        public Connection abrirConexion() throws SQLException{
            String user="root";
            String password="";

            String protocolo="jdbc:mysql://";
            String server="localhost";
            String puerto="3306";
            String bd="ejemplo";
            String url=protocolo+server+":"+puerto+"/"+bd;
            Connection cnx= null;

            try {
                  Class.forName("com.mysql.jdbc.Driver");
                  cnx=DriverManager.getConnection(url, user, password);

            } catch (ClassNotFoundException ex) {
                Logger.getLogger(Conectar.class.getName()).log(Level.SEVERE, null, ex);
                System.out.println("Error de driver");
            }

            return cnx;

        }

        public void cerrarConexion(Connection cnx){

            try {
                cnx.close();
            } catch (SQLException ex) {
                Logger.getLogger(Conectar.class.getName()).log(Level.SEVERE, null, ex);
            }
        }

        public int actualizar(Connection cnx, String sql){
            int resultado=0;
            try {
                Statement st= cnx.createStatement();
                resultado=st.executeUpdate(sql);

            } catch (SQLException ex) {
                Logger.getLogger(Conectar.class.getName()).log(Level.SEVERE, null, ex);

            }
             return resultado;
}

        public ResultSet consulta(Connection cnx, String sql){

                ResultSet resultado = null;

                try {

                    Statement st= cnx.createStatement();
                    resultado=st.executeQuery(sql);

                } catch (SQLException ex) {
                    Logger.getLogger(Conectar.class.getName()).log(Level.SEVERE, null, ex);
                }

                return resultado;

        }

}