查了一下是SQL中有东西被当做字符串处理了,但找不出哪里问题
大神帮帮我吧
拼接SQL异常,报错No parameters defined during prepareCall
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
3条回答
- java虐我千万遍 2016-03-28 02:21关注
String sql = "SELECT a.*, (CASE WHEN CEIL(IFNULL(b.purchasenum,0)) = 0 " +
"THEN 1 ELSE CEIL(IFNULL(b.purchasenum,0)) END) AS purchasenum FROM " +
"T_AMZFBAPRODUCT a INNER JOIN " +
"(SELECT a.sku,(a.prosnum - IFNULL(b.ordernum,0) - IFNULL(c.deliverynum,0)) AS purchasenum FROM " +
"(SELECT sku, SUM( onedaysn * (15 - savenumendurday) ) AS prosnum FROM T_AMZFBAPRODUCT " +
"WHERE savenumendurday <= 7 GROUP BY sku) a LEFT JOIN " +
"(SELECT productid,SUM(ordernum) AS ordernum FROM T_AMZSMARTPURCHASELOG" +
" WHERE openflag = '1' AND STATUS IN ('1','2','3') GROUP BY productid) b ON a.sku = b.productid LEFT JOIN" +
" (SELECT productid, SUM(deliverynum) AS deliverynum FROM T_AMZTRANSPORTGRPINFO" +
" WHERE grpid IN (SELECT id FROM T_AMZTRANSPORTGROUP WHERE STATUS IN ('新创建','包货中','已发货'))" +
" GROUP BY productid) c ON a.sku = c.productid) b ON a.sku = b.sku";解决 无用评论 打赏 举报
悬赏问题
- ¥15 关于#stm32#的问题:CANOpen的PDO同步传输问题
- ¥20 yolov5自定义Prune报错,如何解决?
- ¥15 电磁场的matlab仿真
- ¥15 mars2d在vue3中的引入问题
- ¥50 h5唤醒支付宝并跳转至向小荷包转账界面
- ¥15 算法题:数的划分,用记忆化DFS做WA求调
- ¥15 chatglm-6b应用到django项目中,模型加载失败
- ¥15 CreateBitmapFromWicBitmap内存释放问题。
- ¥30 win c++ socket
- ¥15 C# datagridview 栏位进度