Wednesday, 7 August 2013

I want to pass parameter on jpa query generated by netbeans

I want to pass parameter on jpa query generated by netbeans

Following is the code generated by netbeans while binding jtable with
netbeans gui editor.
serverDetailsQuery = java.beans.Beans.isDesignTime() ? null :
F1SoftSMSCPUEntityManager.createQuery("SELECT s FROM ServerDetails s ");
And I changed query using by editing
SELECT s FROM ServerDetails s order by id desc
this is working fine. Now I want to pass parameter on query to filter
record by ShortCode like :
SELECT s FROM ServerDetails s where s.shortCode : filterShortCode order by
id desc
Short code is text field and there is a button which will filter record if
user types shortCode and clicks the button.
Thanks and willing to get response as soon as possible from experts.

No comments:

Post a Comment