Package java.sql

Examples of java.sql.CallableStatement.execute()

769
770
771
772
773
774
775
776
777
778
779
    if (null!=oCall) {
        oCall.setString(1, getString(DB.gu_category));
        oCall.setString(2, sIdUsers);
        if (DebugFile.trace) DebugFile.writeln("CallableStatement.execute()");
        oCall.execute();
    } else {
        oStmt.setObject(1, getString(DB.gu_category), java.sql.Types.CHAR);
        oStmt.setObject(2, sIdUsers, java.sql.Types.CHAR);
        if (DebugFile.trace) DebugFile.writeln("PreparedStatement.executeQuery()");
        oStmt.executeQuery().close();
View Full Code Here
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
    }
    else {
      oCall = oConn.prepareCall("{ call k_sp_cat_level(?,?)}");
      oCall.setString(1, getString(DB.gu_category));
      oCall.registerOutParameter(2, java.sql.Types.INTEGER);
      oCall.execute();
      iLevel = oCall.getInt(2);
      oCall.close();
    }

    return iLevel;
View Full Code Here
1500
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
      DebugFile.incIdent();
      DebugFile.writeln("Connection.prepareCall({ call k_sp_cat_expand ('" + getStringNull(DB.gu_category,"null") + "')}");
    }

    oStmt = oConn.prepareCall("{ call k_sp_cat_expand ('" + getString(DB.gu_category) + "') }");
    oStmt.execute();
    oStmt.close();

    if (DebugFile.trace) {
      DebugFile.decIdent();
      DebugFile.writeln("End Category.expand()");
View Full Code Here
2166
2167
2168
2169
2170
2171
2172
2173
2174
2175
2176
      }
      else {
        CallableStatement oCall = oConn.prepareCall("{ call k_sp_del_mime_msg(?) }");
        for (int m=0; m<iObjs; m++) {
          oCall.setString(1, oObjs.getString(0,m));
          oCall.execute();
        }
        oCall.close();
      }
    } // fi (exists(k_mime_msgs))
View Full Code Here
2216
2217
2218
2219
2220
2221
2222
2223
2224
2225
2226
      oStmt.close();
      bRetVal = true;
    } else {
      if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({call k_sp_del_category_r('" + sCategoryGUID + "')})");
      CallableStatement oCall = oConn.prepareCall("{call k_sp_del_category_r ('" + sCategoryGUID + "')}");
      bRetVal = oCall.execute();
      oCall.close();
    }

    if (DebugFile.trace) {
      DebugFile.decIdent();
View Full Code Here
578
579
580
581
582
583
584
585
586
587
588
      oStmt.executeQuery("SELECT k_sp_prj_expand ('" + getString(DB.gu_project) + "')");
      oStmt.close();
    } else {
      if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_prj_expand ('" + getStringNull(DB.gu_project,"null") + "')}");
      oCall = oConn.prepareCall("{ call k_sp_prj_expand ('" + getString(DB.gu_project) + "') }");
      oCall.execute();
      oCall.close();
    }

    if (DebugFile.trace) {
      DebugFile.decIdent();
View Full Code Here
888
889
890
891
892
893
894
895
896
897
898
      bRetVal = true;
    }
    else {
      if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_del_project ('" + sProjectGUID + "')})");
      CallableStatement oCall = oConn.prepareCall("{ call k_sp_del_project ('" + sProjectGUID + "')}");
      bRetVal = oCall.execute();
      oCall.close();
    }

    if (DebugFile.trace) DebugFile.writeln("sTopParent="+sTopParent);
View Full Code Here
489
490
491
492
493
494
495
496
497
498
499
      bRetVal = true;
    }
    else {
      if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_del_bug ('" + sBugGUID + "')})");
      CallableStatement oCall = oConn.prepareCall("{call k_sp_del_bug ('" + sBugGUID + "')}");
      bRetVal = oCall.execute();
      oCall.close();
    }

    return bRetVal;
  } // delete()
View Full Code Here
484
485
486
487
488
489
490
491
492
493
494
      default:
        if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_get_user_mailroot('"+getStringNull(DB.gu_user,"null")+"',?) }");
        oCall = oConn.prepareCall("{ call k_sp_get_user_mailroot(?,?) }");
        oCall.setString(1, getString(DB.gu_user));
        oCall.registerOutParameter(2, java.sql.Types.CHAR);
        oCall.execute();
        sRetVal = oCall.getString(2);
        oCall.close();
        break;
    }
View Full Code Here
603
604
605
606
607
608
609
610
611
612
613
        if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_get_user_mailfolder('"+getStringNull(DB.gu_user,"null")+"','"+sFolderName+"',?)})");
        oCall = oConn.prepareCall("{ call k_sp_get_user_mailfolder(?,?,?) }");
        oCall.setString(1, getString(DB.gu_user));
        oCall.setString(2, sFolderName);
        oCall.registerOutParameter(3, java.sql.Types.CHAR);
        oCall.execute();
        sRetVal = oCall.getString(3);
        oCall.close();
        break;
    }
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.