Go4Expert

Go4Expert (http://www.go4expert.com/)
-   JSP (http://www.go4expert.com/forums/jsp/)
-   -   Inserting Date into Ms- Access Using jsp (http://www.go4expert.com/forums/inserting-date-ms-access-using-jsp-t17810/)

sriram225 1Jun2009 18:22

Inserting Date into Ms- Access Using jsp
 
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:

nimesh 3Jun2009 12:30

Re: Inserting Date into Ms- Access Using jsp
 
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 3Jun2009 16:48

Re: Inserting Date into Ms- Access Using jsp
 
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 4Jun2009 16:05

Re: Inserting Date into Ms- Access Using jsp
 
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!!!


All times are GMT +5.5. The time now is 11:29.