How to get collection of data from database

See more:

Java

SQL

SQL-Server

MySQL

, +

Hi
Code below as I see it get specific value from database. What do you use to get the collection of all values inside your tables

resultSet = statement.executeQuery("SELECT password,username FROM tbl_Credantials");
            while (resultSet.next())
            {
                  String userName = resultSet.getString("username ");

            }

I need something that works the same as this code below

OleDbCommand cmd = new OleDbCommand("SELECT * FROM tbl_Credantials", con);


                DataTable dTable = new DataTable();
                OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
                adapter.SelectCommand = cmd;
                adapter.Fill(dTable);

                return dTable;