如何使用 parmetervalue 獲取條件查詢的 SQL 字符串表示形式？我試過這個，但它返回一個沒有參數(shù)值的字符串給我：String QueryString = 'SELECT * FROM CUSTOMERS WHERE lastname = ?'query = entityManager.createNativeQuery(QueryString);query.setParameter(1, "toto");System.out.print(query.unwrap(JpaQuery.class).getDatabaseQuery().getSQLString());但返回“SELECT * FROM CUSTOMERS WHERE lastname = ?” 而不是“SELECT * FROM CUSTOMERS WHERE lastname = 'toto'”
1 回答
Cats萌萌
TA貢獻1805條經(jīng)驗 獲得超9個贊
如果它可以幫助其他人，那么解決方案是：
String QueryString = 'SELECT * FROM CUSTOMERS WHERE lastname = ?';
Query query = entityManager.createNativeQuery(QueryString);
Session session = entityManager.unwrap(JpaEntityManager.class).getActiveSession();
DatabaseQuery databaseQuery = query.unwrap(org.eclipse.persistence.jpa.JpaQuery.class).getDatabaseQuery();
DatabaseRecord recordWithValues= new DatabaseRecord();
query.setParameter(1, "toto");
recordWithValues.add(new DatabaseField(Integer.toString(1)), "toto");
databaseQuery.prepareCall(session, recordWithValues);
String sqlStringWithArgs = databaseQuery.getTranslatedSQLString(session, recordWithValues);
System.out.print(sqlStringWithArgs);
====SELECT * FROM CUSTOMERS WHERE lastname = 'toto'====
添加回答
舉報
0/150
提交
取消