Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 63858

Moved to the JDBC forum.

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

Joined: Oct 23, 2005
Posts: 3753

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.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: Extract Date from JSP and push to MySQL
It's not a secret anymore!