org.kawanfw.sql.jdbc.util.ParametersUtilCallable.java Source code

Introduction

Here is the source code for org.kawanfw.sql.jdbc.util.ParametersUtilCallable.java

Source

/*
 * This file is part of AceQL. 
 * AceQL: Remote JDBC access over HTTP.                                     
 * Copyright (C) 2015,  KawanSoft SAS
 * (http://www.kawansoft.com). All rights reserved.                                
 *                                                                               
 * AceQL is free software; you can redistribute it and/or                 
 * modify it under the terms of the GNU Lesser General Public                    
 * License as published by the Free Software Foundation; either                  
 * version 2.1 of the License, or (at your option) any later version.            
 *                                                                               
 * AceQL is distributed in the hope that it will be useful,               
 * but WITHOUT ANY WARRANTY; without even the implied warranty of                
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU             
 * Lesser General Public License for more details.                               
 *                                                                               
 * You should have received a copy of the GNU Lesser General Public              
 * License along with this library; if not, write to the Free Software           
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  
 * 02110-1301  USA
 *
 * Any modifications to this file must keep this entire header
 * intact.
 */
package org.kawanfw.sql.jdbc.util;

import java.sql.SQLException;
import java.util.Map;
import java.util.Set;

import org.apache.commons.lang3.StringUtils;
import org.kawanfw.commons.util.Tag;
import org.kawanfw.sql.json.no_obfuscation.CallableStatementHolder;

/**
 * 
 * Utilities for prepared statmeent parameters
 * 
 * @author Nicolas de Pomereu
 *
 */
public class ParametersUtilCallable {

    /**
     * Check that the number of parameters is correct in the statement hold
     * 
     * @param callableStatementHolder
     *            the callable statement holder
     * @throws SQLException
     *             if the number of parameters is incorrect, with a clean
     *             message
     */
    public static void checkParameters(CallableStatementHolder callableStatementHolder) throws SQLException {
        if (callableStatementHolder == null) {
            throw new SQLException(Tag.PRODUCT_PRODUCT_FAIL + "statementHolder can not be null");
        }

        String sql = callableStatementHolder.getSqlOrder();
        Map<Integer, Integer> parameterTypes = callableStatementHolder.getParameterTypes();

        checkParameters(sql, parameterTypes);

    }

    /**
     * Check that the number of parameters is correct in the sql order
     * 
     * @param sql
     *            the sql order
     * @param parameterTypes
     *            the parameters types
     * @throws SQLException
     *             if the number of parameters is incorrect, with a clean
     *             message
     */
    private static void checkParameters(String sql, Map<Integer, Integer> parameterTypes) throws SQLException {
        int parameterNumbers = StringUtils.countMatches(sql, "?");

        if (parameterNumbers == 0) {
            return;
        }

        Set<Integer> set = parameterTypes.keySet();

        if (set.size() > parameterNumbers) {
            // Nothing to do for this, already done in StatementHolder
        }

        for (int i = 1; i < parameterNumbers + 1; i++) {

            if (!set.contains(i)) {
                throw new SQLException("No value specified for parameter " + i);
            }
        }
    }
}