Hi
I have a very basic question regd retrieving information from website using
Java:
Basically I am working on the development of a database where a user enters
an address (street, city, state, zipcode). Based on the user input of the
address, I need to dynamically determine the latitude and longitude of that
address from the internet. One such website was :
http://stevemorse.org/jcal/latlon.php where we enter the street, city, state
and zipcode etc and the webpage returns the latitude and longitude. The
database is developed in Oracle and the interaction with the database is
handled thru JDBC. My question is: How can I retrieve information from the
website and put it in my database ? If anyone can point me to some tutorial
or resource on the topic it would be great ! Thanks.,
Andrew Thompson - 07 Aug 2006 17:58 GMT
...
> I have a very basic question regd retrieving information from website using
> Java:
[quoted text clipped - 8 lines]
> handled thru JDBC. My question is: How can I retrieve information from the
> website and put it in my database ?
Step 1. Get the permission from the site owner.
Step 2. Ask what method they prefer used for programatic
access to their web-site resources.
...
Andrew T.
Norman D. - 07 Aug 2006 19:42 GMT
It might be easier to hop on google and search out a free web service
that accepts an address and provides the latitude and longitude
information back to you, in some kind of XML format. This approach may
be easier than trying to interact with some poor person's website and
strip the HTML (which is subject to change whenever/however the site
owner feels like it).
-Norman
> Hi
>
[quoted text clipped - 11 lines]
> website and put it in my database ? If anyone can point me to some tutorial
> or resource on the topic it would be great ! Thanks.,
venkks@gmail.com - 07 Aug 2006 20:46 GMT
> Hi
>
[quoted text clipped - 11 lines]
> website and put it in my database ? If anyone can point me to some tutorial
> or resource on the topic it would be great ! Thanks.,
hi
You can use this free service from census.gov also if you wish:
http://www.census.gov/cgi-bin/gazetteer?city=&state=&zip=06905
thanks
Brad Pitt - 07 Aug 2006 22:51 GMT
Open a Socket Connection to a URL. You will not be able to use Ajax as
ajax will not allow diff domain commnunication.
Search on Google how to open a Socket Connection to a URL. The URL
though should be publicly available without any passwords or things
like that. Its the same as Telent to port 80 and the do a GET index.htm
and it will actually retreieve that page.
> Hi
>
[quoted text clipped - 11 lines]
> website and put it in my database ? If anyone can point me to some tutorial
> or resource on the topic it would be great ! Thanks.,