ronaldkwandy

Untitled

Sep 5th, 2019
266
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.08 KB | None | 0 0
  1.   public Optional<TrxSuratTugasKeluar> findByBk(final Transaction transaction, final String trxNumber, final Date trxDate) {
  2.     try {
  3.       StringBuilder queryStringBuilder = new StringBuilder();
  4.       queryStringBuilder.append("from TrxSuratTugasKeluar \n");
  5.       queryStringBuilder.append("where \n");
  6.       queryStringBuilder.append("((:transactionId is null and transaction is null) or transaction.id = :transactionId) and ");
  7.       queryStringBuilder.append("((:trxNumber is null and trxNumber is null) or trxNumber = :trxNumber) and ");
  8.       queryStringBuilder.append("((:trxDate is null and trxDate is null) or trxDate = :trxDate)");
  9.  
  10.       TypedQuery<TrxSuratTugasKeluar> typedQuery = em.createQuery(queryStringBuilder.toString(), TrxSuratTugasKeluar.class);
  11.       typedQuery.setParameter("transactionId", transaction.getId());
  12.       typedQuery.setParameter("trxNumber", trxNumber);
  13.       typedQuery.setParameter("trxDate", trxDate);
  14.  
  15.       return Optional.ofNullable(typedQuery.getSingleResult());
  16.     } catch (final NoResultException e) {
  17.       return Optional.empty();
  18.     }
  19. }
Advertisement
Add Comment
Please, Sign In to add comment