X-Git-Url: http://jaekl.net/gitweb/?p=squelch.git;a=blobdiff_plain;f=src%2Fmain%2Fjava%2Fnet%2Fjaekl%2Fsquelch%2Fstmt%2FSelect.java;h=088181a50662c1015d0f1a936a29730e2bbfe531;hp=6d89af5c293c6dbf237e3f8dadf7b170013c7bb7;hb=63163502c2d86fad43c38ae4041c8bf4b2e4b387;hpb=7fdeab39832c2339711250dfb0a9a5c531ab7033

diff --git a/src/main/java/net/jaekl/squelch/stmt/Select.java b/src/main/java/net/jaekl/squelch/stmt/Select.java
index 6d89af5..088181a 100644
--- a/src/main/java/net/jaekl/squelch/stmt/Select.java
+++ b/src/main/java/net/jaekl/squelch/stmt/Select.java
@@ -61,20 +61,28 @@ public class Select extends Query {
 			ResultSetMetaData metaData = rs.getMetaData();
 			int rowCount = 0;
 			Column[] cols = getColumns(metaData);
-			
-			pw.println("----------------------------------");
+			StringBuilder sb = new StringBuilder();
+			sb.append("----------------------------------\n");
 			for (int idx = 1; idx <= cols.length; ++idx) {
-				pw.print("|" + cols[idx - 1].getLabel());
+				sb.append("|" + cols[idx - 1].getLabel());
 			}
-			pw.println("|");
+			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("|");
 			}
-			pw.println("----------------------------------");
+			if (rowCount > 0) {
+				pw.println("----------------------------------");
+			}
 			pw.println("" + rowCount + " row(s) returned.");
 			
 			return rowCount;