I am developing a directory Web site that allows the user to perform two different types of searches to locate businesses. I am using JSP with embedded Java code to perform searches on an Access database. I have added functionality so that the user can search by city/state or zip code in both types of searches and I want to add an option for distance so that the user can search for businesses within a 10 mile radius (for example) from the city/state or zip code input. So I need someone to modify my existing code so that each of my two search options also has the option to input the distance and return only the appropriate results from the database. You will need to write separate (but similar) code for each search option. It will be similar to a store locator such as this one: <[login to view URL]>= except that my site contains all different kinds of businesses. An efficient method of finding the businesses within the specified distance must be implemented as there will be many businesses located in my database and the user should not have to wait long for results. Please contact me with any questions. Thank you.
## 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
Apache Tomcat 6