src-main.org.awakefw.sql.jdbc.util.ParametersUtil 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.StatementHolder;

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

    /**
     * Check that the number of parameters is correct in the statement hold
     * @param statementHolder	the statement holder
     * @throws SQLException if the number of parameters is incorrect, with a clean message
     */
    public static void checkParameters(StatementHolder statementHolder)
    throws SQLException
    {
	if (statementHolder == null ) {
	    throw new SQLException(Tag.AWAKE_PRODUCT_FAIL + "statementHolder can not be null");
	}
	
	String sql = statementHolder.getSqlOrder();
	int parameterNumbers = StringUtils.countMatches(sql, "?"); 
	
	if (parameterNumbers == 0) {
	    return;
	}
	
	Map parameterTypes =  statementHolder.getParameterTypes();	
	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);
	    }
	}
	
	
    }
    
}