Insert-Retrieve Autonumber in Ms Access using JSP
 

My Db SChema...

When i Insert a record how can i write my query ???
insert into table_name (ser_no,name) values('','jagadesh');
but this is not working....and after inserting succesfully i have to print AUTONUMBER (Retrieving) for correspoding record inserted !!??

Any Help Would be Greatly Appreciated Thank You!!!!

Re: Insert-Retrieve Autonumber in Ms Access using JSP
 

Please cut out that excessive use of dots, exclamation, question marks and Advertisement Like Words. You now look like an annoying little yelling child. Please don't do that. Please come over as a professional, try to ask questions the smart way.

With regard to your problem, use Statement#getGeneratedKeys().