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
