http://jdbi.org/: jdbi is designed to provide convenient tabular data access in Java(tm). It uses the Java collections framework for query results, provides a convenient means of externalizing sql statements, and provides named parameter support for any database being used. 
/*
 * Licensed 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.jdbi.v3.core.statement;


Parses the named parameters out of an SQL statement, and returns the ParsedSql containing the JDBC-ready SQL statement, along with the type of parameters used (named or positional), the number, and the parameter name for each position (if applicable). 
/**
 * Parses the named parameters out of an SQL statement, and returns the
 * {@link ParsedSql} containing the JDBC-ready SQL statement, along with the
 * type of parameters used (named or positional), the number, and the parameter
 * name for each position (if applicable).
 */
public interface SqlParser {
    
Parses the given SQL statement, and returns the ParsedSql for the statement. 
Params:
  • sql – The SQL statement to parse
  • ctx – The statement context for the statement being executed
Returns:the parsed SQL representing the SQL statement itself along with
information about the parameters which should be bound (number and names)
/**
     * Parses the given SQL statement, and returns the {@link ParsedSql}
     * for the statement.
     *
     * @param sql The SQL statement to parse
     * @param ctx The statement context for the statement being executed
     * @return the parsed SQL representing the SQL statement itself along with
     * information about the parameters which should be bound (number and names)
     */
    ParsedSql parse(String sql, StatementContext ctx);

    
Convert rawName to a name as recognized by this parser

Params:
  • rawName – the raw name to transform
  • ctx – The statement context for the statement being executed
Returns:a name appropriate for being identified a a named parameter by this parser
/**
     * Convert rawName to a name as recognized by this parser
     *
     * @param rawName the raw name to transform
     * @param ctx The statement context for the statement being executed
     * @return a name appropriate for being identified a a named parameter by this parser
     */
    String nameParameter(String rawName, StatementContext ctx);
}