Package java.sql

Examples of java.sql.CallableStatement.execute()

1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
        oCall = oConn.prepareCall("{ call k_is_workarea_user (?,?,?)}");

        oCall.setString(1, guWorkArea);
        oCall.setString(2, sUserId);
        oCall.registerOutParameter(3, Types.INTEGER);
        oCall.execute();
        iIsUser = oCall.getInt(3);
        oCall.close();
        break;

      default:
View Full Code Here
1610
1611
1612
1613
1614
1615
1616
1617
1618
1619
1620
        oCall = oConn.prepareCall("{ call k_is_workarea_guest (?,?,?)}");

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

      case JDCConnection.DBMS_MSSQL:
View Full Code Here
1626
1627
1628
1629
1630
1631
1632
1633
1634
1635
1636
        oCall = oConn.prepareCall("{ call k_is_workarea_guest (?,?,?)}");

        oCall.setString(1, guWorkArea);
        oCall.setString(2, sUserId);
        oCall.registerOutParameter(3, Types.INTEGER);
        oCall.execute();
        iIsGuest = oCall.getInt(3);
        oCall.close();
        break;

      default:
View Full Code Here
186
187
188
189
190
191
192
193
194
195
196
  public static boolean delete(JDCConnection oConn, String sRoomNm, String sWrkAId) throws SQLException {
    boolean bRetVal;

    CallableStatement oCall = oConn.prepareCall("{call k_sp_del_room ('" + sRoomNm + "','" + sWrkAId + "')}");
    bRetVal = oCall.execute();
    oCall.close();

    return bRetVal;
  } // delete
View Full Code Here
1693
1694
1695
1696
1697
1698
1699
1700
1701
1702
1703
        oCall = oConn.prepareCall("{ call k_is_workarea_anyrole (?,?,?)}");

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

      case JDCConnection.DBMS_MSSQL:
View Full Code Here
1709
1710
1711
1712
1713
1714
1715
1716
1717
1718
1719
        oCall = oConn.prepareCall("{ call k_is_workarea_anyrole (?,?,?)}");

        oCall.setString(1, guWorkArea);
        oCall.setString(2, sUserId);
        oCall.registerOutParameter(3, Types.INTEGER);
        oCall.execute();
        iIsAnyRole = oCall.getInt(3);
        oCall.close();
        break;

      default:
View Full Code Here
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
    case JDCConnection.DBMS_MSSQL:
    case JDCConnection.DBMS_MYSQL:
      oCall = oConn.prepareCall("{ call k_sp_del_duplicates(?,?) }");
        oCall.setString(1, getString(DB.gu_list));
        oCall.registerOutParameter(2, java.sql.Types.INTEGER);
        oCall.execute();
        iDeleted = oCall.getInt(2);
        oCall.close();
        break;
      case JDCConnection.DBMS_ORACLE:
      oStmt = oConn.prepareStatement("DELETE FROM "+DB.k_x_list_members+" WHERE "+DB.gu_list+"=? AND ROWID NOT IN (SELECT MAX(ROWID) FROM "+DB.k_x_list_members+" WHERE "+DB.gu_list+"=? GROUP BY "+DB.tx_email+")");
View Full Code Here
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
      oStmt.executeQuery("SELECT k_sp_del_list ('" + sListGUID + "')");
      oStmt.close();
      bRetVal = true;
    } else {
      CallableStatement oCall = oConn.prepareCall("{ call k_sp_del_list ('" + sListGUID + "') }");
      bRetVal = oCall.execute();
      oCall.close();
    }

    if (DebugFile.trace) {
      DebugFile.decIdent();
View Full Code Here
185
186
187
188
189
190
191
192
193
194
195
    throws SQLException {
        CallableStatement setDBP =  conn.prepareCall(
        "CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?, ?)");
        setDBP.setString(1, propertyName);
        setDBP.setString(2, value);
        setDBP.execute();
        setDBP.close();
    }

    protected String getDatabaseProperty(
            String propertyName, Connection conn)
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
      cStmt.setInt(1,forUser.getForUser().getId());
      cStmt.setInt(2,forUser.getBookmark().getId());
      cStmt.setString(3,forUser.getMessage());
      cStmt.setTimestamp(4,new Timestamp(forUser.getCreatedOn().getTime()));
      cStmt.registerOutParameter(5,Types.INTEGER);
      cStmt.execute();
      id = cStmt.getInt(5);
    } catch (Exception e) {
      logger.fatal(e);
    } finally{
      try {
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.