|
Apache CXF example source code file (SearchUtils.java)
The Apache CXF SearchUtils.java source code/** * Licensed to the Apache Software Foundation (ASF) under one * or more contributor license agreements. See the NOTICE file * distributed with this work for additional information * regarding copyright ownership. The ASF licenses this file * to you under the Apache License, Version 2.0 (the * "License"); you may not use this file except in compliance * with the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. */ package org.apache.cxf.jaxrs.ext.search; public final class SearchUtils { private SearchUtils() { } public static void startSqlQuery(StringBuilder sb, String table, String... columns) { sb.append("SELECT "); if (columns.length > 0) { for (int i = 0; i < columns.length; i++) { sb.append(columns[i]); if (i + 1 < columns.length) { sb.append(","); } } } else { sb.append("*"); } sb.append(" FROM ").append(table).append(" WHERE "); } public static String conditionTypeToSqlOperator(ConditionType ct, String value) { // TODO : if we have the same column involved, ex a >= 123 and a <=244 then // we may try to use IN or BETWEEN, depending on the values String op; switch (ct) { case EQUALS: op = value.contains("%") ? "LIKE" : "="; break; case NOT_EQUALS: op = value.contains("%") ? "NOT LIKE" : "<>"; break; case GREATER_THAN: op = ">"; break; case GREATER_OR_EQUALS: op = ">="; break; case LESS_THAN: op = "<"; break; case LESS_OR_EQUALS: op = "<="; break; default: String msg = String.format("Condition type %s is not supported", ct.name()); throw new RuntimeException(msg); } return op; } } Other Apache CXF examples (source code examples)Here is a short list of links related to this Apache CXF SearchUtils.java source code file: |
... this post is sponsored by my books ... | |
#1 New Release! |
FP Best Seller |
Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.
A percentage of advertising revenue from
pages under the /java/jwarehouse
URI on this website is
paid back to open source projects.