A Desktop Java application to manage three master tables; country, province and city. Please see sample screen shot. Data must be presented like this. After opening a Country with it's three letter country code, like USA, the United States should open, and all states already entered, must appear in the province datagrid. After clicking on a State like California, It must show all cities for California in the database, as well as allow for adding and deleting them.
Here is a review of the buttons:
New - Creates New Country, then disable button.
Open - Make active on entering a County code into the Country Code text box, then allow for opening a single country record from database.
Save - Saves all changes to Country Name, Country Memo, any new Provinces Added or Edited, and any new Cities Added or Edited.
Delete - Delete Country (with "are you sure") and cascade deletes all provinces and cities
Print - Prints Current country with it's provinces and Cities
Close - Close Window (Please disable standard OS Close, minimize buttons)
Find - should bring up a search screen with three text boxes: Country, Province, City. When search results are double clicked, it should display the country found.
![][1]
MySQL database is attached.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows 2000, Java, MySQL