Hi, we are releasing the opensource JSPKit (www.jspinsider.com) this
weekend, and within it will be a series of Classes and Beans
which will show you how to perform Database connectivity.
Another good example is the PoolMan software
http://www.codestudio.com/
Also You can refer to the JDBC API tutorial printed by Addison Wesley
You will find the Switch over from using the ADO object to JSP to be a
little frustrating at first. Since the ADO currently has more features and
is very easy to use. I highly recommend the JDBC API reference in helping
you in the issue.
Casey Kochmer
[EMAIL PROTECTED]
>From: Dennis Huang <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Converting ASP codes to JSP
>Date: Wed, 13 Sep 2000 10:07:23 +1100
>
>Hi:
>
>I have ASP codes which calls a stored procedure in SQL Server and want to
>convert them to JSP. Can you please give me an idea on how to do it in
>JDBC?
>
>set Conn=Server.CreateObject("ADODB.Connection")
>Set CmdOrderDetails = Server.CreateObject("ADODB.Command")
>CmdOrderDetails.ActiveConnection = Conn
>CmdOrderDetails.CommandType = adCmdStoredProc
>CmdOrderDetails.CommandText = "sp__SaveCreditCardDetails"
>
>CmdOrderDetails.Parameters.Append
>CmdOrderDetails.CreateParameter("CardName", adVarChar, adParamInput,
>100,CardName)
>CmdOrderDetails.Parameters.Append
>CmdOrderDetails.CreateParameter("CreditCardID", adInteger, adParamInput, ,
>CardType)
>CmdOrderDetails.Parameters.Append
>CmdOrderDetails.CreateParameter("ExpiryDate", adVarChar, adParamInput, 4,
>cardexpirydate)
>CmdOrderDetails.Parameters.Append CmdOrderDetails.CreateParameter("CardNo",
>adVarChar, adParamInput, 16, CardNumber)
>CmdOrderDetails.Parameters.Append
>CmdOrderDetails.CreateParameter("TotalPaid", adInteger, adParamInput, ,
>Total)
>CmdOrderDetails.Parameters.Append
>CmdOrderDetails.CreateParameter("AccountNo", adVarChar, adParamInput, 10,
>AccountNo)
>CmdOrderDetails.Parameters.Append
>CmdOrderDetails.CreateParameter("mobileNo", adVarChar, adParamInput, 10,
>mobileNo)
>CmdOrderDetails.Parameters.Append
>CmdOrderDetails.CreateParameter("PaymentID", adInteger, adParamOutput)
>CmdOrderDetails.Execute
>
>Thanks,
>
>
>Dennis
>
>===========================================================================
>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
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.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
