Package org.fbsql.servlet

Class CallUtils

java.lang.Object

org.fbsql.servlet.CallUtils

public class CallUtils
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field	Description
private static java.lang.String	PLT_OPTIONS_JS_FILE
private static java.lang.String	PLT_OPTIONS_JS_FUNCTION
private static java.lang.String	PLT_OPTIONS_JVM_CLASS
private static java.lang.String	PLT_OPTIONS_JVM_METHOD
private static java.lang.String	PLT_OPTIONS_OS_FILE
private static java.lang.String	PLT_OPTIONS_URL_URL

Constructor Summary

Constructors

Constructor	Description
CallUtils()

Method Summary

Modifier and Type	Method	Description
static java.lang.String	executeFile(java.lang.String instanceDirectory, java.lang.String text)
static java.lang.String	executeOsProgramm(java.lang.String instanceDirectory, java.lang.String optionsJson, java.lang.Object[] parameters)
static java.lang.String	executeUrl(java.lang.String instanceDirectory, java.lang.String optionsJson, java.util.Map<java.lang.String,java.lang.Object> parametersMap)
static NonNativeProcedure	getCallStatementNonNativeProcedure(java.lang.String sql, java.util.Map<java.lang.String,NonNativeProcedure> proceduresMap)	Get CALL Statement Method
static void	getCallStatementParameterValues(ParseNativeStmt parseNativeStmt, java.lang.String sql, java.util.Map<java.lang.String,java.lang.Object> namedParametersMap, java.util.List<java.lang.Object> parameterValues)	Get CALL Statement Parameter Values
static JsFunction	getFunction(java.lang.String instanceDirectory, java.lang.String text, java.util.Map<java.lang.String,org.mozilla.javascript.Scriptable> mapScopes, java.util.Map<java.lang.String,java.util.Map<java.lang.String,org.mozilla.javascript.Function>> mapFunctions)	Get JavaScript Function
static java.lang.reflect.Method	getMethod(java.lang.String text)	Get Java Method
private static void	parseNamedSqlParameters(java.util.List<java.lang.String> strParameters, java.util.List<java.lang.String> parameterNames, java.util.List<java.lang.Object> parameterValues)	Parse named SQL parameters
static void	parseSqlParameters(ParseNativeStmt parseNativeStmt, java.lang.String s, java.util.List<java.lang.Object> parameterValues)	Parse SQL parameters

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

PLT_OPTIONS_JS_FILE

private static final java.lang.String PLT_OPTIONS_JS_FILE

See Also:

Constant Field Values

PLT_OPTIONS_JS_FUNCTION

private static final java.lang.String PLT_OPTIONS_JS_FUNCTION

See Also:

Constant Field Values

PLT_OPTIONS_JVM_CLASS

private static final java.lang.String PLT_OPTIONS_JVM_CLASS

See Also:

Constant Field Values

PLT_OPTIONS_JVM_METHOD

private static final java.lang.String PLT_OPTIONS_JVM_METHOD

See Also:

Constant Field Values

PLT_OPTIONS_OS_FILE

private static final java.lang.String PLT_OPTIONS_OS_FILE

See Also:

Constant Field Values

PLT_OPTIONS_URL_URL

private static final java.lang.String PLT_OPTIONS_URL_URL

See Also:

Constant Field Values

Constructor Detail

CallUtils

public CallUtils()

Method Detail

getCallStatementNonNativeProcedure

public static NonNativeProcedure getCallStatementNonNativeProcedure(java.lang.String sql,
                                                                    java.util.Map<java.lang.String,NonNativeProcedure> proceduresMap)

Get CALL Statement Method

Parameters:

sql -

proceduresMap -

Returns:

Throws:

java.lang.Exception

executeOsProgramm

public static java.lang.String executeOsProgramm(java.lang.String instanceDirectory,
                                                 java.lang.String optionsJson,
                                                 java.lang.Object[] parameters)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

executeUrl

public static java.lang.String executeUrl(java.lang.String instanceDirectory,
                                          java.lang.String optionsJson,
                                          java.util.Map<java.lang.String,java.lang.Object> parametersMap)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

executeFile

public static java.lang.String executeFile(java.lang.String instanceDirectory,
                                           java.lang.String text)
                                    throws java.lang.Exception

Throws:

java.lang.Exception

getMethod

public static java.lang.reflect.Method getMethod(java.lang.String text)
                                          throws java.lang.Exception

Get Java Method

Parameters:

text -

Returns:

Throws:

java.lang.Exception

getFunction

public static JsFunction getFunction(java.lang.String instanceDirectory,
                                     java.lang.String text,
                                     java.util.Map<java.lang.String,org.mozilla.javascript.Scriptable> mapScopes,
                                     java.util.Map<java.lang.String,java.util.Map<java.lang.String,org.mozilla.javascript.Function>> mapFunctions)
                              throws java.lang.Exception

Get JavaScript Function

Parameters:

text -

mapScopes -

mapFunctions -

Returns:

Throws:

java.lang.Exception

getCallStatementParameterValues

public static void getCallStatementParameterValues(ParseNativeStmt parseNativeStmt,
                                                   java.lang.String sql,
                                                   java.util.Map<java.lang.String,java.lang.Object> namedParametersMap,
                                                   java.util.List<java.lang.Object> parameterValues)
                                            throws java.lang.Exception

Get CALL Statement Parameter Values

Parameters:

sql -

namedParametersMap -

parameterValues -

Throws:

java.lang.Exception

parseNamedSqlParameters

private static void parseNamedSqlParameters(java.util.List<java.lang.String> strParameters,
                                            java.util.List<java.lang.String> parameterNames,
                                            java.util.List<java.lang.Object> parameterValues)

Parse named SQL parameters

Parameters:

s - - parameters string E.g "'John', 123.45, NULL, :price"

parameterNames - - parsed parameter names (output)

parameterValues - - parsed parameter values (output)

parseSqlParameters

public static void parseSqlParameters(ParseNativeStmt parseNativeStmt,
                                      java.lang.String s,
                                      java.util.List<java.lang.Object> parameterValues)

Parse SQL parameters

Parameters:

s - - parameters string E.g "'John', 123.45, NULL"

parameterValues - - parsed parameter values (output)