Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Optional<TrxSuratTugasKeluar> findByBk(final Transaction transaction, final String trxNumber, final Date trxDate) {
- try {
- StringBuilder queryStringBuilder = new StringBuilder();
- queryStringBuilder.append("from TrxSuratTugasKeluar \n");
- queryStringBuilder.append("where \n");
- queryStringBuilder.append("((:transactionId is null and transaction is null) or transaction.id = :transactionId) and ");
- queryStringBuilder.append("((:trxNumber is null and trxNumber is null) or trxNumber = :trxNumber) and ");
- queryStringBuilder.append("((:trxDate is null and trxDate is null) or trxDate = :trxDate)");
- TypedQuery<TrxSuratTugasKeluar> typedQuery = em.createQuery(queryStringBuilder.toString(), TrxSuratTugasKeluar.class);
- typedQuery.setParameter("transactionId", transaction.getId());
- typedQuery.setParameter("trxNumber", trxNumber);
- typedQuery.setParameter("trxDate", trxDate);
- return Optional.ofNullable(typedQuery.getSingleResult());
- } catch (final NoResultException e) {
- return Optional.empty();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment