中国开发网: 论坛: 程序员情感CBD: 贴子 313627
nostalgic
果然牛X,不懂也指出来了.
String QuerySQL = " select (TJ.ayfz-JB.dykhsx)/JB.dykhsx,(TJ.aygz-JB.dykhxx)/JB.dykhxx ,"
+"(TJ.byfz-JB.dykhsx)/JB.dykhsx,(TJ.bygz-JB.dykhxx)/JB.dykhxx,"
+"(TJ.cyfz-JB.dykhsx)/JB.dykhsx,(TJ.cygz-JB.dykhxx)/JB.dykhxx"
+" from Customer YH, TerminalCapital ZC, VoltageUp2gradeRateDetail TJ,BasicVoltageLevel JB"
+" where YH.yhid=ZC.yhid and"
+" ZC.zdljdz=TJ.zdljdz and"
+" JB.jzz=YH.gddy and"
+" trunc(TJ.rq,'mm')=to_date('"+monthValue.getMonth()+"','yyyy-mm')"
+" and YH.yhid='"
+ userId
+ "'";

相关信息:


欢迎光临本社区,您还没有登录,不能发贴子。请在 这里登录