hai frnds, my Table (named as Services) in Ms -Access database contains Following fields... Code: num ----------"AUTONUMBER" name---------"Text" date----------"Date/Time" And I am inserting data into this table......... I am Taking name value from an html input page and my jsp page for processing this....... Code: try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn=DriverManager.getConnection("jdbc:odbc:trail"); try { String str1=request.getParameter("name"); String str="insert into services values('',?,******);//How To INSERT DATE HERE PreparedStatement stmt=conn.prepareStatement(str); stmt.setString(1,str1); stmt.executeUpdate(); out.print("Succesfully Inserted"); conn.close(); } catch(SQLException e) { out.print("SQL Not Executing"); } } catch(Exception e) { e.printStackTrace(); } 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:happy:
First try inserting static data from the code, like String str="insert into services values('',?,#01-Jan-2009#)"; If that works then you should get the data from HTML page in the format above, and then you can use the below statement String str="insert into services values('',?,#" & vardate & "#)"; (where vardate is the variable used to store date from the HTML page) Remember # is the character that Access uses to identify that the value is a date value.