sqlstrategyfactory.java

提供ESB 应用mule源代码 提供ESB 应用mule源代码

/*
 * $Id: SQLStrategyFactory.java 12763 2008-09-26 22:35:25Z aperepel $
 * --------------------------------------------------------------------------------------
 * Copyright (c) MuleSource, Inc.  All rights reserved.  http://www.mulesource.com
 *
 * The software in this package is published under the terms of the CPAL v1.0
 * license, a copy of which has been included with this distribution in the
 * LICENSE.txt file.
 */

package org.mule.transport.jdbc.sqlstrategy;

/**
 * Factory that selects appropriate implementation of SQLStrategy for a particular SQL string
 */


public class SQLStrategyFactory 
{


    protected SimpleUpdateSQLStrategy simpleUpdateSQLStrategy;
    protected SelectSQLStrategy selectSQLStrategy;
    protected CallableSQLStrategy callableSQLStrategy;

    public SQLStrategyFactory()
    {
        simpleUpdateSQLStrategy = new SimpleUpdateSQLStrategy();
        selectSQLStrategy = new SelectSQLStrategy();
        callableSQLStrategy = new CallableSQLStrategy();
    }

    public SQLStrategy create(String sql,Object payload)
        throws Exception
    {
        String sqlLowerCase = sql.toLowerCase();

        if( sqlLowerCase.startsWith("insert") ||
            sqlLowerCase.startsWith("update") ||
            sqlLowerCase.startsWith("delete") ||
            sqlLowerCase.startsWith("merge"))
        {
            return simpleUpdateSQLStrategy;
        }

        if (sqlLowerCase.startsWith("select"))
        {
            return selectSQLStrategy;
        }

        if (sqlLowerCase.startsWith("call"))
        {
            return callableSQLStrategy;
        }

        throw new IllegalArgumentException("No SQL Strategy found for SQL statement: " + sql);
    }

}