Inserting Date into Ms- Access Using jsp - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's 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 its 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

hai frnds,
my Table (named as Services) in Ms -Access database contains Following fields...
[code]
num ----------"AUTONUMBER"
name---------"Text"
date----------"Date/Time"[/code]



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();
}
[/code]


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

Comments

Sign In or Register to comment.