List of usage examples for java.sql ParameterMetaData parameterModeOut
int parameterModeOut
To view the source code for java.sql ParameterMetaData parameterModeOut.
Click Source Link
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"; } }