If you design things properly, method 2 would be the preferred simply because it's
easier to reuse a JavaBean than a Servlet... or at least you're not tied needing a
servlet engine. Method 2 should also be more efficient as the JavaBean will run in
process with the JSP whereas the JSP would need to invoke the servlet of method 3 over
the wire somehow.
The most "professional" way would be to design your DB access bean such that it's use
isn't tied to JSP/Servlets or the app at hand, but in a way that you could re-use it
in an unrelated Swing app (for example).
-- Marc
> -----Original Message-----
> From: Mahesh Chhatlani [mailto:[EMAIL PROTECTED]]
> Sent: January 17, 2001 12:05 PM
> To: [EMAIL PROTECTED]
> Subject: Re: JSP to database communication
>
>
> Thanks for the tips,
> But to be more clear on this subject, say I want to write a new web
> application in JSP. Now I have to create a detail page where
> there will be 2
> or more queries(with joins) to fill up the page. Now should I
> use a JavaBean
> to have the query and logic to get data from the database and send the
> results to the JSP page, or have a Servlet do the above.
> Consider that BOTH
> options have the same network traffic, both are on the same server,
> etc.(like comparing apples to apples) I know "how" to do it,
> I just want to
> know the most "efficient" and "professional" way. Or does it
> matter either
> way? I know that option (1) is not the right way to do it.
> But for a Login
> check(uid/pwd), is it okay?
> Thanks.
> --mahesh
> PS: I get the feeling that option(2) is the right one....
> ***********************************************
> > Hi,
> > Which is the "suggested" way to access the database, say for
> > an intermediate
> > query that throws out about 100 rows.
> >
> > (1) JSP to db directly on a JSP page
> > (2) JSP to JavaBean (where the bean has all the db access)
> > (c) JSP to Servlet (where the Servlet accesses the db)
> >
> > For quick login checks, etc I use the 1st method.
> > What about queries that throw out more than 1000 rows? Which
> > method is the
> > "suggested" one?
> > Thanks.
> > --mahesh
> >**********************************************
>
> ==============================================================
> =============
> To unsubscribe: mailto [EMAIL PROTECTED] with body:
> "signoff JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set
> JSP-INTEREST DIGEST".
> 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".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
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
