hibernate SQLQuery 获取不带参数的sqlSQLQuery sqlQuery = session
.createSQLQuery("SELECT DISTINCT C.MODEL_SERIAL||'--'||C.MODEL_NAME,C.MODEL_NAME FROM C_MODEL_DESC_V C LEFT JOIN R_MO_BASE_V R "
+ " ON C.MODEL_NAME=R.MODEL_NAME WHERE R.CUST_CODE=:customerCode AND C.SCHEMA_NAME=:schemaName and route_code>0 ORDER BY C.MODEL_NAME");
sqlQuery.setParameter("customerCode", customerCode);
sqlQuery.setParameter("schemaName", schemaName);
怎么獲取最終不帶參數sql?
.createSQLQuery("SELECT DISTINCT C.MODEL_SERIAL||'--'||C.MODEL_NAME,C.MODEL_NAME FROM C_MODEL_DESC_V C LEFT JOIN R_MO_BASE_V R "
+ " ON C.MODEL_NAME=R.MODEL_NAME WHERE R.CUST_CODE=:customerCode AND C.SCHEMA_NAME=:schemaName and route_code>0 ORDER BY C.MODEL_NAME");
sqlQuery.setParameter("customerCode", customerCode);
sqlQuery.setParameter("schemaName", schemaName);
怎么獲取最終不帶參數sql?
所以,你要想拿到最终的SQL,必须到数据库里,打开常规日志,让它输出所有的SQL语句。
但是我要在java里實現。因為我用最終sql放到session 里,方便用來導報表。
然后循環replace的帶參數sql和LaZY_GUY 的想法一樣。