How to fetch date from database in JDateChooser field

[Fahim Khan]

Hi,
I have created simple form in swing. Which uses JCalendar.

I am trying to view the data from database on the basis of id. All other field are listing fine except date field. Which is JDateChooser component.

I am using below code to set the field.

int id = Integer.parseInt(tfsid.getText());
            String sql = "select * from student where StudentID=?";
            PreparedStatement ps = conn.prepareStatement(sql);
            ps.setInt(1, id);
            ResultSet rs = ps.executeQuery();
            if(rs.next())
            {
                tffname.setText(rs.getString("Name"));
                tflname.setText(rs.getString("FName"));
                taadd.setText(rs.getString("Address"));
                
                tfdob.setDate(rs.getDate("DOB"));  /// getting exception from here
                branchcombo.setSelectedItem(rs.getString("Branch"));
                
           }

Thanks in advance

[Kemal Sokolovic]

Hello and welcome to the Ranch!

Can we see the exception message you are getting? I guess tfdob is JDateChooser component?

[Fahim Khan]

Yes, it is JDateChooser componet.

I am getting SQLException from line tfdob.setDate(rs.getDate("DOB"));

I think I got the solution I have defined DOB as String in database that may causing exception