Package java.sql

Examples of java.sql.CallableStatement.execute()

281
282
283
284
285
286
287
288
289
290
291
        if (DebugFile.trace) DebugFile.writeln("{call k_sp_get_cat_path ('" + getStringNull(DB.gu_category, "null") + "',?)}");

        oCall = oConn.prepareCall("{call k_sp_get_cat_path (?,?)}");
        oCall.setString(1, getString(DB.gu_category));
        oCall.registerOutParameter(2, java.sql.Types.VARCHAR);
        oCall.execute();
        sPath = oCall.getString(2);
        oCall.close();
      }
    // End SQLException
View Full Code Here
432
433
434
435
436
437
438
439
440
441
442
      iTokCount = oUsrTok.countTokens();
      sIdCategory = getString(DB.gu_category);

      for (int t=0; t<iTokCount; t++) {
        oStmt.setString(1, oUsrTok.nextToken());
        oStmt.execute();
      } // end for ()

      oStmt.close();
    }
    else {
View Full Code Here
439
440
441
442
443
444
445
446
447
448
449
      oStmt.close();
    }
    else {
      oStmt.setString(1, sIdGroups);
      oStmt.execute();
      oStmt.close();
    }

    if (DebugFile.trace) {
       DebugFile.decIdent();
View Full Code Here
508
509
510
511
512
513
514
515
516
517
518
        iTokCount = oUsrTok.countTokens();
        for (int t=0; t<iTokCount; t++) {
          sToken = oUsrTok.nextToken();
          if (DebugFile.trace) DebugFile.writeln("CallableStatement.setString(1,"+sToken+")");
          oCall.setString(1, sToken);
          oCall.execute();
        } // end for ()
      }
      else {
        if (DebugFile.trace) DebugFile.writeln("CallableStatement.setString(1,"+sIdGroups+")");
        oCall.setString(1, sIdGroups);
View Full Code Here
514
515
516
517
518
519
520
521
522
523
524
        } // end for ()
      }
      else {
        if (DebugFile.trace) DebugFile.writeln("CallableStatement.setString(1,"+sIdGroups+")");
        oCall.setString(1, sIdGroups);
        oCall.execute();
      }
      oCall.close();
    }

    if (DebugFile.trace) {
View Full Code Here
578
579
580
581
582
583
584
585
586
587
588
      oCall = oConn.prepareCall("{ call k_sp_cat_usr_perm(?,?,?) }");
      oCall.setString(1, sIdUser);
      oCall.setString(2, getString(DB.gu_category));
      oCall.registerOutParameter(3, java.sql.Types.INTEGER);
      oCall.execute();
      iACLMask = oCall.getInt(3);
      oCall.close();
    }

    if (DebugFile.trace) {
View Full Code Here
637
638
639
640
641
642
643
644
645
646
647
      oCall = oConn.prepareCall("{ call k_sp_cat_grp_perm(?,?,?) }");
      oCall.setString(1, sIdGroup);
      oCall.setString(2, getString(DB.gu_category));
      oCall.registerOutParameter(3, java.sql.Types.INTEGER);
      oCall.execute();
      iACLMask = oCall.getInt(3);
      oCall.close();
    }

    if (DebugFile.trace) {
View Full Code Here
685
686
687
688
689
690
691
692
693
694
695
      oUsrTok = new StringTokenizer(sIdUsers, ",");
      iTokCount = oUsrTok.countTokens();

      for (int t=0; t<iTokCount; t++) {
        oStmt.setString(1, oUsrTok.nextToken());
        oStmt.execute();
      } // end for ()

      oStmt.close();
    }
    else {
View Full Code Here
692
693
694
695
696
697
698
699
700
701
702
      oStmt.close();
    }
    else {
      oStmt.setString(1, sIdUsers);
      oStmt.execute();
      oStmt.close();
    }

    if (DebugFile.trace) {
       DebugFile.decIdent();
View Full Code Here
753
754
755
756
757
758
759
760
761
762
763
        if (DebugFile.trace) DebugFile.writeln("binding user " + String.valueOf(t+1) + "/" + String.valueOf(iTokCount) + " " + sUserId);

    if (null!=oCall) {
          oCall.setString(1, getString(DB.gu_category));
          oCall.setString(2, sUserId);
          oCall.execute();
    } else {
          oStmt.setObject(1, getString(DB.gu_category), java.sql.Types.CHAR);
          oStmt.setObject(2, sUserId, java.sql.Types.CHAR);
          oStmt.executeQuery().close();
    }
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.