public BonusTO[] searchPageRecord(String txtMbrCode, String txtDateFrom, String txtDateTo) { String searchQuery = ConstantValue.EMPTY_STRING; ArrayList<String> arrParameter = new ArrayList<String>(); if (txtMbrCode != null && txtMbrCode.length() > 0) { searchQuery += " where b.code = ?"; arrParameter.add(txtMbrCode); } if ((txtDateFrom != null && txtDateTo != null) && (txtDateFrom.length() > 0 && txtDateTo.length() > 0)) { if (searchQuery.length() > 0) { searchQuery += " and a.trx_date between ? and ?"; } else { searchQuery += " where a.trx_date between ? and ?"; } arrParameter.add(txtDateFrom); arrParameter.add(txtDateTo); } BonusDAO bonusDAO = new BonusDAO(); String[] parameterList = (String[]) arrParameter.toArray(new String[0]); return bonusDAO.searchBonus(searchQuery, parameterList); }