Catalog Case Study - Developing Java Servlets - page 333

L ISTING 20.9

ListMovies.java

import Service;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletContext;

import java.sql.*;
import java.util.*;

import ConnectionPool.*;
public class ListMovies implements Service {
public ListMovies() {
}

// Returns a Vector containing the column names found in the passed
// in ResultSet
private Vector getResultSetColumnNames(ResultSet rs)
throws Exception {
try {
// Get a reference to the ResultSet's meta data
ResultSetMetaData md = rs.getMetaData();
// Get the number of columns returned in the Result Set
int count = md.getColumnCount();
// Create a Vector to hold the Column Names
Vector columnNames = new Vector(count);
// Get all of the Column Names
for ( int x = 0; x < count; x++ ) {

// The column name indexes begin at 1
columnNames.addElement(md.getColumnName(x + 1));
}
return columnNames;
}
catch (SQLException sqlex) {
throw new Exception(sqlex.getMessage());
}

}

/*
Parse the ResultSet returning an array of HashMaps
*/
public Object[] parseResultSet(ResultSet rs) throws Exception {
Vector results = new Vector();
// Iterate over the ResultSet
Vector columnNames = getResultSetColumnNames(rs);
if ( rs == null ) {

20