CODEWITHSUNDEEP
javamysqlexecutequery
Jack cole
Jack cole

Reputation: 447

How can I print the entire database

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());

Upvotes: 0

Views: 1549

Answers (2)

edhedges
edhedges

Reputation: 2718

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));
    }
}

Upvotes: 1

mabroukb
mabroukb

Reputation: 701

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();
    }

Upvotes: 3

Related Questions