Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Inserting Date into Ms- Access Using jsp
my Table (named as Services) in Ms -Access database contains Following fields...
I am inserting data into this table.........
I am Taking name value from an html input page and my jsp page for processing this.......
String str="insert into services values('',?,******);//How To INSERT DATE HERE
out.print("SQL Not Executing");
Now I want to Insert Date into my Table "services ".........my date format should be like this dd-mmm-yyyy What are necessary changes i have to make in InputMask or format field of date(Date/time) in Ms-Access and the code i have to use in Jsp Page to get date....
And in my insert Statement firsld field is of Autonumber ,wat are problems with this during inserting....and after inserting one row i wat to retieve autonumber value ..
Any help would be greatly appreciated ....many thanks in advance