|
楼主 |
发表于 2013-9-22 10:21:40
|
显示全部楼层
jishuang 发表于 2013-9-12 17:18
action的定义发一下
String oracle = " SELECT trunc(B.Nettime) as JZRQ,(A.RKSJ)AS RKSJ,(A.KHMC)AS KHMC,(A.HTBH)AS HTBH,(A.WLMC)AS WLMC,(A.GLHTH)AS GLHTH,(A.ZWCM)AS ZWCM," +
"(A.DGL)AS DGL,(A.RKDJ)AS RKDJ,(A.RKJE)AS RKJE,(A.STSL)AS STSL," +
"(A.DGL-A.STSL)AS JCSL,(B.CBDJ)AS CBDJ,(A.STSL*B.CBDJ)AS CKJE,(A.XHG)AS XHG FROM GKRKB A,interface_qdport B " +
"WHERE A.HTNO=B.HTH AND TRUNC(B.NETTIME) BETWEEN TO_DATE('"+ StartTime +"','YYYY-MM-DD') AND TO_DATE('"+ EndTime +"','YYYY-MM-DD')" +
"group by trunc(B.NETTIME),A.RKSJ,A.KHMC,A.HTBH,A.WLMC," +
"A.GLHTH,A.ZWCM,A.DGL,A.RKDJ,A.RKJE,A.STSL,B.CBDJ,A.XHG order by trunc(B.NETTIME) desc " ;
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(DatabaseProduct.ORACLE.name(), oracle);
return SQL.select(sqlMap, null, "/GKWZGL/GKKGL/data");
这是我的action,查询时界面上不显示,请帮忙远程下
|
|