Hibernate datetime 与 JAVA date 不兼容的解决方法

public String hqlScope(String start, String end) {// 设置hql适用范围
StringBuffer hql = new StringBuffer(",COUNT(ca) from Case ca");
hql.append(" WHERE ca.deleteflag=0");
if (start != null && end != null) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
try {
Date date1 = sdf.parse(start);
Date date2 = sdf.parse(end);
java.sql.Date d1 = new java.sql.Date(date1.getTime());//转换成sql date
java.sql.Date d2 = new java.sql.Date(date2.getTime());//转换成sql date
String b = " AND ca.time BETWEEN '" + d1 + "' AND '" + d2 + "'";
return hql.append(b).toString();
} catch (ParseException e) {
System.out.println("时间转换异常！！！");
}


}
return hql.toString();
}