creating custom query with properties

[mrserii]

hellow everybody  [Exclamation]  [Exclamation]  [Exclamation]



i start to work with nb few days ago and there is something i cant do:



in SWING app i have query "select s from shipping s"



i want to add binded property from text field named "weight" (something like "select * from shipping where weight = $weight" in PHP...).



after all i want bing single result to text field.





tnx!

[michael-487]

Hello,

Seems like you're doing a JPQL query rather than SQL - is this what you try to do?

Anyway, for SQL look in the PreparedStatement class:
   PreparedStatement pstmt = con.prepareStatement("UPDATE EMPLOYEES
                                     SET SALARY = ? WHERE ID = ?");
   pstmt.setBigDecimal(1, 153833.00)
   pstmt.setInt(2, 110592)

In JPA, you can habe named paramenters:
  Query q = em.createQuery( "SELECT s FROM Sample s WHERE s.something=:value" );
  q.setParameter( "value", valueObj )
  ...


HTH
Michael

-----Original Message-----
From: mrserii [mailto:mrserii@...]
Sent: Tuesday, July 07, 2009 11:31 PM
To: nbj2ee@...
Subject: [nbj2ee] creating custom query with properties


hellow everybody  [Exclamation]  [Exclamation]  [Exclamation]



i start to work with nb few days ago and there is something i cant do:



in SWING app i have query "select s from shipping s"



i want to add binded property from text field named "weight" (something like "select * from shipping where weight = $weight" in PHP...).



after all i want bing single result to text field.





tnx!

[mrserii]

can someone link me open source project that using database ? (nb project)



 :P  :P  :P

[Melongo Annabel]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hopefully this helps: http://www.netbeans.org/kb/docs/web/jsf-jpa-crud-wizard.html

---

From: mrserii <mrserii@...>
To: nbj2ee@...
Sent: Wednesday, July 8, 2009 3:56:58 PM
Subject: [nbj2ee] creating custom query with properties

can someone link me open source project that using database ? (nb project)



:P  :P  :P