如何在JPA中使用准备好的语句 [英] How to use prepared statement in JPA

问题描述

我是一个游戏框架应用程序开发人员.我在JPA中使用createNativeQuery方法.在此示例中，我想使用准备好的语句.请有人帮我吗? 这是没有JPA的代码.我需要帮助将其转换为Prepared语句.

I am a play framework application Developer.I am using createNativeQuery method in JPA. In this example i want to use prepared statement. Please anyone help me? Here is the code without JPA. I need help to convert it to Prepared statement.

Query query = JPA.em().createNativeQuery("select count(*) from truck t inner join" +
    "box b where t.truck_id=b.truck_id and t.shipment_upc='" + code + "'");

BigInteger val = (BigInteger)query.getSingleResult();
System.out.println(val);

推荐答案

Query query = JPA.em().createNativeQuery("select count(*) from truck t inner join box b where t.truck_id=b.truck_id and t.shipment_upc=:code");
query.setParameter("code", code);

这篇关于如何在JPA中使用准备好的语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！