Hi,

using hashtable.keys(), you do not get the original
insertion order of the entries.

1. extend hashtable with 'OrderedHashtable', that
allows one to return the original order and still have
the hashing retrieval.
2. the TableModel using twin vectors, does preserve
the original order. Probably use indexing by numbers
to retrieve than enumeration to be faster.

thanks,

ron


ps. please don't police a thread, it is over when it
is. This goes for that guy from JBuilder who
complaints about all vendor questions but I never see
those when it is about JBuilder




--- T A Flores <[EMAIL PROTECTED]> wrote:
> Duncan,
>
> You're right if the result set object is not passed
> to a collection it
> will be lost when the stmt/connection is closed.  I
> think enough of
> this thread since it was already sufficiently
> covered.
>
> I have for those who have an inability to search the
> archive attached
> the code in question.
>
> In the servlet . . . .
>
>      rs = stmt.executeQuery( sql );
>      while (rs.next( ) ){
>
>      Vector vector = new Vector();
>      vector.add(new Integer(rs.getInt("var1")));
>      vector.add(new Integer(rs.getInt("var2")));
>      vector.add(rs.getString("var3"));
>      vector.add(rs.getString("var1"));
>      hashtable.put(rs.getString("var1"),vector);
>
>      session.setAttribute("Name the hashtable",
> hashtable);
>
> then in the JSP . . . .
> <%
>      Enumeration enum=null;
>      Hashtable ht = new Hashtable();
>      Vector v = new Vector();
>
>      try{
>         ht =(Hashtable)
> session.getAttribute("HashtableName");
>          enum = ht.keys();
>          int i=0;
>          }catch(Exception
> e){System.out.println(e.toString());}
> %>
> <%
>            while(enum.hasMoreElements()){
>                v = (Vector)
> ht.get(enum.nextElement());
> %>
> <table>
> <tr>
>     <td><%=v.get(0).toString()%></td>
>     <td><%=v.get(1).toString()%></td>
>     <td><%=v.get(2).toString()%></td>
> </tr>
> <%
>      }
> %>
>
>
>
> ----- Original Message -----
> From: Duncan Rose <[EMAIL PROTECTED]>
> Date: Saturday, November 4, 2000 6:28 am
> Subject: Re: resultset to jsp
>
> > My understanding of it is that if you close the db
> > connection or the prepared statement or whatever,
> the
> > result set becomes invalid, so you can't reference
> > the ResultSet object after a connection closure
> (i.e.
> > the connection is not held open if you have a
> resultset
> > reference, rather the reference becomes invalid if
> you
> > close the connection).
> >
> > Could be wrong though.
> >
> >        -Duncan
> >
> > -----Original Message-----
> > From: Ron Chan [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, November 04, 2000 2:02 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: resultset to jsp
> >
> >
> > Hi,
> >
> > 1. you have a bean that does the database query.
> > 2. either that bean or a utility, iterates the
> > resultset for the column values, puts them into
> the
> > TableModel. put the TableModel into the session.
> > 3. In the jsp file, get from the session, and loop
> to
> > display into <table><tr><td>.
> >
> > one reason for not using the resultset was my
> concern
> > that the database connection is kept open. Can
> someone
> > confirm whether this is true or not.
> >
> > thanks,
> >
> > ron
> >
> >
> >
> > --- T A Flores <[EMAIL PROTECTED]> wrote:
> > > If you use the <table>or JTable how exactly are
> you
> > > getting the result
> > > set from the Servlet/Bean?
> > >
> > > ----- Original Message -----
> > > From: Ron Chan <[EMAIL PROTECTED]>
> > > Date: Friday, November 3, 2000 5:02 pm
> > > Subject: Re: resultset to jsp
> > >
> > > > Hi,
> > > >
> > > > why not put the resultset into a TableModel
> format
> > > for
> > > > transport. Whatever display, if AppleJTable,
> if
> > > html, can loop
> > > > rows and columns into a
> > > > <table> tag. etc.
> > > >
> > > > ron
> > > >
> > > >
> > > > --- T A Flores <[EMAIL PROTECTED]> wrote:
> > > > > It is possible, however, why would you want
> to
> > > use
> > > > > and array why not
> > > > > use a vector of hashtables.  I posted a
> response
> > > to
> > > > > a similiar problem
> > > > > using servlet to jsp last month (I believe
> more
> > > > > toward the middle of
> > > > > October).  Why don't you search the archive
> and
> > > see
> > > > > if that helps you
> > > > > at all.
> > > > >
> > > > > ----- Original Message -----
> > > > > From: Ginni <[EMAIL PROTECTED]>
> > > > > Date: Monday, January 3, 2000 3:27 pm
> > > > > Subject: resultset to jsp
> > > > >
> > > > > > hi,
> > > > > >
> > > > > > I query my database and get a resultset in
> my
> > > bean
> > > > > , now is it
> > > > > > possible to
> > > > > > get all the records in the resultset into
> an
> > > > > array. i want to
> > > > > > retrieve this
> > > > > > array in my jsp and display the values
> there.
> > > is
> > > > > that possible
> > > > > >
> > > > > > there are 2 things here,
> > > > > >
> > > > > > 1. i need to get the resultset into an
> array
> > > (in
> > > > > asp, i use
> > > > > > getrows() for
> > > > > > this purpose)
> > > > > > 2. i need to get the array into my jsp.
> (could
> > > i
> > > > > use getProperty
> > > > > > for this)
> > > > > >
> > > > > > thanks for ur time,
> > > > > > :-)
> > > > > > Have a great Day!
> > > > > > -Ginni
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
========================================================================
> > > > > ===
> > > > > > To unsubscribe: mailto
> [EMAIL PROTECTED]
> > > with
> > > > > body: "signoff
> > > > > > JSP-INTEREST".
> > > > > > Some relevant FAQs on JSP/Servlets can be
> > > found
> > > > > at:
> > > > > >
> > > > > > http://java.sun.com/products/jsp/faq.html
> > > > > >
> http://www.esperanto.org.nz/jsp/jspfaq.html
> > > > > >
> > > > >
> > >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > > > > >
> > > > >
> > > >
> > >
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>
========================================================================
> > > ===
> > > > > To unsubscribe: mailto [EMAIL PROTECTED]
> > > with
> > > > > body: "signoff JSP-INTEREST".
> > > > > Some relevant FAQs on JSP/Servlets can be
> found
> > > at:
> > > > >
> > > > >  http://java.sun.com/products/jsp/faq.html
> > > > >  http://www.esperanto.org.nz/jsp/jspfaq.html
> > > > >
> > >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > > > >
> > > >
> > >
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> > > >
> > > >
> > > >
> __________________________________________________
> > > > Do You Yahoo!?
> > > > From homework help to love advice, Yahoo!
> Experts
> > > has your answer.
> > > > http://experts.yahoo.com/
> > > >
> > > >
> > >
> >
>
========================================================================
> > > ===
> > > > To unsubscribe: mailto [EMAIL PROTECTED]
> with
> > > body: "signoff
> > > > JSP-INTEREST".
> > > > Some relevant FAQs on JSP/Servlets can be
> found
> > > at:
> > > >
> > > > http://java.sun.com/products/jsp/faq.html
> > > > http://www.esperanto.org.nz/jsp/jspfaq.html
> > > >
> > >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > > >
> > >
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> > > >
> > >
> > >
> >
>
========================================================================
> ===
> > > To unsubscribe: mailto [EMAIL PROTECTED]
> with
> > > body: "signoff JSP-INTEREST".
> > > Some relevant FAQs on JSP/Servlets can be found
> at:
> > >
> > >  http://java.sun.com/products/jsp/faq.html
> > >  http://www.esperanto.org.nz/jsp/jspfaq.html
> > >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > >
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Thousands of Stores.  Millions of Products.  All
> in one Place.
> > http://shopping.yahoo.com/
> >
> >
>
========================================================================
> ===
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff
> > JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found
> at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
> >
>
========================================================================
> ===
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff
> > JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found
> at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets


__________________________________________________
Do You Yahoo!?
Thousands of Stores.  Millions of Products.  All in one Place.
http://shopping.yahoo.com/

===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Reply via email to