jDateChooser casting MsSql date

Question

I have problem with capturing user date input from jDateChooser to insert into mssql table. There similar problems in stackoverflow. It was not solving my problem.

Here is code that I capture user date entry

obj.setStartDate(jDateChooser3.getDate());
obj.setEndDate( jDateChooser4.getDate());

DatabasePropeties class and SaveNewProject Method

        import java.math.BigDecimal;
        import java.sql.*;
        import java.util.Date;

        Date StartDate;
        Date EndDate;    

        public boolean SaveNewProject()                    
        {
            boolean resp = false;            
            paTable = connector();

            try {        
                String SPsql = "EXEC AddNewProject ? ,? ,? ,? ";
                PreparedStatement cmd = cnuser.prepareStatement(SPsql);
                cmd.setString(1, ProjectName);
                cmd.setDate(2, StartDate);
                cmd.setDate(3, EndDate);
                cmd.setString(4, ProjectCode);
                if (!cmd.execute()) {
                    resp = true;
                }
                cmd.close();
                paTable.close();        
            } catch (Exception ex) {        
                System.out.println("Error" + ex.getMessage());        
            }        
            return resp;            
        }

Setters and Getters

 public Date getStartDate() {
    return StartDate;
       }

   public void setStartDate(Date StartDate) {
    this.StartDate = StartDate;
    }

   public Date getEndDate() {
    return EndDate;
    }

    public void setEndDate(Date EndDate) {
    this.EndDate = EndDate;
    }

You should be using java.sql.Date when trying to set the values in the PreparedStatement, not java.util.Date... — MadProgrammer, Apr 22 '14 at 08:46
Not really, cause the date picker will work with java.util.Date, but when using setDate, it expects a java.sql.Date, so you'll need to convert the java.util.Date over... — MadProgrammer, Apr 22 '14 at 08:50
I think you'd need `new java.sql.Date(EndDate.getTime())`, but that's the idea... — MadProgrammer, Apr 22 '14 at 08:57
I think problem is also with date format , the casting error is gone my date format is dd/MM/yyyy which I set using propeties of jDateChooser — user3498019, Apr 22 '14 at 10:13
ok just changed the date to string like this and push database as string SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy"); sd = dateFormat.format(jDateChooser3.getDate()); ed = dateFormat.format(jDateChooser4.getDate()); — user3498019, Apr 22 '14 at 13:31

jDateChooser casting MsSql date

0 Answers0