Sorry, I did not mean to send directly to just you, but something like
this:
int rowNum = 0;
columnsAndRows = new HashMap();
while(myquery.next())
{
// increment the row number
rowNum++;
// add all columns from this row to the Map.
columnsAndRows.put ( "column_name1**" + rowNum, myquery.getObject(1) );
columnsAndRows.put ( "column_name2**" + rowNum, myquery.getObject(2) );
columnsAndRows.put ( "column_name3**" + rowNum, myquery.getObject(3) );
//........... and so on.
}
and then to fetch for eg: column_name2 on row 23 you do.
Object o = columnsAndRows.get("column_name3**23");
The nice thing about this is that there is only one HashMap involved instead
of MANY, and no ArrayList is needed. Also note that as HashMap's get bigger
they do not get slower.
Cheers
Adrian
> -----Original Message-----
> From: Bryan LaPlante [SMTP:[EMAIL PROTECTED]
> Sent: 27 February 2003 11:28
> To: Adrian Janssen
> Subject: Re: preparedStatement
>
> I am not sure what you mean, the row23 is throwing me off a bit. Do you
> mean
> that your key would be the column names and the value would be a delimited
> string of values?
>
> ----- Original Message -----
> From: "Adrian Janssen" <[EMAIL PROTECTED]>
> To: "'Bryan LaPlante'" <[EMAIL PROTECTED]>
> Sent: Thursday, February 27, 2003 2:53 AM
> Subject: RE: preparedStatement
>
>
> > A much less complicated approach is to just use one HashMap with a
> compound
> > key e.g."col_name1^^row23".
> >
> >
> > > -----Original Message-----
> > > From: Bryan LaPlante [SMTP:[EMAIL PROTECTED]
> > > Sent: 27 February 2003 06:18
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: preparedStatement
> > >
> > > What I have been doing in my custom tags could also apply to any query
> > > output situation. The following is in lieu of declaring your query
> > > TYPE_SCROLL_INSENSITIVE and then calling myquery.first() to reset the
> > > cursor back to the first row.
> > >
> > > //Create an ArrayList Of HashMaps
> > > ArrayList rows = new ArrayList();
> > > HashMap columns = null
> > >
> > > //as you output the query the first time also add it to the above
> > > structures.
> > > while(myquery.next()){
> > > columns = new HashMap();
> > > colums.put("column_name1",myquery.getObject(1));
> > > colums.put("column_name2",myquery.getObject(2));
> > > //........... and so on.
> > > // add the columns to a row
> > > rows.add(columns)
> > > }
> > >
> > >
> > > // then loop through your structure like so.
> > >
> > > rowIter = rows.iterator();
> > > while(rowIter.hasNext()){
> > > columns = rowIter.next();
> > > thismap.get("column_name1");
> > > thismap.get("column_name2");
> > > }
> > > //.......... and so on.
> > >
--
It is the strict policy of Truworths that its e-mail facility and all
e-mail communications emanating therefrom, should be utilised for
business purposes only and should conform to high professional and
business standards. Truworths has stipulated certain regulations in
terms whereof strict guidelines relating to the use and content of
e-mail communications are laid down. The use of the Truworths e-mail
facility is not permitted for the distribution of chain letters or
offensive mail of any nature whatsoever. Truworths hereby distances
itself from and accepts no liability in respect of the unauthorised
use of its e-mail facility or the sending of e-mail communications
for other than strictly business purposes. Truworths furthermore
disclaims liability for any unauthorised instruction for which
permission was not granted. Truworths Limited accepts no liability
for any consequences arising from or as a result of reliance on this
message unless it is in respect of bona fide Truworths business for
which proper authorisation has been granted.
Any recipient of an unacceptable communication, a chain letter or
offensive material of any nature is requested to notify the Truworths
e-mail administrator ([EMAIL PROTECTED]) immediately in order that
appropriate action can be taken against the individual concerned.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
