Examples of java.sql.ParameterMetaData

java.sql.ParameterMetaData
An object that can be used to get information about the types and properties for each parameter marker in a PreparedStatement object. For some queries and driver implementations, the data that would be returned by a ParameterMetaData object may not be available until the PreparedStatement has been executed.
Some driver implementations may not be able to provide information about the types and properties for each parameter marker in a CallableStatement object. @since 1.4

          //variation 1, testing DERBY-44 
          PreparedStatement ps = prepareStatement("select * from sys.systables " +
              "where CAST(tablename AS VARCHAR(128)) like ? escape CAST(? AS VARCHAR(128))");
          ps.setString (1, "SYS%");
          ps.setString (2, "");
          ParameterMetaData paramMetaData = ps.getParameterMetaData();
    assertEquals("Unexpected parameter count", 2, paramMetaData.getParameterCount());


    //expected values to be stored in a 2dim. array
                String parameterMetaDataArray0 [][] = {
                //isNullable, isSigned, getPrecision, getScale, getParameterType, getParameterTypeName, getParameterClassName, getParameterMode
                {"PARAMETER_NULLABLE", "false", "128", "0", "12", "VARCHAR", "java.lang.String", "PARAMETER_MODE_IN"},

View Full Code Here

     */
          PreparedStatement ps = prepareStatement("select * from sys.systables " + 
              "where CAST(tablename AS VARCHAR(128)) like 'SYS%' and " + 
              "CAST(tableID AS VARCHAR(128)) like '8000001%'");


          ParameterMetaData paramMetaData = ps.getParameterMetaData();
    assertEquals("Unexpected parameter count", 0, paramMetaData.getParameterCount());


    //expected values to be stored in a 2dim. array
                String parameterMetaDataArray0 [][] = null;


                testParameterMetaData(paramMetaData, parameterMetaDataArray0);

View Full Code Here

            * replace with a simple where 1 = ?. Which would take either 1 for true, or 0 for false
     */
          PreparedStatement ps = prepareStatement("select * from t "+  
              "where 1=? for update");


          ParameterMetaData paramMetaData = ps.getParameterMetaData();
    assertEquals("Unexpected parameter count", 1, paramMetaData.getParameterCount());


    //expected values to be stored in a 2dim. array
                String parameterMetaDataArray0 [][] = {
                //isNullable, isSigned, getPrecision, getScale, getParameterType, getParameterTypeName, getParameterClassName, getParameterMode
                {"PARAMETER_NULLABLE", "true", "10", "0", "4", "INTEGER", "java.lang.Integer", "PARAMETER_MODE_IN"}};

View Full Code Here

   * @exception SQLException if error occurs
         */
  public void testSelectStatementUsingNoParameter () throws SQLException {


          PreparedStatement ps = prepareStatement("select * from t");
          ParameterMetaData paramMetaData = ps.getParameterMetaData();
    assertEquals("Unexpected parameter count", 0, paramMetaData.getParameterCount());
    
    //expected values to be stored in a 2dim. array
                String parameterMetaDataArray0 [][] = null; 


                testParameterMetaData(paramMetaData, parameterMetaDataArray0);

View Full Code Here

                cs.registerOutParameter(3,Types.INTEGER);
                 //parameter 4 is output only
                 cs.registerOutParameter(4,Types.INTEGER);


                 //verify the meta data for the parameters
                 ParameterMetaData paramMetaData = cs.getParameterMetaData();
                 assertEquals("Unexpected parameter count", 4, paramMetaData.getParameterCount());


    //expected values to be stored in a 2dim. array
                String parameterMetaDataArray0 [][] = {
                //isNullable, isSigned, getPrecision, getScale, getParameterType, getParameterTypeName, getParameterClassName, getParameterMode
                {"PARAMETER_NULLABLE", "true", "10", "0", "4", "INTEGER", "java.lang.Integer", "PARAMETER_MODE_IN"},

View Full Code Here

                cs.setObject(3,x, Types.CHAR);
                cs.registerOutParameter(3,Types.CHAR);
                //parameter 4 is output only
                cs.registerOutParameter(4,Types.CHAR);
     //verify the meta data for the parameters
                 ParameterMetaData paramMetaData = cs.getParameterMetaData();
    assertEquals("Unexpected parameter count", 4, paramMetaData.getParameterCount());
  
    //expected values to be stored in a 2dim. array
                String parameterMetaDataArray0 [][] = {
                //isNullable, isSigned, getPrecision, getScale, getParameterType, getParameterTypeName, getParameterClassName, getParameterMode
                {"PARAMETER_NULLABLE", "false", "10", "0", "1", "CHAR", "java.lang.String", "PARAMETER_MODE_IN"},

View Full Code Here

                cs.setObject(3,x, Types.DECIMAL);
                cs.registerOutParameter(3,Types.DECIMAL);
                //parameter 4 is output only
                cs.registerOutParameter(4,Types.DECIMAL);
    //verify the meta data for the parameters
                ParameterMetaData paramMetaData = cs.getParameterMetaData();
    assertEquals("Unexpected parameter count", 4, paramMetaData.getParameterCount());


    //expected values to be stored in a 2dim. array
                String parameterMetaDataArray0 [][] = {
                //isNullable, isSigned, getPrecision, getScale, getParameterType, getParameterTypeName, getParameterClassName, getParameterMode
                {"PARAMETER_NULLABLE", "true", "5", "3", "3", "DECIMAL", "java.math.BigDecimal", "PARAMETER_MODE_IN"},

View Full Code Here

                cs.registerOutParameter(2,Types.DECIMAL);
                //parameter 4 is output only
                cs.registerOutParameter(3,Types.DECIMAL);


    //verify the meta data for the parameters
                ParameterMetaData paramMetaData = cs.getParameterMetaData();
                assertEquals("Unexpected parameter count", 3, paramMetaData.getParameterCount());


    //expected values to be stored in a 2dim. array
                String parameterMetaDataArray0 [][] = {
                //isNullable, isSigned, getPrecision, getScale, getParameterType, getParameterTypeName, getParameterClassName, getParameterMode
                {"PARAMETER_NULLABLE", "true", "4", "2", "3", "DECIMAL", "java.math.BigDecimal", "PARAMETER_MODE_IN"},
                {"PARAMETER_NULLABLE", "true", "9", "0", "3", "DECIMAL", "java.math.BigDecimal", "PARAMETER_MODE_IN_OUT"},
                {"PARAMETER_NULLABLE", "true", "10", "2", "3", "DECIMAL", "java.math.BigDecimal", "PARAMETER_MODE_OUT"}};


                testParameterMetaData(cs.getParameterMetaData(), parameterMetaDataArray0);


            cs.close();


          cs = prepareCall("CALL PMDD(32.4, 47.9, ?, ?)");
    // parameter 3 is input and output
                Object y = new BigDecimal(1.1);
                cs.setObject(1,y, Types.DECIMAL);
                cs.registerOutParameter(1,Types.DECIMAL);
                //parameter 4 is output only
                cs.registerOutParameter(2,Types.DECIMAL);
    paramMetaData = cs.getParameterMetaData();
                assertEquals("Unexpected parameter count", 2, paramMetaData.getParameterCount());


    //expected values to be stored in a 2dim. array
                String parameterMetaDataArray1 [][] = {
                //isNullable, isSigned, getPrecision, getScale, getParameterType, getParameterTypeName, getParameterClassName, getParameterMode
                {"PARAMETER_NULLABLE", "true", "9", "0", "3", "DECIMAL", "java.math.BigDecimal", "PARAMETER_MODE_IN_OUT"},
                {"PARAMETER_NULLABLE", "true", "10", "2", "3", "DECIMAL", "java.math.BigDecimal", "PARAMETER_MODE_OUT"}};


                testParameterMetaData(cs.getParameterMetaData(), parameterMetaDataArray1);


            cs.close();


          cs = prepareCall("CALL PMDD(?, 38.2, ?, ?)");
    // parameters 1 is input only
                cs.setBigDecimal(1,new BigDecimal("1"));;
                // parameter 3 is input and output
                Object z = new BigDecimal(1.1);
                cs.setObject(2,z, Types.DECIMAL);
                cs.registerOutParameter(2,Types.DECIMAL);
                //parameter 4 is output only
                cs.registerOutParameter(3,Types.DECIMAL);


    //verify the meta data for the parameters
                paramMetaData = cs.getParameterMetaData();
    assertEquals("Unexpected parameter count", 3, paramMetaData.getParameterCount());


    //expected values to be stored in a 2dim. array
                String parameterMetaDataArray2 [][] = {
                //isNullable, isSigned, getPrecision, getScale, getParameterType, getParameterTypeName, getParameterClassName, getParameterMode
                {"PARAMETER_NULLABLE", "true", "5", "3", "3", "DECIMAL", "java.math.BigDecimal", "PARAMETER_MODE_IN"},

View Full Code Here

        assertEquals(expectedValues[5], s.getMaxRows());
        assertEquals(expectedValues[6], s.getResultSetHoldability());


        if (s instanceof PreparedStatement) {
            PreparedStatement ps = (PreparedStatement) s;
            ParameterMetaData psmd = ps.getParameterMetaData();
            // Parameter count:
            assertEquals(parameterExpectedValues[0], psmd.getParameterCount());
            for (int i = 1; i <= psmd.getParameterCount(); i++) {
                assertEquals(parameterExpectedValues[i], psmd.getParameterType(i));
            }
        }
    }

View Full Code Here

        addClass(classes, ps.getClass(), java.sql.PreparedStatement.class);
        ResultSet rs = ps.executeQuery();
        addClass(classes, rs.getClass(), java.sql.ResultSet.class);
        rs.close();


        ParameterMetaData pmd = ps.getParameterMetaData();
        addClass(classes, pmd.getClass(), java.sql.ParameterMetaData.class);


        ps.close();
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of java.sql.ParameterMetaData

com.alibaba.wasp.jdbc.TestPreparedStatement

com.asakusafw.compiler.windgate.testing.jdbc.PairJdbcSupport$PreparedStatementSupport

com.asakusafw.compiler.windgate.testing.jdbc.SimpleJdbcSupport$PreparedStatementSupport

com.blogger.tcuri.appserver.db.DbUtils

com.iCo6.util.org.apache.commons.dbutils.QueryRunner

com.impossibl.postgres.jdbc.ParameterMetaDataTest

com.knowgate.dataobjs.DBSubset

com.salesforce.phoenix.compile.QueryMetaDataTest

com.salesforce.phoenix.jdbc.PhoenixConnection

com.xiaoleilu.hutool.db.DbUtil

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.