Hi Friend,

Try the following code:

<%@page import=" java.sql.*, java.util.*"%>
<%
try{
Connection conn=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
conn = DriverManager.getConnection("jdbc:odbc:access");

String INSERT_RECORD = "insert into insertDate(id,myDate) values(?, ?)";

PreparedStatement pstmt = conn.prepareStatement(INSERT_RECORD);
pstmt.setString(1, "1");
java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());
pstmt.setDate(2, sqlDate);
pstmt.executeUpdate();
pstmt.close();
conn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>

Thanks

this is for the help of jsp connection string and the jsbc connecting pool