Database Access - Java - page 763

<tr><th>id<th>date<th>theme<th>maxspeakers<th>roles_order</tr>
<tr><td>21<td>2014-01-07<td>Everything Old is New Again<td>7<td>null</tr>
<tr><td>22<td>2014-01-14<td>T.B.A.<td>7<td>null</tr>
<tr><td>23<td>2014-01-21<td>T.B.A.<td>7<td>null</tr>
<tr><td>24<td>2014-01-28<td>T.B.A.<td>7<td>null</tr>
<tr><td>25<td>2014-02-04<td>T.B.A.<td>7<td>null</tr>
<tr><td>26<td>2014-02-11<td>T.B.A.<td>7<td>null</tr>
<tr><td>27<td>2014-02-18<td>T.B.A.<td>7<td>null</tr>
<tr><td>28<td>2014-02-25<td>g Somehing New<td>7<td>null</tr>
<tr><td>29<td>2014-03-03<td>Spring is in the air?<td>null<td>null</tr>
<tr><td>2<td>2014-03-05<td>Peak Performance<td>null<td>null</tr>
<tr><td>30<td>2014-03-10<td>Peak Performance<td>5<td>null</tr>
<tr><td>31<td>2014-03-17<td>Spring Break<td>null<td>null</tr>
</table>

The code for ResultsDecorator and ResultsDecoratorText is shown in Examples 18-12
and 18-13 , respectively. These programs are quite general and have no dependency on
SQLRunner .

Example 18-12. ResultsDecorator.java
package package com . darwinsys . sql ;

import import java.io.IOException java.io.IOException ;

import import java.io.PrintWriter java.io.PrintWriter ;

import import java.sql.ResultSet java.sql.ResultSet ;

import import java.sql.SQLException java.sql.SQLException ;

import import com.darwinsys.util.Verbosity com.darwinsys.util.Verbosity ;

/** Base class for a series of ResultSet printers. */
public public abstract abstract class class ResultsDecorator ResultsDecorator {

PrintWriter out ;
Verbosity verbosity ;

ResultsDecorator ( PrintWriter wr , Verbosity v ) {
this

this . out = wr ;
this

this . verbosity = v ;

}

/** Print the name of this Decorator's output format */
public public abstract abstract String getName ();

/** Print the contents of a ResultSet */
public public abstract abstract int int write ( ResultSet rs ) throws throws IOException , SQLException ;