how to reterive the static data on the page
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   talluri_rambabu
Posted On:   Sunday, May 20, 2001 11:04 PM

Respected sir, in an appilication which i want to develop the requirment is that we should get the online stock values from a site and post them into the database . can u please suggest me wat to do and if possible please send the code which will be fetching the data from the site and post the values into the database for example the data 5/17/2001 Market Closed | Nasdaq 2193.68 27.24 +1.26% | DJIA 11248.58 32.66 +0.29% | S&P 1288.49 3.5 +0.27% on the site http://quotes.nasdaq.com/quote.dll?page=nasdaq100 should be posted into the database as "Exchange:nasdaq COMPANY:DJIA CLOSING:11248 HIGH:32.66 RAISE:+0.29 DATE:5/17/2001 " every time the dat   More>>

Respected sir,
in an appilication which i want to develop
the requirment is that we should get the online stock values
from a site and post them into the database .


can u please suggest me wat to do and if possible please send the code
which will be fetching the data from the site and post the values into the database


for example the data
5/17/2001 Market Closed | Nasdaq 2193.68 27.24 +1.26% | DJIA 11248.58 32.66 +0.29% | S&P 1288.49 3.5 +0.27%
on the site
http://quotes.nasdaq.com/quote.dll?page=nasdaq100


should be posted into the database as "Exchange:nasdaq COMPANY:DJIA CLOSING:11248 HIGH:32.66 RAISE:+0.29 DATE:5/17/2001 " every time the data has been
refreshed on the site along with the time as when it has refershed.WHERE EXCHANGE,COMPANY,CLOSING,HIGH ARE DATABASE FEILD NAMES

   <<Less
Report | Quote This | Send private message | Reply | Print

Re: how to reterive the static data on the page

Posted By:   Anonymous  
Posted On:   Saturday, May 26, 2001 12:25 AM

You should use java.net.URLConnection to get the page, then you can write some kind of parser based on the page, that will extract the data, and, finally, you write few JDBC methods for saving the data to the database and, maybe, for querying.

Regards.
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact