CODEWITHSUNDEEP
javamysql
newQuesion
newQuesion

Reputation: 63

viewing results of mysql query in java

In java, when executing a query like :

statement stm = stm.executeQuery("select * from table1");

How can I view the results of this query on the command prompt ?

Thanks for any help

Upvotes: 1

Views: 3943

Answers (1)

AbdullahC
AbdullahC

Reputation: 6730

ResultSet rs = stmt.executeQuery("select * from table1");

int columns = rs.getMetaData().getColumnCount();

StringBuilder message = new StringBuilder();

while (rs.next()) {
    for (int i = 1; i <= columns; i++) {
        message.append(rs.getString(i) + " ");
    }
    message.append("\n");
}

System.out.println(message);  // print table contents

Upvotes: 4

Related Questions