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

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.