467,915 Members | 1,274 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

jsp to sql

i am design jsp website some date in sql server how i connect sql to jsp and desplay-
Sep 9 '08 #1
  • viewed: 1031
Share:
1 Reply
Delerna
Expert 1GB
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.

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.