Country State Dropdown Data / Java Program to create Country State Database Table Data

Hi,

I have been struggling long time to get the information for the country state Database Table Data and its implementation in My most of the application,

I have searched through net and now i got few data from the site and I have created Java file to generate the SQL Queries.

The Table Structure i have created as Follows.

Country

ID [PK]

NAME [VARCHAR].

State

ID [PK]

NAME [VARCHAR]

COUNTY_ID [PK] Foreign key to Country Table

You can download the java Class file to generate the SQL Queries directly from My Google Docs http://docs.google.com/Doc?docid=0AW0ekoc5wU3rZGYyMnZrZmtfN2NtYnF3dmQ0&hl=en

If you require the SQL File Directly you can download from My Docs as .

http://docs.google.com/Doc?docid=0AW0ekoc5wU3rZGYyMnZrZmtfOGQzM2c4NGdr&hl=en

I am Thankful to the website http://www.microcosmotalk.com/tech/scripts/ for the datas of countries and States in their site javascipt file.

[I converted Java and sql file to txt format just to upload in Google Docs. :) ]

Hope it will help you out.

Any Concerns Contact :- askeralim@gmail.com