I guess what you need is a sample code for database connection.
Here it is, taken from one of my JSP pages:
String url = "jdbc:odbc:ShopMart";
String query = "SELECT CustEmailID, CustPassword FROM Cust where
CustEmailID='" + sLogin + "' and CustPassword='" + sPassword + "'";
try
{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
java.sql.Connection con =
java.sql.DriverManager.getConnection (url, "admin", "");
java.sql.Statement stmt = con.createStatement ();
java.sql.ResultSet rs = stmt.executeQuery (query);
rs.next();
sLogin=rs.getString("CustEmailID");
rs.close();
stmt.close();
con.close();
}
catch(Exception ex)
{
if(ex.getMessage().compareTo("[Microsoft][ODBC Driver
Manager] Invalid cursor state")==0)
errMsg=" Incorrect Login";
else
errMsg="Unexpected SQL exception(1): " +
ex.getMessage() + ". Contact System Administrator.";
}
-----Original Message-----
From: Garcia, Cristina [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 12, 2000 9:32 AM
To: [EMAIL PROTECTED]
Subject: AW: Event from button
I am not very experienced in JSP (I began to programm an own prototype 2
days before) but what I did, was calling a Bean
(<%jsp:use Bean...%>), which is responsible of saving the data into the
database (using JDBC).
Hopefully can this help you :-)
> -----Urspr�ngliche Nachricht-----
> Von: kavitha ramasamy [SMTP:[EMAIL PROTECTED]]
> Gesendet am: Freitag, 12. Mai 2000 15:03
> An: [EMAIL PROTECTED]
> Betreff: Event from button
>
> Hello,
>
> I want to the following things when I click the save button in
> JSP page
> 1) All front end validations- This I achieved through JavaScript.
> 2) I need to insert the data in database, This I want to be done through
> JSP page, because all my datas are from session object.
>
>
> I have the following code to call javascript and I dont know how to
> insert the data through JSP page.
>
> By cllicking the button the validation and insertion of data has to be
> done.
>
> <input type="button" name="Button" value="Button" onClick="validation()">
>
> validation() is a javascript function.
>
>
> If anyone has any idea regarding this, that would be helpful to me.
> Thanks,
> Kavitha
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> ==========================================================================
> =
> 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
===========================================================================
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
===========================================================================
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
