viewing results of mysql query in java

Question

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

AbdullahC · Accepted Answer · 2010-11-20 14:48:01Z

4

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

answered Nov 20, 2010 at 14:48

AbdullahC

6,7103 gold badges29 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

viewing results of mysql query in java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related