RubiUtils

public boolean isProductPermitted(String acctNo) {
		try (Statement stmt = MobileControl.handles[connIndex].createStatement()) {
			StringBuilder builder = new StringBuilder("select b.prod_cd from ").append(MainClass.CORE_SCHEMA)
					.append(".account a, ").append(MainClass.CORE_SCHEMA)
					.append(".product b where a.prod_id = b.prod_id and trim(a.acct_no) = '").append(acctNo)
					.append("' and rec_st = 'A' and b.prod_cd in (");

			for (String prod : MainClass.ALLOWED_PRODUCTS_CODES) {
				builder.append("'").append(prod).append("',");
			}
			try (ResultSet rset = stmt.executeQuery(builder.substring(0, builder.lastIndexOf(",")) + ")")) {
				return rset.next();
			}

		} catch (SQLException e) {
			RubiLog.getLogger().error(e);
		}
		return false;
	}