I was wondering how I can rewrite a URL based on a SQL query.
What I want to do is the following. I have a requirements application running on
tomcat. To access a specific project directly, users must type the following url:
http://localhost:8080/contour/perspective.req?projectID=31
However, users do not know this projectID. So, I would like to replace projectID with another value, known to the user, so that users may type the following URL, for example:
http://localhost:8080/contour/id=31098
So I need whatever way so that when users type this URL, an SQL query can retrieve the projectID from a MySQL database and rewrite the URL. How can I accomplish that?
Thanks,
