Hello everybody!!!!!!!
I'm trying to return a resultset from a Javabean but it doesn't work. So I
send you the code, hoping that someone can solve my problem.
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
JAVABEAN:
public class provabean {
public ResultSet Esegui(int numero) {
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:wds","sa","");
CallableStatement cs = con.prepareCall( "{call pippo(?)}");
cs.clearParameters();
cs.setInt(1,numero);
System.out.println("Ciao6");
ResultSet rs = cs.executeQuery();
return rs;
} catch (Exception E) {
System.out.println("Errore : "+E.getMessage());
return null;
}
}
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
JSP PAGE:
<jsp:useBean id="prova" class="provabean" />
<HTML>
<HEAD>
<TITLE>ELENCO OGGETTI PER PADRE
<%
import java.sql.*;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
%>
</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<%
ResultSet pippo = prova.Esegui(Integer.parseInt(IdFather));
while (pippo.next())
{
out.println(pippo.getString("object")+"<BR>");
}
pippo.close();
%>
</BODY>
</HTML>
Can anyone give me some help?????
Thanks to everybody!!!!!!!!!!!
Roberto
===========================================================================
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