class Conexion{
    private String bdd="prueba";
    private String usuario="root";
    private String clave="clave";
    public static Connection con;
    private Statement stmt;
    private ResultSet rs;
    private String sql;
    public Conexion()
    {
            try{
                DriverManager.registerDriver(new org.gjt.mm.mysql.Driver());
                con=DriverManager.getConnection("jdbc:mysql://localhost/"+bdd,usuario,clave);
            }catch(Exception e)
            {
                e.printStackTrace();
            }
    }
    public void setInsertar(String sql){
        try{
            stmt=con.createStatement();
            stmt.executeUpdate(sql);
            stmt.close();
            }catch(SQLException e){
            e.printStackTrace();
        }
    }
    public void setConsulta(String sql){
        try{
            stmt=con.createStatement();
            rs=stmt.executeQuery(sql);
        }catch(SQLException ex)
        {
            ex.printStackTrace();
        }
    }
    public ResultSet getRs() throws SQLException
    {
            return rs;
    }
}