Example usage for java.sql ParameterMetaData parameterModeOut

List of usage examples for java.sql ParameterMetaData parameterModeOut

Introduction

In this page you can find the example usage for java.sql ParameterMetaData parameterModeOut.

Prototype

int parameterModeOut

To view the source code for java.sql ParameterMetaData parameterModeOut.

Click Source Link

Document

The constant indicating that the parameter's mode is OUT.

Usage

From source file:Main.java

public static void main(String[] args) throws Exception {
    Connection conn = getHSQLConnection();
    System.out.println("Got Connection.");
    Statement st = conn.createStatement();
    st.executeUpdate("create table survey (id int,name varchar);");
    st.executeUpdate("create view surveyView as (select * from survey);");
    st.executeUpdate("insert into survey (id,name ) values (1,'nameValue')");

    PreparedStatement pstmt = null;
    ParameterMetaData paramMetaData = null;
    String query = "select * from survey where id > ? and name = ?";
    pstmt = conn.prepareStatement(query);
    paramMetaData = pstmt.getParameterMetaData();
    if (paramMetaData == null) {
        System.out.println("db vendor does NOT support ParameterMetaData");
    } else {/*from   www.  j  a  v a 2s  .  c om*/
        System.out.println("db vendor supports ParameterMetaData");
        // find out the number of dynamic parameters
        int paramCount = paramMetaData.getParameterCount();
        System.out.println("paramCount=" + paramCount);
        System.out.println("-------------------");
        for (int param = 1; param <= paramCount; param++) {
            System.out.println("param number=" + param);
            int paramMode = paramMetaData.getParameterMode(param);
            System.out.println("param mode=" + paramMode);
            if (paramMode == ParameterMetaData.parameterModeOut) {
                System.out.println("the parameter's mode is OUT.");
            } else if (paramMode == ParameterMetaData.parameterModeIn) {
                System.out.println("the parameter's mode is IN.");
            } else if (paramMode == ParameterMetaData.parameterModeInOut) {
                System.out.println("the parameter's mode is INOUT.");
            } else {
                System.out.println("the mode of a parameter is unknown.");
            }
        }
    }

    pstmt.close();
    conn.close();

}

From source file:org.eclipse.birt.report.data.oda.jdbc.ui.util.Utility.java

/**
 * give the stored procedure's column type name from the type.
 * @param type//from www  .  j a v a  2 s.c o m
 * @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";
    }
}