You should send us the code that you're having problems with so that we'll
know the details of your problem.
Please be as specific as possible so that we don't have to 'guess' ;-(
-----Original Message-----
From: Walter Priesnitz Filho [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 11:37 AM
To: [EMAIL PROTECTED]
Subject: Re: JSP + ResultSets
I found a code in Java Developer's Journal and I'm trying but I'm not vad
success.
Could you help-me?
Thanks...
-----------------------------------------
Walter Priesnitz Filho
Mestrando em Ciencia da Computacao
[EMAIL PROTECTED] | [EMAIL PROTECTED]
http://www.inf.ufsc.br/~walterp
-----------------------------------------
----- Original Message -----
From: "Joseph Ottinger" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 4:01 PM
Subject: Re: JSP + ResultSets
> >Hi all,
> >I need help with an apllication.
> >I need make a query in an Oracle Table and put the result in a html
table.
> >How can I pass the resultset from Oracle to JSP?
> >Does anybody help-me???
>
> You don't "pass the resultset from Oracle to JSP."
>
> I don't know what kind of architecture you're using, but here's a simple,
> incomplete, and quite flawed example:
>
> <!-- ... assume full setup has been done, to the point where the
Connection
> is in a variable called "conn" -->
> <table>
> <%
> PreparedStatement ps=conn.createPreparedStatement("select * from
my_table");
> ResultSet rs=ps.executeQuery();
> while(rs.next())
> {
> out.println("<tr><td>"+rs.getString(1)+"</tr></td>");
> }
> rs.close();
> %>
> </table>
>
> Voila! Table from a resultset! Lacks all exception handling and error
> trapping, uses massive scriptlets, as maintainable as... um... well, it's
> not really maintainable.
>
> A better route would be to use EJBs or a MVC approach (where a front end
> servlet is responsible for constructing the resultset).
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
===========================================================================
> 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
===========================================================================
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
