src-main.org.awakefw.sql.jdbc.util.ParametersUtilCallable Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of awake-sql Show documentation
Awake SQL is an open source framework that allows remote and secure JDBC access through HTTP.
There is a newer version: 2.0.2
/*
 * This file is part of Awake SQL. 
 * Awake SQL: Remote JDBC access over HTTP.                                    
 * Copyright (C) 2013,  KawanSoft SAS
 * (http://www.kawansoft.com). All rights reserved.                    
 *                                                                         
 * Awake SQL is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.         
 *              
 * Awake SQL 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 General Public License
 * along with this program; if not, see .
 *
 * If you develop commercial activities using Awake SQL, you must: 
 * a) disclose and distribute all source code of your own product,
 * b) license your own product under the GNU General Public License.
 * 
 * You can be released from the requirements of the license by
 * purchasing a commercial license. Buying such a license will allow you 
 * to ship Awake SQL with your closed source products without disclosing 
 * the source code.
 *
 * For more information, please contact KawanSoft SAS at this
 * address: [email protected]
 * 
 * Any modifications to this file must keep this entire header
 * intact.
 */
package org.awakefw.sql.jdbc.util;

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

import org.apache.commons.lang3.StringUtils;
import org.awakefw.file.util.Tag;
import org.awakefw.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.AWAKE_PRODUCT_FAIL + "statementHolder can not be null");
	}
	
	String sql = callableStatementHolder.getSqlOrder();
	Map 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 parameterTypes) throws SQLException {
	int parameterNumbers = StringUtils.countMatches(sql, "?"); 
	
	if (parameterNumbers == 0) {
	    return;
	}
	
	Set 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);
	    }
	}
    }
}