Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / First Aid / August 2006

Tip: Looking for answers? Try searching our database.

retrieving information from website using Java

Thread view: 
Navodit - 07 Aug 2006 17:38 GMT
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.,


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.