java.sql.ParameterMetaData#parameterModeIn ( )源码实例Demo

下面列出了java.sql.ParameterMetaData#parameterModeIn ( ) 实例代码，或者点击链接到github查看源代码，也可以在右侧发表评论。

源代码1 项目： birt 文件： Utility.java

/**
 * give the stored procedure's column type name from the type.
 * @param type
 * @return
 */
public static String toModeType( int type )
{
	switch ( type )
	{
		case ParameterMetaData.parameterModeUnknown:
			return "Unknown";
		case ParameterMetaData.parameterModeIn:
			return "Input";
		case ParameterMetaData.parameterModeInOut:
			return "Input/Output";
		case ParameterMetaData.parameterModeOut:
			return "Output";
		case 5:
			return "Return Value";
		default:
			return "Unknown";
	}
}

源代码2 项目： gemfirexd-oss 文件： ParameterMetaDataJdbc30Test.java

/**
        * print the parameter mode in human readable form
        *
        * @param mode identifies parameter's mode (IN, OUT, or IN_OUT)
 * @return     the parameter mode in readable form
        *             
        */
static String parameterModeInStringForm(int mode){
	if (mode ==  ParameterMetaData.parameterModeIn)
			  return("PARAMETER_MODE_IN");
	else if (mode ==  ParameterMetaData.parameterModeInOut )
			  return("PARAMETER_MODE_IN_OUT");
	else if (mode ==  ParameterMetaData.parameterModeOut)
			  return("PARAMETER_MODE_OUT");
	else if (mode ==  ParameterMetaData.parameterModeUnknown)
			  return("PARAMETER_MODE_UNKNOWN");
	else
			  return("ERROR: donot recognize this parameter mode");
 	}

源代码3 项目： gemfirexd-oss 文件： ParameterMetaDataJdbc30Test.java

/**
        * print the parameter mode in human readable form
        *
        * @param mode identifies parameter's mode (IN, OUT, or IN_OUT)
 * @return     the parameter mode in readable form
        *             
        */
static String parameterModeInStringForm(int mode){
	if (mode ==  ParameterMetaData.parameterModeIn)
			  return("PARAMETER_MODE_IN");
	else if (mode ==  ParameterMetaData.parameterModeInOut )
			  return("PARAMETER_MODE_IN_OUT");
	else if (mode ==  ParameterMetaData.parameterModeOut)
			  return("PARAMETER_MODE_OUT");
	else if (mode ==  ParameterMetaData.parameterModeUnknown)
			  return("PARAMETER_MODE_UNKNOWN");
	else
			  return("ERROR: donot recognize this parameter mode");
 	}

源代码4 项目： jsqsh 文件： SQLTools.java

/**
 * Decodes a parameter mode number into a readable string
 * @param mode The mode
 * @return The string
 */
public static String getParameterMode(int mode) {
    
    switch (mode) {
    case ParameterMetaData.parameterModeIn: return "IN";
    case ParameterMetaData.parameterModeInOut: return "INOUT";
    case ParameterMetaData.parameterModeOut: return "OUT";
    case ParameterMetaData.parameterModeUnknown: return "UNKNOWN";
    default:
        return "UNRECOGNIZED";
    }
}

源代码5 项目： spliceengine 文件： ParameterMetaDataJdbc30Test.java

/**
        * print the parameter mode in human readable form
        *
        * @param mode identifies parameter's mode (IN, OUT, or IN_OUT)
 * @return     the parameter mode in readable form
        *             
        */
static String parameterModeInStringForm(int mode){
	if (mode ==  ParameterMetaData.parameterModeIn)
			  return("PARAMETER_MODE_IN");
	else if (mode ==  ParameterMetaData.parameterModeInOut )
			  return("PARAMETER_MODE_IN_OUT");
	else if (mode ==  ParameterMetaData.parameterModeOut)
			  return("PARAMETER_MODE_OUT");
	else if (mode ==  ParameterMetaData.parameterModeUnknown)
			  return("PARAMETER_MODE_UNKNOWN");
	else
			  return("ERROR: donot recognize this parameter mode");
 	}

源代码6 项目： salesforce-jdbc 文件： ParameterMetadataImpl.java

@Override
public int getParameterMode(int param) throws SQLException {
    return ParameterMetaData.parameterModeIn;
}

源代码7 项目： lams 文件： CallableStatement.java

private void addParametersFromDBMD(java.sql.ResultSet paramTypesRs) throws SQLException {
    int i = 0;

    while (paramTypesRs.next()) {
        String paramName = paramTypesRs.getString(4);
        int inOutModifier;
        switch (paramTypesRs.getInt(5)) {
            case DatabaseMetaData.procedureColumnIn:
                inOutModifier = ParameterMetaData.parameterModeIn;
                break;
            case DatabaseMetaData.procedureColumnInOut:
                inOutModifier = ParameterMetaData.parameterModeInOut;
                break;
            case DatabaseMetaData.procedureColumnOut:
            case DatabaseMetaData.procedureColumnReturn:
                inOutModifier = ParameterMetaData.parameterModeOut;
                break;
            default:
                inOutModifier = ParameterMetaData.parameterModeUnknown;
        }

        boolean isOutParameter = false;
        boolean isInParameter = false;

        if (i == 0 && this.isFunctionCall) {
            isOutParameter = true;
            isInParameter = false;
        } else if (inOutModifier == java.sql.DatabaseMetaData.procedureColumnInOut) {
            isOutParameter = true;
            isInParameter = true;
        } else if (inOutModifier == java.sql.DatabaseMetaData.procedureColumnIn) {
            isOutParameter = false;
            isInParameter = true;
        } else if (inOutModifier == java.sql.DatabaseMetaData.procedureColumnOut) {
            isOutParameter = true;
            isInParameter = false;
        }

        int jdbcType = paramTypesRs.getInt(6);
        String typeName = paramTypesRs.getString(7);
        int precision = paramTypesRs.getInt(8);
        int scale = paramTypesRs.getInt(10);
        short nullability = paramTypesRs.getShort(12);

        CallableStatementParam paramInfoToAdd = new CallableStatementParam(paramName, i++, isInParameter, isOutParameter, jdbcType, typeName, precision,
                scale, nullability, inOutModifier);

        this.parameterList.add(paramInfoToAdd);
        this.parameterMap.put(paramName, paramInfoToAdd);
    }
}

源代码8 项目： r-course 文件： CallableStatement.java

private void addParametersFromDBMD(java.sql.ResultSet paramTypesRs) throws SQLException {
    int i = 0;

    while (paramTypesRs.next()) {
        String paramName = paramTypesRs.getString(4);
        int inOutModifier;
        switch (paramTypesRs.getInt(5)) {
            case DatabaseMetaData.procedureColumnIn:
                inOutModifier = ParameterMetaData.parameterModeIn;
                break;
            case DatabaseMetaData.procedureColumnInOut:
                inOutModifier = ParameterMetaData.parameterModeInOut;
                break;
            case DatabaseMetaData.procedureColumnOut:
            case DatabaseMetaData.procedureColumnReturn:
                inOutModifier = ParameterMetaData.parameterModeOut;
                break;
            default:
                inOutModifier = ParameterMetaData.parameterModeUnknown;
        }

        boolean isOutParameter = false;
        boolean isInParameter = false;

        if (i == 0 && this.isFunctionCall) {
            isOutParameter = true;
            isInParameter = false;
        } else if (inOutModifier == java.sql.DatabaseMetaData.procedureColumnInOut) {
            isOutParameter = true;
            isInParameter = true;
        } else if (inOutModifier == java.sql.DatabaseMetaData.procedureColumnIn) {
            isOutParameter = false;
            isInParameter = true;
        } else if (inOutModifier == java.sql.DatabaseMetaData.procedureColumnOut) {
            isOutParameter = true;
            isInParameter = false;
        }

        int jdbcType = paramTypesRs.getInt(6);
        String typeName = paramTypesRs.getString(7);
        int precision = paramTypesRs.getInt(8);
        int scale = paramTypesRs.getInt(10);
        short nullability = paramTypesRs.getShort(12);

        CallableStatementParam paramInfoToAdd = new CallableStatementParam(paramName, i++, isInParameter, isOutParameter, jdbcType, typeName, precision,
                scale, nullability, inOutModifier);

        this.parameterList.add(paramInfoToAdd);
        this.parameterMap.put(paramName, paramInfoToAdd);
    }
}

源代码9 项目： calcite-avatica 文件： AvaticaPreparedStatement.java

public int getParameterMode(int param) throws SQLException {
  //noinspection UnusedDeclaration
  AvaticaParameter paramDef = getParameter(param); // forces param range check
  return ParameterMetaData.parameterModeIn;
}

源代码10 项目： Komondor 文件： CallableStatement.java

private void addParametersFromDBMD(java.sql.ResultSet paramTypesRs) throws SQLException {
    int i = 0;

    while (paramTypesRs.next()) {
        String paramName = paramTypesRs.getString(4);
        int inOutModifier;
        switch (paramTypesRs.getInt(5)) {
            case DatabaseMetaData.procedureColumnIn:
                inOutModifier = ParameterMetaData.parameterModeIn;
                break;
            case DatabaseMetaData.procedureColumnInOut:
                inOutModifier = ParameterMetaData.parameterModeInOut;
                break;
            case DatabaseMetaData.procedureColumnOut:
            case DatabaseMetaData.procedureColumnReturn:
                inOutModifier = ParameterMetaData.parameterModeOut;
                break;
            default:
                inOutModifier = ParameterMetaData.parameterModeUnknown;
        }

        boolean isOutParameter = false;
        boolean isInParameter = false;

        if (i == 0 && this.isFunctionCall) {
            isOutParameter = true;
            isInParameter = false;
        } else if (inOutModifier == java.sql.DatabaseMetaData.procedureColumnInOut) {
            isOutParameter = true;
            isInParameter = true;
        } else if (inOutModifier == java.sql.DatabaseMetaData.procedureColumnIn) {
            isOutParameter = false;
            isInParameter = true;
        } else if (inOutModifier == java.sql.DatabaseMetaData.procedureColumnOut) {
            isOutParameter = true;
            isInParameter = false;
        }

        int jdbcType = paramTypesRs.getInt(6);
        String typeName = paramTypesRs.getString(7);
        int precision = paramTypesRs.getInt(8);
        int scale = paramTypesRs.getInt(10);
        short nullability = paramTypesRs.getShort(12);

        CallableStatementParam paramInfoToAdd = new CallableStatementParam(paramName, i++, isInParameter, isOutParameter, jdbcType, typeName, precision,
                scale, nullability, inOutModifier);

        this.parameterList.add(paramInfoToAdd);
        this.parameterMap.put(paramName, paramInfoToAdd);
    }
}

源代码11 项目： FoxTelem 文件： CallableStatement.java

private void addParametersFromDBMD(java.sql.ResultSet paramTypesRs) throws SQLException {
    int i = 0;

    while (paramTypesRs.next()) {
        String paramName = paramTypesRs.getString(4);
        int inOutModifier;
        switch (paramTypesRs.getInt(5)) {
            case DatabaseMetaData.procedureColumnIn:
                inOutModifier = ParameterMetaData.parameterModeIn;
                break;
            case DatabaseMetaData.procedureColumnInOut:
                inOutModifier = ParameterMetaData.parameterModeInOut;
                break;
            case DatabaseMetaData.procedureColumnOut:
            case DatabaseMetaData.procedureColumnReturn:
                inOutModifier = ParameterMetaData.parameterModeOut;
                break;
            default:
                inOutModifier = ParameterMetaData.parameterModeUnknown;
        }

        boolean isOutParameter = false;
        boolean isInParameter = false;

        if (i == 0 && this.isFunctionCall) {
            isOutParameter = true;
            isInParameter = false;
        } else if (inOutModifier == java.sql.DatabaseMetaData.procedureColumnInOut) {
            isOutParameter = true;
            isInParameter = true;
        } else if (inOutModifier == java.sql.DatabaseMetaData.procedureColumnIn) {
            isOutParameter = false;
            isInParameter = true;
        } else if (inOutModifier == java.sql.DatabaseMetaData.procedureColumnOut) {
            isOutParameter = true;
            isInParameter = false;
        }

        int jdbcType = paramTypesRs.getInt(6);
        String typeName = paramTypesRs.getString(7);
        int precision = paramTypesRs.getInt(8);
        int scale = paramTypesRs.getInt(10);
        short nullability = paramTypesRs.getShort(12);

        CallableStatementParam paramInfoToAdd = new CallableStatementParam(paramName, i++, isInParameter, isOutParameter, jdbcType, typeName, precision,
                scale, nullability, inOutModifier);

        this.parameterList.add(paramInfoToAdd);
        this.parameterMap.put(paramName, paramInfoToAdd);
    }
}

源代码12 项目： cassandra-jdbc-driver 文件： CassandraParameterMetaData.java

public int getParameterMode(int param) throws SQLException {
    getParameterDefinition(param);

    return ParameterMetaData.parameterModeIn;
}

源代码13 项目： phoenix 文件： PhoenixParameterMetaData.java

@Override
public int getParameterMode(int index) throws SQLException {
    return ParameterMetaData.parameterModeIn;
}

源代码14 项目： jaybird 文件： FBParameterMetaData.java

@Override
public int getParameterMode(int parameter) throws SQLException {
    return ParameterMetaData.parameterModeIn;
}

源代码15 项目： phoenix 文件： PhoenixParameterMetaData.java

@Override
public int getParameterMode(int index) throws SQLException {
    return ParameterMetaData.parameterModeIn;
}

源代码16 项目： phoenix 文件： PhoenixParameterMetaData.java

@Override
public int getParameterMode(int index) throws SQLException {
    return ParameterMetaData.parameterModeIn;
}

方法所在类

java.sql.ParameterMetaData