我试图从我之前使用datepicker存储在其中的数据库中获取日期,但我无法这样做 . 我已经尝试使用java.sql.date但它返回null并且没有在datepicker上设置
public void usearch(ActionEvent event)
{
ResultSet resultSet= null;
resultSet=dbcon.dbcon("Select * from Employees where employee_id='"+ upempid.getText() +"'");
try {
if(resultSet.next())
{
upempname.setText(resultSet.getString("Employee_name"));
upempaddress.setText(resultSet.getString("Address"));
upempfname.setText(resultSet.getString("father_name"));
upempage.setText(resultSet.getString("Age"));
upempcnic.setText(resultSet.getString("CNIC"));
upempemail.setText(resultSet.getString("Email"));
java.sql.Date date= resultSet.getDate("JOINING_DATE");
System.out.println(date);
// upempjoining.setValue(date.toLocalDate());
upempphone.setText(resultSet.getString("phone_number"));
upemptype.setText(resultSet.getString("employee_type"));
uptransportid.setText(resultSet.getString("transport_id"));
}
} catch (SQLException e) {
e.printStackTrace();
}
}