拼接SQL异常，报错No parameters defined during prepareCall

Question

查了一下是SQL中有东西被当做字符串处理了，但找不出哪里问题
大神帮帮我吧

Answer 1

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";