1、 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) )";
2、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(4,5,6,8,9) and REPAIRTIME>R_LIMIT_DATETIME and REPAIRTIME<=R_ADJUST_LIMIT_TIME) )";
在这个语句中我用java 语言改变了r_adjust_limit_time和r_limit_datetime的大小,但数据库里的数据没改变,那这两条语句该怎么改啊?
"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) )";
2、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(4,5,6,8,9) and REPAIRTIME>R_LIMIT_DATETIME and REPAIRTIME<=R_ADJUST_LIMIT_TIME) )";
在这个语句中我用java 语言改变了r_adjust_limit_time和r_limit_datetime的大小,但数据库里的数据没改变,那这两条语句该怎么改啊?
解决方案 »
- 为什么在servlet中修改了javabean中的属性值,使用jsp没有显示出修改的值
- 返回的HTML有乱码
- 急寻《Java for Flash动态网站开发手札》光盘源码
- 下拉框Option的value值能否用函数
- 加班!!
- 下列异常已记录 java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
- JBuilder 9 初次配置需要如何设置
- 本地可以在浏览器“ftp://ip地址”访问一些文件,请问如何用JAVA访问到这些文件呢?(100分,狂刷新等)
- 求救:在jsp中如何实现想点击某个按钮自动生成数据库和一些html文件和jsp文件??
- 这个签到功能的方法应该在哪里加锁?
- 很奇怪的现象~~关于java类修改……高手请进!!很诡异!
- 怎样获取div相对页面左上角的位置?????????????????
现在我把r_adjust_limit_time和r_limit_datetime在jsp里面改了(数据库里没改)这sql语句要怎么改呀?