How can I print the entire database

Question

I have a table called ClientsTable and a database called myDb .

How can I print with System.out.prinln() the entire database ? I just want to select all the rows and present all the fields to the screen .

Thanks

EDIT: what should I put instead of rs.getString() , here (since it doesn't compile):

    ResultSet rs = this.m_statement.executeQuery("SELECT * FROM CheckingAccountsTable");
    while (rs.next())
        System.out.println(rs.getString());

@Blaine: 4 , but that doesn't work since I don't know what to put in the brackets of `rs` , here : ` ResultSet rs = this.m_statement.executeQuery("SELECT * FROM CheckingAccountsTable"); while (rs.next()) System.out.println(rs.getString());` — Jack cole, Aug 08 '12 at 18:50

score 3 · Accepted Answer · answered Aug 08 '12 at 19:05

3

if you don't know how many colums are in the table, try something like this :

    ResultSet rs = this.m_statement.executeQuery("SELECT * FROM CheckingAccountsTable");
    int columnCount = rs.getMetaData().getColumnCount();
    while (rs.next()) {
        for (int i = 1; i <= columnCount; i++) {
            System.out.print(rs.getString(i));
        }
        System.out.println();
    }

answered Aug 08 '12 at 19:05

mabroukb

691
4
11

You may want to add _another_ for loop before the while loop to print the column names from rs.getMetaData().getColumnName(i) – Chris Nava Aug 08 '12 at 21:01

edhedges · Answer 2 · 2012-08-08T19:06:52.373

1

The SQL query would be:

SELECT * FROM DB_TABLE_NAME

Then you can loop through your result set and print it out.

Edit:

You aren't specifying what column you want to print out.

Example below:

System.out.println(rs.getString("COLUMN_NAME"));

Second edit:

ResultSet rs = this.m_statement.executeQuery("SELECT * FROM CheckingAccountsTable");
int colCount = rs.getMetaData().getColumnCount();
while (rs.next()){
    for(int i = 1; i < colCount + 1; i++){
       System.out.println(rs.getString(i));
    }
}

edited Aug 08 '12 at 19:06

answered Aug 08 '12 at 18:46

edhedges

2,722
2
28
61

I want all the columns , without "knowing" what they are , is that possible ? – Jack cole Aug 08 '12 at 19:01
I believe you will need to have nested loops then. I will edit my answer. – edhedges Aug 08 '12 at 19:02
1

You can use getString with an integer instead of a string, getString(1) will return the 1st column for example – Benjamin Gruenbaum Aug 08 '12 at 19:02
I've made my changes which are close to @mabroukb – edhedges Aug 08 '12 at 19:07

How can I print the entire database

2 Answers2