protected EntityManager manager;
...
String ejbqlDelete = "delete from ClientTicket p where " +
  "p.closed = :paramClosed and " +
  "p.department = :paramDepartment and " +
  "p.ticketUserID = :paramTicketUserID and " +
  "p.ticketName = :paramTicketName";
int deletedEntities = manager.createQuery(ejbqlDelete).
  setParameter("paramClosed", Boolean.TRUE).
  setParameter( "paramDepartment", adminid).
  setParameter( "paramTicketUserID", userID ).
  setParameter( "paramTicketName", delTicket ).
  executeUpdate();Monday, May 11, 2009
Writing a Parameterized SQL Query in EJB 3.0
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment