Keya Shah

I am using mysql database.
In my jsp page, after inserting a record in the mysql table, I need to get back the new ID generated for the auto_increment primary key column. How do I get this value?

Any help appreciated.

Had to specify the path as /CC/Main.jsp

Thanks

My servlet gets redirected properly to a jsp page(MyPage.jsp), but clicking the links on that jsp page fails.

Get the error:
The requested resource (/CC/servlet/Main.jsp) is not available.

In MyPage.jsp page, the link is defined as follows:
<a href="Main.jsp">Back to Main Page</a>

but after the servlet redirects to MyPage.jsp, the link now have the servlet path attached to it(becomes http://localhost:8080/CC/servlet/Main.jsp instead of just Main.jsp), resulting in the above error when i click it.

I am a newbie, so any help is greatly appreciated.