Hi!
Are u sure the System.out.println will display the records in the JSP
page, think we have to use the JSP printWriter implicit object "out" to
display something in the JSP page.
Now this gives rise to..
1. Suppose we want to display something from a bean like System.out.println
in the JSP page,
do we have to pass the implicit out object to the bean or which way?
can we invoke a method say.. write() in the JSP page from a bean??
a jdbc question too..
what exactly is class.forName does....
At 03:15 AM 1/4/01 -0800, you wrote:
> In the bean put all the relevant commands in order to open the connection
>with the database. Lets say that you have a method called
>
>public void openConnection()
>{
> try
> {
> // Load the database's drivers.
> Class.forName("database's drivers here");
>
> // Obtain connection with the database.
> Connection dbcon = DriverManager.getConnection("databse address
>here", "username here", "password here");
>
> // create new statemtn here.
> Statement stmt = dbcon.createStatement();
>
> String select = "SELECT * FROM <table name here>";
>
> // get the whole result set
> ResultSet rs = stmt.executeQuery(retrieve);
>
> // go through all rows
> while (rs.next())
> {
> System.out.println(rs.toString());
> }
>
> } // end try
> // If driver not found.
> catch (ClassNotFoundException cnfe)
> {
> System.out.println("Driver not found. " + cnfe);
> }
> catch (SQLException sqle)
> {
> System.out.println("Connection to the database could not be
established.
>" + sqle);
> }
>}
>
>Then define a bean in the jsp page using the <jsp:useBean> tag.
>
> Call the openConnection using the beans reference name (lets say that the
>reference to the bean is called myBean) myBean.openConnection();
>this will open the connection with the database and will display all the
>data in the specified table.
>
> You can have two diffreent methods if you want. One to open the
>copnnection and the other to get the data. You can call them with the same
>way. Do not forget to close the connection with the databse after you
>finish. Use the close() method in order to do it.
>
> Hope this helps.
>
>
>
>
>>From: Deepak Kumar <[EMAIL PROTECTED]>
>>Reply-To: A mailing list about Java Server Pages specification and
>> reference <[EMAIL PROTECTED]>
>>To: [EMAIL PROTECTED]
>>Subject: Executing SQL query in bean
>>Date: Thu, 4 Jan 2001 02:48:54 -0800
>>
>>Hi Friends,
>>
>>I want to write the code of JDBC connectivity in a
>>bean and then use the resultset in JSP page how can i
>>accomplish this.
>>
>>Thanks in advance.
>>Deepak Kumar
>>
>>__________________________________________________
>>Do You Yahoo!?
>>Yahoo! Photos - Share your holiday photos online!
>>http://photos.yahoo.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
>
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
