Hi,
besides, the order of insertion and retrieval of the
entries are not the same using a hashtable.
TableModel is essentially a convenient wrapper around
a 2-D vector of Objects that is ready for JTable use;
or for row/col traversal in the HTML/jsp case.
ron
--- Sunil Roy <[EMAIL PROTECTED]> wrote:
> Hai Flores,
>
> Could You pl. tell me why we have to go thru so mch
> complication when we can
> achieve the same goal easily with a 2-d array, both
> for retrieval from
> resultset inside the servlet & also for displaying
> the result in the JSP.
>
> What is the advantage of using a hashtable(
> containing vectors as its
> values), instead of simply using a 2-d array.
>
> Your method is definitely, but appears to be far too
> complicated compared to
> arrays.
>
> Bye
>
> Sunil Roy
>
> ----- Original Message -----
> From: "T A Flores" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, November 04, 2000 9:33 PM
> Subject: Re: resultset to jsp
>
>
> > 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
>
>
===========================================================================
> 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!?
Yahoo! Calendar - Get organized for the holidays!
http://calendar.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
