Package java.sql

Examples of java.sql.CallableStatement.execute()

2077
2078
2079
2080
2081
2082
2083
2084
2085
2086
2087
        oCall.setInt(1, iDomainId.intValue());
        oCall.setString(2, sInstanceNm);
        oCall.registerOutParameter(3, java.sql.Types.CHAR);

        oCall.execute();

        sInstanceId = oCall.getString(3);

        if (null!=sInstanceId) sInstanceId = sInstanceId.trim();
View Full Code Here
343
344
345
346
347
348
349
350
351
352
353
      }
      CallableStatement oCall = oConn.prepareCall("{ call k_sp_get_date_fare(?,?,?) }");
      oCall.setString(1, getStringNull(DB.gu_product,null));
      oCall.setDate(2, dtWhen);
      oCall.registerOutParameter(3, java.sql.Types.DECIMAL);
      oCall.execute();
      oFare = oCall.getBigDecimal(3);
      oCall.close();
    }

    if (DebugFile.trace) {
View Full Code Here
396
397
398
399
400
401
402
403
404
405
406
      }
      CallableStatement oCall = oConn.prepareCall("{ call k_sp_get_prod_fare(?,?,?) }");
      oCall.setString(1, getStringNull(DB.gu_product,null));
      oCall.setString(2, sIdFare);
      oCall.registerOutParameter(3, java.sql.Types.DECIMAL);
      oCall.execute();
      oFare = oCall.getBigDecimal(3);
      oCall.close();
    }

    if (DebugFile.trace) {
View Full Code Here
686
687
688
689
690
691
692
693
694
695
696
      eraseLocations(oConn);

      if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({call k_sp_del_product ('" + getStringNull(DB.gu_product,"null") + "')}");

      oStmt = oConn.prepareCall("{call k_sp_del_product ('" + getString(DB.gu_product) + "')}");
      oStmt.execute();
      oStmt.close();
    // End SQLException

    if (DebugFile.trace) {
      DebugFile.decIdent();
View Full Code Here
906
907
908
909
910
911
912
913
914
915
916
      // Patched for MySQL at v 3.0.13
      oCall = oConn.prepareCall("{ call k_sp_cat_obj_position(?,?,?)}");
      oCall.setString(1, getString(DB.gu_product));
      oCall.setString(2, sCategoryId);
      oCall.registerOutParameter(3, Types.INTEGER);
      oCall.execute();
      oPos = oCall.getObject(3);
      oCall.close();
      oCall = null;
    }
View Full Code Here
577
578
579
580
581
582
583
584
585
586
587
    if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_del_newsgroup('" + sNewsGroupGUID + "') })");

    oCall = oConn.prepareCall("{ call k_sp_del_newsgroup('" + sNewsGroupGUID + "') }");

    if (DebugFile.trace) DebugFile.writeln("CallableStatement.execute({ call k_sp_del_newsgroup('" + sNewsGroupGUID + "') })");
    oCall.execute();
    oCall.close();

    return true;
  } // delete
 
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
      oCall.registerOutParameter(17, Types.VARCHAR); // nm_from
      oCall.registerOutParameter(18, Types.VARCHAR); // tx_subject

      if (DebugFile.trace) DebugFile.writeln("CallableStatement.execute()");

      oCall.execute();

      sNmPageSet = oCall.getString(5);
      bRetVal = (null!=sNmPageSet);

      put (DB.gu_pageset, aPK[0]);
View Full Code Here
342
343
344
345
346
347
348
349
350
351
352
        for (int p=0; p<cParams; p++) {
          if (DebugFile.trace) DebugFile.writeln ("CallableStatement.setObject(" + String.valueOf(p+1) + "," + PK[p].toString() + ")");
          oCall.setObject(p+1, PK[p]);
        } // next (p)
        if (DebugFile.trace) DebugFile.writeln ("Connection.execute(" + sSQL + ")");
        oCall.execute();
        oCall.close();
        oCall = null;
      }
      // Si el SQL NO empieza por "{" entonces se ejecuta como un comando sin ResultSet de vuelta
      else {
View Full Code Here
180
181
182
183
184
185
186
187
188
189
190
      bRetVal = true;
    }
    else {
      if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_del_duty ('" + sDutyGUID + "')})");
      CallableStatement oCall = oConn.prepareCall("{call k_sp_del_duty ('" + sDutyGUID + "')}");
      bRetVal = oCall.execute();
      oCall.close();
    }

    return bRetVal;
  } // delete()
View Full Code Here
313
314
315
316
317
318
319
320
321
322
323
        oStmt=null;
      } else {
        CallableStatement oCall = oConn.prepareCall("{ call k_sp_del_mime_msg(?) }");
        for (int m=0; m<iDeleted; m++) {
          oCall.setString(1, oDeleted.getString(0,m));
          oCall.execute();
        } // next
        oCall.close();
        oCall=null;
      } // fi
      // When the Category is deleted its associated Products are erased from disk.
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.