public class Main {

    public static void main(String[] args) {

        DBConnect connect = new DBConnect();
        connect.getData();
    }

}

import java.sql.*;


public class DBConnect {



    private Connection con;
    private Statement st;
    private ResultSet rs;

    public DBConnect(){
        try{

            Class.forName("com.mysql.jdbc.Driver");


            con = DriverManager.getConnection("jdbc:mysql://localhost:8080/software","root","usbw");

            st = con.createStatement();


        }catch(Exception ex){

            System.out.println("Error:" + ex);

        }


    }

    public void getData(){

        try{

            String query="select from * football";

            rs = st.executeQuery(query);

            System.out.print("Records from the database");

            while(rs.next()){
                String name = rs.getString("Name");

                System.out.print("Name: "+name+" ");
            }
    }catch(Exception ex){
        System.out.println(ex);
    }

}
}