Dennis,
if you are going to do data access in Java you need to use JDBC. Look at the
JDK docs, there's a JDBC guide (I think). The package you are interested in
is java.sql.*
Kevin Jones
DevelopMentor
www.develop.com
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Dennis Huang
> Sent: 13 September 2000 00:07
> To: [EMAIL PROTECTED]
> Subject: Converting ASP codes to JSP
>
>
> 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
===========================================================================
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
