A challenge while formatting date value from the database

Dear All,
I'm fetching a set of data from the database which includes some date values.
This is my code:

import java.sql.*;
import java.sql.Date;
import java.text.*;
public class Testmysql {
public static String url="jdbc:mysql://localhost/mysql";
public static String user="root";
public static String passwd="root";
 
public static void main (String[] args) {
Testmysql my=new Testmysql();
Connection conn=null;
ResultSet rs=null;
Statement stmt=null;
SimpleDateFormat df1 = new SimpleDateFormat("dd/MM/yyyy hh:mm:ss a");
 
try {
Class.forName ("com.mysql.jdbc.Driver").newInstance();
conn=DriverManager.getConnection(url,user,passwd);
}
 
catch (ClassNotFoundException e) {
System.out.println ("Driver loading error!");
}
 
catch (Exception e) {
System.out.println (e.getMessage());
}
 
try {
stmt=conn.createStatement(); //<==here goes out the error.
if (stmt.execute("select * from employee"))
rs=stmt.getResultSet();
}
catch (SQLException e) {
System.out.println("Error when querying MySQL!");
}
try {
while (rs.next()) {
System.out.print(rs.getString("employeename"));
System.out.print(" : "+rs.getInt("empno"));
System.out.println(" : "+rs.getDate("doj"));
}
}
catch (Exception e) {
System.out.println (e.getMessage());
}
}
}

When we run:

Now I want to format the date in dd/MM/yyyy format for which I use SimpleDateFormat class

My code now:

import java.sql.*;
import java.sql.Date;
import java.text.*;
public class Testmysql {
public static String url="jdbc:mysql://localhost/mysql";
public static String user="root";
public static String passwd="root";
 
public static void main (String[] args) {
Testmysql my=new Testmysql();
Connection conn=null;
ResultSet rs=null;
Statement stmt=null;
[B]SimpleDateFormat df1 = new SimpleDateFormat("dd/MM/yyyy");
[/B]
try {
Class.forName ("com.mysql.jdbc.Driver").newInstance();
conn=DriverManager.getConnection(url,user,passwd);
}
 
catch (ClassNotFoundException e) {
System.out.println ("Driver loading error!");
}
 
catch (Exception e) {
System.out.println (e.getMessage());
}
 
try {
stmt=conn.createStatement(); //<==here goes out the error.
if (stmt.execute("select * from employee"))
rs=stmt.getResultSet();
}
catch (SQLException e) {
System.out.println("Error when querying MySQL!");
}
try {
while (rs.next()) {
System.out.print(rs.getString("employeename"));
System.out.print(" : "+rs.getInt("empno"));
[B]java.sql.Date d=rs.getDate("doj");
System.out.println(" : "+df1.format(d));[/B]
//System.out.println(" : "+rs.getDate("doj"));
}
}
catch (Exception e) {
System.out.println (e.getMessage());
}
}
}

But now the output is:

It's not displaying other datas, once it encounters the first null value in date.
But when we don't use formatting, these null values are also getting displayed.
Now, my requirement is
1) I want to display the date value in a formatted manner
2) If atall some null date values are there it should be presented as null.
I want the output to be in this format.

sai : 11850 : 26/09/2006
azees : 11851 : null
jothish : 11856 : null
pradap : 11859 : 12/12/2006

How can i achieve this?
Regards.

The challenge is won now , by including a simple if statement after fetching the date value & checking for null value.
Note the whole output is formatted using String.format method which is highlighted.
Code:

import java.sql.*;
import java.sql.Date;
import java.text.*;
public class Testmysql {
public static String url="jdbc:mysql://localhost/mysql";
public static String user="root";
public static String passwd="root";
 
public static void main (String[] args) {
 
Testmysql my=new Testmysql();
Connection conn=null;
ResultSet rs=null;
Statement stmt=null;
[B]SimpleDateFormat df1 = new SimpleDateFormat("dd/MM/yyyy");
String forDate=null;[/B]
 
try {
Class.forName ("com.mysql.jdbc.Driver").newInstance();
conn=DriverManager.getConnection(url,user,passwd);
}
 
catch (ClassNotFoundException e) {
System.out.println ("Driver loading error!");
}
 
catch (Exception e) {
System.out.println (e.getMessage());
}
 
try {
stmt=conn.createStatement(); //<==here goes out the error.
if (stmt.execute("select * from employee"))
rs=stmt.getResultSet();
}
catch (SQLException e) {
System.out.println("Error when querying MySQL!");
}
try {
while (rs.next()) {
[B]String employeename=String.format("%8s",rs.getString("employeename"));[/B]
System.out.print(employeename);
System.out.print(" : "+rs.getInt("empno"));
java.sql.Date date=rs.getDate("doj");
[B]if(date==null)
forDate=null;
else
forDate=df1.format(date);[/B]
System.out.println(" : "+forDate);
}
}
catch (Exception e) {
System.out.println (e.getMessage());
}
}
}

Output:

Regards.