- try {
- ResultSetMetaData metaData = rs.getMetaData();
- int rowCount = 0;
- Column[] cols = getColumns(metaData);
- StringBuilder sb = new StringBuilder();
- sb.append("----------------------------------\n");
- for (int idx = 1; idx <= cols.length; ++idx) {
- sb.append("|" + cols[idx - 1].getLabel());
- }
- sb.append("|\n");
- String header = sb.toString();
-
- while (rs.next()) {
- if (null != header) {
- pw.print(header);
- header = null;
- }
-
- for (int idx = 1; idx <= cols.length; ++idx) {
- pw.print("|" + rs.getObject(idx));
- }
- pw.println("|");
- }
- if (rowCount > 0) {
- pw.println("----------------------------------");
- }
- pw.println("" + rowCount + " row(s) returned.");
-
- return rowCount;
- }
- catch (ClassNotFoundException exc) {
- throw new SQLException(exc);
- }