How can I see my record?

[Elahe Shafie]

Hi Friends,
In my program when FixedDate is null I mean '00-00-0000' on database it will catch exceptions thrown since there is nothing to reformat and I try to put if condition to solve this problem but in toString() line it catch exceptions thrown again how can I solve this issiue and can see my record even if fixedDate is null?
Many thanks,
Elahe

if (rs.next()) {
C_BugList xobj=new C_BugList();
java.sql.Date d_sql_fdate= rs.getDate("fixedDate");
if (d_sql_fdate == null) {
strformatted_fix =  d_sql_fdate.toString(); 
xobj.setFixedDate(strformatted_fix);
}else{
java.util.Date d_util_fdate = new java.util.Date(d_sql_fdate.getTime());
SimpleDateFormat sdff = new SimpleDateFormat("M/d/yyyy");
strformatted_fix = sdff.format(d_util_fdate);
xobj.setFixedDate(strformatted_fix);
}

[Elahe Shafie]

Hi friends I solved it.Here is my code:

java.sql.Date d_sql_fdate= rs.getDate("fixedDate");
if (d_sql_fdate == null) {
xobj.setFixedDate("00/00/0000");
}else{
// xobj.setFixedDate(rs.getDate("fixedDate"));
java.util.Date d_util_fdate = new java.util.Date(d_sql_fdate.getTime());
SimpleDateFormat sdff = new SimpleDateFormat("M/d/yyyy");
strformatted_fix = sdff.format(d_util_fdate);
xobj.setFixedDate(strformatted_fix);
 }
...

[Elahe Shafie]

If you have better idea please let me know...
Thanks,
Elahe