Inserting Date into Ms- Access Using jsp

sriram225's Avatar, Join Date: May 2009
Go4Expert Member
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
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
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.
sriram225's Avatar, Join Date: May 2009
Go4Expert Member
Quote:
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.
Thanks for your Repli Nmesh i wil work on that!!!
sriram225's Avatar, Join Date: May 2009
Go4Expert Member
Quote:
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.
u didn't get my question bro!!!