sql="select e.*,p.name piername, b.name equipname from op_equipdamage e \n" +
"left outer join Data_pier p on e.pierid = p.id \n" +
"left outer join data_equip b on b.id=e.equiptypeid \n"+
"where damagetime>to_date('"+fd+"','yyyy-mm-dd') and damagetime<to_date('"+ld+"','yyyy-mm-dd') \n"+
"and r_dept_id="+deptid+" \n"+
"and ( (status in (1,2,3,7) and sysdate>r_adjust_limit_time ) or (status in(4,5,6,8,9) and repairtime>r_adjust_limit_time) )";
}拿这个SQL语句为例, 我如果把r_adjust_limit_time 的值用java语句改了,而数据库里的值没改,这SQL该怎么改啊?会的请多多指教,我不会吝啬滴!谢谢!!
"left outer join Data_pier p on e.pierid = p.id \n" +
"left outer join data_equip b on b.id=e.equiptypeid \n"+
"where damagetime>to_date('"+fd+"','yyyy-mm-dd') and damagetime<to_date('"+ld+"','yyyy-mm-dd') \n"+
"and r_dept_id="+deptid+" \n"+
"and ( (status in (1,2,3,7) and sysdate>r_adjust_limit_time ) or (status in(4,5,6,8,9) and repairtime>r_adjust_limit_time) )";
}拿这个SQL语句为例, 我如果把r_adjust_limit_time 的值用java语句改了,而数据库里的值没改,这SQL该怎么改啊?会的请多多指教,我不会吝啬滴!谢谢!!
有人明白不,楼下的请回答
"left outer join Data_pier p on e.pierid = p.id \n" +
"left outer join data_equip b on b.id=e.equiptypeid \n"+
"where damagetime>to_date('"+fd+"','yyyy-mm-dd') and damagetime<to_date('"+ld+"','yyyy-mm-dd') \n"+
"and r_dept_id="+deptid+" \n"+
"and ( (status in (1,2,3,7) and sysdate>(case when r_adjust_limit_time>'||java的值||' then r_adjust_limit_time else '||java的值||' end;) )
or (status in(4,5,6,8,9) and repairtime>(case when r_adjust_limit_time>'||java的值||' then r_adjust_limit_time else '||java的值||' end;)) )";