JavaNamedParameterUtil.java

/*******************************************************************************
 * Copyright (c) 2015 hangum.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the GNU Lesser Public License v2.1
 * which accompanies this distribution, and is available at
 * http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
 * 
 * Contributors:
 *     hangum - initial API and implementation
 ******************************************************************************/
package com.hangum.tadpole.engine.sql.paremeter.lang;

import java.sql.PreparedStatement;

import org.apache.log4j.Logger;

import com.hangum.tadpole.engine.manager.TadpoleSQLManager;
import com.hangum.tadpole.engine.query.dao.system.UserDBDAO;

/**
 * java named parameter(?)
 * 
 * @author hangum
 *
 */
public class JavaNamedParameterUtil {
	private static final Logger logger = Logger.getLogger(JavaNamedParameterUtil.class);
	
	/**
	 * count of sql parameter 
	 * 
	 * @param userDB
	 * @param executeQuery
	 * @return
	 * @throws Exception
	 */
	public int calcParamCount(final UserDBDAO userDB, String executeQuery) throws Exception {
		int paramCount = 0;

		java.sql.Connection javaConn = null;
		PreparedStatement stmt = null;
		try {
			javaConn = TadpoleSQLManager.getConnection(userDB);
			stmt = javaConn.prepareStatement(executeQuery);
			java.sql.ParameterMetaData pmd = stmt.getParameterMetaData();
			if(pmd != null) {
				paramCount = pmd.getParameterCount();	
			} else {
				paramCount = 0;
			}
			
		} catch (Exception e) {
			logger.error("Count parameter error", e);
			paramCount = 0;
			throw e;
		} finally {
			try { if(stmt != null) stmt.close(); } catch (Exception e) {}
			try { if(javaConn != null) javaConn.close(); } catch (Exception e) {}
		}
		
		return paramCount;
	}
}