Hi,
I would like to explain what I am trying to achieve.
a) I have an Html file which takes the username and password from the
user.
b) In the Submit button of this file I am calling a user.jsp file.
This jsp file calls a bean named userauth.java which checks for user
authentication against the oracle
database.
I am creating a connection object in this bean and it has a scope as
session.
c)If the connection is successful I am calling an employee.html file for
entering the employee details.
d)The submit button of this html calls a file named insert.jsp.
This file is responsible for getting the table name,column names(in an
array), and column values(in an array) from the employee
form.
The table name is got in the form of an hidden field in the form.
e)This insert.jsp calls a bean named insert.java in which I am using
the prepared statement to insert data in the database.
I intend to write a generalized bean to insert data in the database.
I want to use the same connection that was opened for user
authentication in the insert bean.
Pl. Can somebody guide me how to use the connection object created in
one bean in another bean.
I would also like you to comment on the above idea and let me know if
there is a better way of achieving
the above functionality.
A bit urgent please.
Regards,
Tushar
===========================================================================
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
