- try {
- ResultSetMetaData metaData = rs.getMetaData();
- int rowCount = 0;
- Column[] cols = getColumns(metaData);
-
- pw.println("----------------------------------");
- for (int idx = 1; idx <= cols.length; ++idx) {
- pw.print("|" + cols[idx - 1].getLabel());
- }
- pw.println("|");
-
- while (rs.next()) {
- for (int idx = 1; idx <= cols.length; ++idx) {
- pw.print("|" + rs.getObject(idx));
- }
- pw.println("|");
- }
- pw.println("----------------------------------");
- pw.println("" + rowCount + " row(s) returned.");
-
- return rowCount;
- }
- catch (ClassNotFoundException exc) {
- throw new SQLException(exc);
- }