import java.sql.*;

public class DatabaseConnection {

    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        // TODO Auto-generated method stub
        String dbURL= "jdbc:mysql://127.0.0.1:3036/auto";
        String username = "root";
        String password = "root";
        String query = "SELECT * FROM auto.employee";
        DriverManager.registerDriver(new com.mysql.jdbc.Driver());
        Connection con = DriverManager.getConnection(dbURL,username,password);
        Statement stmt= con.createStatement();
        ResultSet rs= stmt.executeQuery(query);
        String result = rs.toString();
        System.out.println(result);
        while (rs.next()){
            String myName = rs.getString(1);
            String myAge = rs.getString(2);
            System. out.println(myName+"  "+myAge);
        }
        con.close();
    }
}