Example usage for java.sql ParameterMetaData parameterModeInOut

Introduction

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

Prototype

int parameterModeInOut

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

Click Source Link

Document

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

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   w  ww.  j  ava  2 s  .  com*/
        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   w  w  w  .ja  va2 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";
    }
}

---