com.darwinsys.sql.ResultsDecoratorText Maven / Gradle / Ivy
/* Copyright (c) Ian F. Darwin, http://www.darwinsys.com/, 2004-2006.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
* 1. Redistributions of source code must retain the above copyright
* notice, this list of conditions and the following disclaimer.
* 2. Redistributions in binary form must reproduce the above copyright
* notice, this list of conditions and the following disclaimer in the
* documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS''
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
* TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS
* BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
*/
// tag::main[]
package com.darwinsys.sql;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import com.darwinsys.util.Verbosity;
/**
* Print a ResultSet in plain text.
*/
public class ResultsDecoratorText extends ResultsDecorator {
public ResultsDecoratorText(PrintWriter out, Verbosity v) {
super(out, v);
}
@Override
public int write(ResultSet rs) throws IOException,SQLException {
ResultSetMetaData md = rs.getMetaData();
int colCount = md.getColumnCount();
for (int i = 1; i <= colCount; i++) {
print(md.getColumnName(i) + "\t");
}
println();
int rowCount = 0;
while (rs.next()) {
++rowCount;
for (int i = 1; i <= colCount; i++) {
print(rs.getString(i) + "\t");
}
println();
}
return rowCount;
}
@Override
public void displayTable(String table, ResultSet rs)
throws IOException, SQLException {
write(rs);
}
@Override
public void printRowCount(int rowCount) throws IOException {
println("Rows: " + rowCount);
}
/* (non-Javadoc)
* @see ResultsDecorator#getName()
*/
@Override
public String getName() {
return "Plain text";
}
}
// end::main[]