Re: [dbutils] MapMapHandler

[Norris Shelton <no...@yahoo.com>]

Sorry, I just noticed that some of my comments still referred to
List.

--- Norris Shelton <no...@yahoo.com> wrote:

> Turns a result set into a map of maps.  I needed it to turn a
> result set into a map of state abbreviations keys with state
> information maps as values.
> 
> It has 2 constructors.  The empty constructor assumes that
> there
> is going to be a column named key that will serve as the map
> key.  there is another constructor that takes a String that is
> used to identify the key column.
> 
> Here is the code.  FYI, I get a depracated warning on the
> BasicRowProcessor.instance(), but I was not familiar enough
> with
> the code to know what it does or what it should now be or if
> it
> was even needed.
> 
> 
> 
> --- David Graham <gr...@yahoo.com> wrote:
> 
> > What does MapMapHandler do?
> > 
> > David
> > 
> > --- Norris Shelton <no...@yahoo.com> wrote:
> > 
> > > I made a MapMapHandler and wanted someone to look at it to
> > see
> > > if it is worth submitting.
> > > 
> > > =====
> > > 
> > > Norris Shelton
> > > Software Engineer
> > > Sun Certified Java 1.1 Programmer
> > > Appriss, Inc.
> > > ICQ# 26487421
> > > AIM NorrisEShelton
> > > YIM norrisshelton
> > > 
> > > 
> > > 
> > > 		
> > > _______________________________
> > > Do you Yahoo!?
> > > Declare Yourself - Register online to vote today!
> > > http://vote.yahoo.com
> > > 
> > >
> >
>
---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > commons-dev-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail:
> > commons-dev-help@jakarta.apache.org
> > > 
> > > 
> > 
> > 
> > 
> > 		
> > _______________________________
> > Do you Yahoo!?
> > Declare Yourself - Register online to vote today!
> > http://vote.yahoo.com
> > 
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> > commons-dev-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> > commons-dev-help@jakarta.apache.org
> > 
> > 
> 
> =====
> 
> Norris Shelton
> Software Engineer
> Sun Certified Java 1.1 Programmer
> Appriss, Inc.
> ICQ# 26487421
> AIM NorrisEShelton
> YIM norrisshelton
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection
> around 
> http://mail.yahoo.com > /*
> * Copyright 2003-2004 The Apache Software Foundation
> *
> * Licensed under the Apache License, Version 2.0 (the
> "License");
> * you may not use this file except in compliance with the
> License.
> * You may obtain a copy of the License at
> *
> *     http://www.apache.org/licenses/LICENSE-2.0
> *
> * Unless required by applicable law or agreed to in writing,
> software
> * distributed under the License is distributed on an "AS IS"
> BASIS,
> * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
> or implied.
> * See the License for the specific language governing
> permissions and
> * limitations under the License.
> */
> package org.apache.commons.dbutils.handlers;
> 
> import org.apache.commons.dbutils.*;
> 
> import java.sql.ResultSet;
> import java.sql.SQLException;
> import java.util.HashMap;
> import java.util.Map;
> 
> /**
>  * <code>ResultSetHandler</code> implementation that converts
> a
>  * <code>ResultSet</code> into a <code>List</code> of
> <code>Map</code>s. This
>  * class is thread safe.
>  * @author David Graham
>  * @author Norris Shelton
>  * @see org.apache.commons.dbutils.ResultSetHandler
>  */
> public class MapMapHandler extends MapListHandler implements
> ResultSetHandler {
> 
>     private String key = "key";
> 
>     /**
>      * The RowProcessor implementation to use when converting
> rows into Maps.
>      */
>     private RowProcessor convert =
> BasicRowProcessor.instance();
> 
>     /**
>      * Creates a new instance of MapListHandler using a
> <code>BasicRowProcessor</code>
>      * for conversion.
>      */
>     public MapMapHandler() {
>         super();
>     }
> 
>     public MapMapHandler(String key) {
>         super();
>         this.key = key;
>     }
> 
>     /**
>      * Creates a new instance of MapListHandler.
>      *
>      * @param convert The <code>RowProcessor</code>
> implementation
>      * to use when converting rows into Maps.
>      */
>     //public MapMapHandler(RowProcessor convert) {
>     //    super();
>     //    this.convert = convert;
>     //}
> 
>     /**
>      * Converts the <code>ResultSet</code> rows into a
> <code>Map</code> of
>      * <code>Map</code> objects.
>      * @return A <code>Map</code> of <code>Map</code>s, never
> null.
>      * @throws java.sql.SQLException
>      * @see
>
org.apache.commons.dbutils.ResultSetHandler#handle(java.sql.ResultSet)
>      */
>     public Object handle(ResultSet rs) throws SQLException {
> 
>         Map results = new HashMap();
> 
>         Map temp = null;
>         while (rs.next()) {
>             temp = convert.toMap(rs);
>             results.put(temp.get(key), convert.toMap(rs));
>         }
> 
>         return results;
>     }
> }
> 
> >
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> commons-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
commons-dev-help@jakarta.apache.org


=====

Norris Shelton
Software Engineer
Sun Certified Java 1.1 Programmer
Appriss, Inc.
ICQ# 26487421
AIM NorrisEShelton
YIM norrisshelton


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org