aspose file tools*
The moose likes JDBC and the fly likes Extract Date from JSP and push to MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Extract Date from JSP and push to MySQL" Watch "Extract Date from JSP and push to MySQL" New topic

Extract Date from JSP and push to MySQL

Kavita Shivani
Ranch Hand

Joined: Aug 14, 2009
Posts: 45
Hi Everyone,
I have a date field in my JSP, I get it as a string in my controller through get parameter method. But from there I have no clue how do I convert it into date format and insert into database. Also I found in datebase that the date format is yyyy-mm-dd hh:mm:ss something like that. I assume there are ways of doing it and some standard way of doing it. Please suggest me on this.

Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 61756

Moved to the JDBC forum.

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3716

One of the nice things about JDBC is, as a developer, you don't to worry about date format. For adding a date to the database create a valid java.sql.Date (similar to java.util.Date) object and using a PreparedStatement, such as ps, call ps.setDate(numericIndex,dateValue). The JDBC driver will handle the conversion of the date format once you move it to a valid Java object.

And as always I have to say... PLEASE DO NOT PUT JDBC CODE INSIDE A JSP!!! Move your JDBC code to a reusable utility class. JDBC code inside a JSP is inherently unsafe and not reusable.

My Blog: Down Home Country Coding with Scott Selikoff
I agree. Here's the link:
subject: Extract Date from JSP and push to MySQL