Keep the connection open for the full session
Close the connection when the user tries to logout
Hope this helps
Sanjay
-----Original Message-----
From: Ron Chan [mailto:[EMAIL PROTECTED]]
Sent: 04 November 2000 14:02
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
