By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,609 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

jsp to sql

P: 4
i am design jsp website some date in sql server how i connect sql to jsp and desplay-
Sep 9 '08 #1
Share this Question
Share on Google+
1 Reply


Delerna
Expert 100+
P: 1,134
The basics are

1) Create an ActiveX ODBC connection object to the sql server
2) Create an ActiveX ODBC recordset object to store the data into
3) Write an SQL query int a string variable
4) Excute the query with the connection object and recieve the records into the recordset object
5) Loop through the recordset object and using document.write send the data to the user in a standard html table.


Thats the basics, for more detail you will need to provide more detail.
Or search google with some of the above terms

Regards and good luck. Its tough but possible. I taught myself with the help of google and websites such as this one. You just need to be more specific with your questions. ;)
Sep 9 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.