validating Date field and saving into DB?

[Vikrama Sanjeeva]

Hi,

There is a date field in JSP form where user will enter date in dd-mm-yyyy format. Now before saving into DB2, I want to validate the date format against dd-mm-yyyy format and then save into DB2.

I've tried reading SimpeDateFormat and other date format classes, but couldn't understand. It will be great if somebody tell the following with code.

1. How to validate Date so that it should satisfy dd-mm-yyyy format?
2. How to insert validated Date in DB2? Where ps.setDate() comes into picture?

Note: The date column in DB2 is of type "DATE".

Bye,
Viki.
[ December 20, 2005: Message edited by: Vikrama Sanjeeva ]

[Annie Smith]

1. How to validate Date so that it should satisfy dd-mm-yyyy format?

SimpleDateFormat df = new SimpleDateFormat("dd-MM-yyyy");
df.setLenient(false);    // Strict parsing.
Date validDate = df.parse(dateString);
// dateString comes from the user input
// If the date does not match the format, a ParseException is thrown.

2. How to insert validated Date in DB2? Where ps.setDate() comes into picture?

Read the JDBC tutorial for PreparedStatement.

[Bear Bibeault]

Moved to Java in General (intermediate)

[Vikrama Sanjeeva]

Hi,

1. How to validate Date so that it should satisfy dd-mm-yyyy format?

This is working fine with same code mentioned by Annie. It is validating the required format.

2. How to insert validated Date in DB2? Where ps.setDate() comes into picture?

Here I'm having problems. It goes like this:

After validating the date enter by the user in dd-mm-yyyy format, I convert the string date (validatedDate) into java.sql.Date, let' say it sqlDate. Now, when I'm printing sqlDate it is showing entirely different date.

 
     System.out.println(validatedDate); // gives: 21-12-2005 which is the same as user entered.
 
     System.out.println(sqlDate); // gives: 27-05-28 which is entirely different date.
 
  In DB2 Column of the Date it is showing: May 28,0027
 

Here is the code:

 
java.sql.Date sqlDate = java.sql.Date.valueOf(validatedDate);
ps.setDate(2,sqlDate); // ps is PreparedStatement
 

I cannot guess what is going wrong here in conversion?

Bye,
Viki.

[Jeff Albertson]

The API for java.sql.Date reads:

Converts a string in JDBC date escape format to a Date value.

Parameters:
s - a String object representing a date in in the format "yyyy-mm-dd"

Is your Sstring object representing a date in in the format "yyyy-mm-dd"?

[Balaji Sampath]

IN the above code if we include one more line:
df.format(dateString)
the datefield from the form is formatted to the required format specified.. then continue coding for storing it in db.

[Jeff Albertson]

Originally posted by Balaji Sampath:
IN the above code if we include one more line:
df.format(dateString)
the datefield from the form is formatted to the required format specified.. then continue coding for storing it in db.

Doesn't format take a Date object, not a String?

Consider doing the following to go from "dd-MM-yyyy" to java.util.Date.

SimpleDateFormat df = new SimpleDateFormat("dd-MM-yyyy");
df.setLenient(false);    // Strict parsing.
java.util.Date validDate = df.parse(dateString);
java.sql.Date sqlDate = new java.sql.Date(validDate.getTime());

Are you out of the woods? I'm not sure, because you may have to set the
time zone of your DateFormat's time zone to, say, UTC.