Package org.springframework.jdbc.core

Examples of org.springframework.jdbc.core.SqlOutParameter

84
85
86
87
88
89
90
91
92
93
94
    replay();

    List<SqlParameter> parameters = new ArrayList<SqlParameter>();
    parameters.add(new SqlParameter("id", Types.NUMERIC));
    parameters.add(new SqlInOutParameter("name", Types.NUMERIC));
    parameters.add(new SqlOutParameter("customer_no", Types.NUMERIC));

    MapSqlParameterSource parameterSource = new MapSqlParameterSource();
    parameterSource.addValue("id", 1);
    parameterSource.addValue("name", "Sven");
    parameterSource.addValue("customer_no", "12345XYZ");
View Full Code Here
181
182
183
184
185
186
187
188
189
190
191
    replay();

    SimpleJdbcCall adder = new SimpleJdbcCall(mockDataSource).withProcedureName("add_invoice");
    adder.declareParameters(new SqlParameter("amount", Types.INTEGER),
        new SqlParameter("custid", Types.INTEGER),
        new SqlOutParameter("newid", Types.INTEGER));
    Number newId = adder.executeObject(Number.class, new MapSqlParameterSource()
        .addValue("amount", amount)
        .addValue("custid", custid));
    assertEquals(4, newId.intValue());
  }
View Full Code Here
343
344
345
346
347
348
349
350
351
352
353
    ctrlConnection.setReturnValue(mockCallable);

    replay();

    SimpleJdbcCall adder = new SimpleJdbcCall(mockDataSource).withFunctionName("add_invoice");
    adder.declareParameters(new SqlOutParameter("return", Types.INTEGER),
        new SqlParameter("amount", Types.INTEGER),
        new SqlParameter("custid", Types.INTEGER));
    Number newId = adder.executeFunction(Number.class, new MapSqlParameterSource()
        .addValue("amount", amount)
        .addValue("custid", custid));
View Full Code Here
440
441
442
443
444
445
446
447
    public StoredProcedureConfiguredViaJdbcTemplate(JdbcTemplate t) {
      setJdbcTemplate(t);
      setSql(SQL);
      declareParameter(new SqlParameter("intIn", Types.INTEGER));
      declareParameter(new SqlOutParameter("intOut", Types.INTEGER));
      compile();
    }
View Full Code Here
461
462
463
464
465
466
467
468
    public AddInvoice(DataSource ds) {
      setDataSource(ds);
      setSql(SQL);
      declareParameter(new SqlParameter("amount", Types.INTEGER));
      declareParameter(new SqlParameter("custid", Types.INTEGER));
      declareParameter(new SqlOutParameter("newid", Types.INTEGER));
      compile();
    }
View Full Code Here
483
484
485
486
487
488
489
490
    public AddInvoiceUsingObjectArray(DataSource ds) {
      setDataSource(ds);
      setSql(SQL);
      declareParameter(new SqlParameter("amount", Types.INTEGER));
      declareParameter(new SqlParameter("custid", Types.INTEGER));
      declareParameter(new SqlOutParameter("newid", Types.INTEGER));
      compile();
    }
View Full Code Here
611
612
613
614
615
616
617
618
    public ParameterMapperStoredProcedure(DataSource ds) {
      setDataSource(ds);
      setSql(SQL);
      declareParameter(new SqlParameter("in", Types.VARCHAR));
      declareParameter(new SqlOutParameter("out", Types.VARCHAR));
      compile();
    }
View Full Code Here
642
643
644
645
646
647
648
649
    public SqlTypeValueStoredProcedure(DataSource ds) {
      setDataSource(ds);
      setSql(SQL);
      declareParameter(new SqlParameter("in", Types.ARRAY, "NUMBERS"));
      declareParameter(new SqlOutParameter("out", Types.VARCHAR));
      compile();
    }
View Full Code Here
668
669
670
671
672
673
674
675
    public static final String SQL = "numeric_with_scale_sp";

    public NumericWithScaleStoredProcedure(DataSource ds) {
      setDataSource(ds);
      setSql(SQL);
      declareParameter(new SqlOutParameter("out", Types.DECIMAL, 4));
      compile();
    }
View Full Code Here
206
207
208
209
210
211
212
    return false;
  }

  @Override
  public SqlParameter createDefaultOutParameter(String parameterName, CallParameterMetaData meta) {
    return new SqlOutParameter(parameterName, meta.getSqlType());
  }
View Full Code Here
TOP

Related Classes of org.springframework.jdbc.core.SqlOutParameter

  • org.skyway.spring.util.dao.call.AdvancedCallMetaDataContext
  • org.skyway.spring.util.dao.call.oracle.OracleTypeHandler
  • org.springframework.jdbc.core.metadata.CallMetaDataContext
  • org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider
  • org.springframework.jdbc.core.metadata.OracleCallMetaDataProvider
  • org.springframework.jdbc.core.metadata.PostgresCallMetaDataProvider
  • org.springframework.jdbc.core.simple.CallMetaDataContextTests
  • org.springframework.jdbc.core.simple.SimpleJdbcCallTests
  • org.springframework.jdbc.object.RdbmsOperationTests
  • org.springframework.jdbc.object.StoredProcedureTests$AddInvoice
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.