How to insert DATE into mysql using JSP?

[sivakumar_sakam]

I want to insert Date into mysql using JSP,not system DATE, from JSP page.
Thanks....

[jogep]

You can use the setDate Function of PreparedStatement to set a Date.

Following Example set the current Date, but you can use any Date Object.

String INSERT = "insert into mydatetable(id, datecolumn) values(?, ?)";
    
PreparedStatement ps = conn.prepareStatement(INSERT);
ps.setLong(1, 1L);
ps.setDate(2, new Date());

[sivakumar_sakam]

thanks sir for reply.
In the above example new Date() is system Date, but i want to insert Date enter by the Client from the JSP page.
thnks

[jogep]

If you work without an framework the parameters are in the HttpRequest Object as String.

You can parse the parameter values with DateFormat.

Just Google for SimpleDateFormat for sample how to parse a String to Date.