Hi Friend,

Try the following code:

import java.sql.*;
import java.text.*;
import javax.swing.*;

public class GetDateFromDatabase {
public static void main(String args[]) {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";;

String GET_RECORD = "select * from d where id='1'";
ResultSet rs = null;
Connection conn = null;
Statement stmt = null;
try {
Class.forName(driver);
conn=DriverManager.getConnection(url, "root", "root");

stmt = conn.createStatement();
rs = stmt.executeQuery(GET_RECORD);
String d="";
while (rs.next()) {
d = rs.getString("myDate");
}
int y=Integer.parseInt(d.substring(0,4))-1900;
int m=Integer.parseInt(d.substring(5,7))-1;
int da=Integer.parseInt(d.substring(8,10));
java.util.Date date=new java.util.Date(y,m,da);
SimpleDateFormat formatter = new SimpleDateFormat("MM/dd/yyyy");
System.out.println("Date : " + formatter.format(date));
JFrame f=new JFrame();
JPanel p=new JPanel();
p.add(new JLabel("Date is: "));
p.add(new JTextField(formatter.format(date)));
f.add(p);
f.setVisible(true);
f.pack();
rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}

Thanks