Changes between Version 17 and Version 18 of v6/pgsummary

Timestamp:

05/28/2012 09:23:33 AM (14 years ago)

Author:

chenchongqi

Comment:

--

v6/pgsummary

@@ -154 +154 @@
 }}}
 
+* createNativeQuery sql中参数对应的类型和传入的类型必须一致：
+{{{
+String stmt = "select a.* from v_ent_product a, ent_company b " + " where a.user_id=b.id " + " and a.product_id=?1"
+        + " and a.sell_status=" + CompanyProduct.SELLER_STATUS_UP + " and a.status<="
+        + CompanyProduct.CONTENT_STATUS_NORMAL + " and b.status>=" + Company.STATUS_NO_AUDIT + " and b.vip_rank>="
+        + Company.VIP_RANK_FREE + " and b.id IN(" + inStr.toString() + ") ";
+...
+query.setParameter( i + 2, Integer.parseInt(companyIds[i]) );//Oracle 版本的这里不需要转换
+}}}
+
 == 导数据 ==
 * 字符长度超长