Package java.sql

Examples of java.sql.CallableStatement.execute()

348
349
350
351
352
353
354
355
356
357
358
        oCall = oConn.prepareCall("{ call " + sProc + "(?,?,?)}");
        oCall.setString(1, sList);
        oCall.setString(2, sParm);
        oCall.registerOutParameter(3, java.sql.Types.DECIMAL);
        oCall.execute();
        bBlocked = (oCall.getBigDecimal(3).intValue()!=0);
        oCall.close();
        break;

      default:
View Full Code Here
686
687
688
689
690
691
692
693
694
695
696
      DebugFile.incIdent();
      DebugFile.writeln("Connection.prepareCall({call k_sp_del_fellow ('" + sFellowGUID + "')})");
    }

    CallableStatement oCall = oConn.prepareCall("{call k_sp_del_fellow ('" + sFellowGUID + "')}");
    bRetVal = oCall.execute();
    oCall.close();

    if (DebugFile.trace) {
      DebugFile.decIdent();
      DebugFile.writeln("End Fellow.delete() : " + String.valueOf(bRetVal));
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
        oStmt.close();
        oStmt=null;
        break;
      default:
        oCall = oConn.prepareCall("{ call k_sp_del_sales_man('" + sSalesManGUID + "')}");
        oCall.execute();
        oCall.close();
        oCall = null;
    }
    if (DebugFile.trace) {
      DebugFile.decIdent();
View Full Code Here
214
215
216
217
218
219
220
221
222
223
224
      Statement oStmt = oConn.createStatement();
      oStmt.executeQuery("SELECT k_sp_del_activity ('"+getString(DB.gu_activity)+"')");
      oStmt.close();
    } else {
      CallableStatement oCall = oConn.prepareCall("{ call k_sp_del_activity ('"+getString(DB.gu_activity)+"') }");
    oCall.execute();
    oCall.close();
    }
    return true;
  } // delete
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
    else {
      if (DebugFile.trace)
        DebugFile.writeln("Connection.prepareCall({ call k_sp_del_course('"+sGuCourse+"') })");
      CallableStatement oCall = oConn.prepareCall("{ call k_sp_del_course(?) }");
      oCall.setString(1, sGuCourse);
      oCall.execute();
      oCall.close();
    }
    if (DebugFile.trace) {
      DebugFile.decIdent();
      DebugFile.writeln("End Course.delete()");
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
        oCall.setString(2,sPassword);
        oCall.registerOutParameter(3, java.sql.Types.DECIMAL);

        if (DebugFile.trace) DebugFile.writeln("  java.sql.Connection.execute()");

        oCall.execute();
        iStatus = Short.parseShort(oCall.getBigDecimal(3).toString());
        oCall.close();
        break;

      case JDCConnection.DBMS_MSSQL:
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
        oCall.setString(2,sPassword);
        oCall.registerOutParameter(3, java.sql.Types.SMALLINT);

        if (DebugFile.trace) DebugFile.writeln("  java.sql.Connection.execute()");

        oCall.execute();
        iStatus = oCall.getShort(3);
        oCall.close();
        break;

        case JDCConnection.DBMS_POSTGRESQL:
View Full Code Here
362
363
364
365
366
367
368
369
370
371
372
      oCall.setInt(1, iDomain);
      oCall.setString(2, sNickName);
      oCall.registerOutParameter(3, java.sql.Types.CHAR);

      oCall.execute();

      if (JDCConnection.DBMS_ORACLE==oConn.getDataBaseProduct()) {
        sUserId = oCall.getString(3);
        if (null!=sUserId) sUserId = sUserId.trim();
      }
View Full Code Here
574
575
576
577
578
579
580
581
582
583
584
      if (DebugFile.trace) {
        DebugFile.writeln("Connection.prepareCall({call k_sp_del_acourse('"+sGuACourse+"')})");
      }
      CallableStatement oCall = oConn.prepareCall("{ call k_sp_del_acourse(?) }");
      oCall.setString(1, sGuACourse);
      oCall.execute();
      oCall.close();
    }
    if (DebugFile.trace) {
      DebugFile.decIdent();
      DebugFile.writeln("End AcademicCourse.delete()");
View Full Code Here
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
        oCall = oConn.prepareCall("{ call k_is_workarea_user (?,?,?)}");

        oCall.setString(1, guWorkArea);
        oCall.setString(2, sUserId);
        oCall.registerOutParameter(3, Types.DECIMAL);
        oCall.execute();
        iIsUser = oCall.getBigDecimal(3).intValue();
        oCall.close();
        break;

      case JDCConnection.DBMS_MSSQL:
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.