SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
String str1=sdf.format(this.kDDatePicker1.getValue());
GregorianCalendar calendar = new GregorianCalendar();
calendar.setTime((Date) this.kDDatePicker2.getValue() );
calendar.add(calendar.DATE, 1);
Date date = calendar.getTime();
String str2=sdf.format(date);
String sql = "/*dialect*/select distinct CFCONTRACTNO from CT_DUC_CarcassAcceptanceReport where fbizDate between {ts'"+str1+"'} and {ts'"+str2+"'} ";