Hql +=" AND compAndClientPolicy.executeBegin between "+ kaiShiRiQi+" and "+ jieShuRiQi+" "
正确做法是下面的,上面的会报错(操作数类型冲突: date 与 int 不兼容)
大家注意上下的区别:划下划线参数(传进来的参数),要加单引号,不然的话在数据库处理的时候会把你当int给处理掉的
Hql +=" AND compAndClientPolicy.executeBegin between '"+ kaiShiRiQi+"' and '"+ jieShuRiQi+"' "
|