Examples of java.sql.Statement.executeUpdate()

java.sql.Statement.executeUpdate()
Executes the supplied SQL statement. The statement may be an INSERT, UPDATE or DELETE statement or a statement which returns nothing. @param sql an SQL statement to execute - an SQL INSERT, UPDATE, DELETE or a statement which returns nothing @return the count of updated rows, or 0 for a statement that returnsnothing. @throws SQLException if an error occurs accessing the database or if the statement produces a ResultSet

    int result;


    try
    {
      stmt = mConnection.createStatement();
      result = stmt.executeUpdate(statement);
    }
    catch (SQLException e)
    {
      throw new XException(Constants.LOCATION_EXTERN,
          Constants.LAYER_TECHNICAL,

View Full Code Here


     if (DBBind.exists(oConn, DB.k_companies, "U")) {
       if (DebugFile.trace)
         DebugFile.writeln("Statement.executeUpdate(UPDATE " + DB.k_companies + " SET " + DB.gu_geozone + "=NULL WHERE " + DB.gu_geozone + "='" + sTermGUID + "')");


       oUpdt.executeUpdate("UPDATE " + DB.k_companies + " SET " + DB.gu_geozone + "=NULL WHERE " + DB.gu_geozone + "='" + sTermGUID + "'");
     }


     if (DBBind.exists(oConn, DB.k_contacts, "U")) {
       if (DebugFile.trace)
         DebugFile.writeln("Statement.executeUpdate(UPDATE " + DB.k_contacts + " SET " + DB.gu_geozone + "=NULL WHERE " + DB.gu_geozone + "='" + sTermGUID + "')");

View Full Code Here


     if (DBBind.exists(oConn, DB.k_contacts, "U")) {
       if (DebugFile.trace)
         DebugFile.writeln("Statement.executeUpdate(UPDATE " + DB.k_contacts + " SET " + DB.gu_geozone + "=NULL WHERE " + DB.gu_geozone + "='" + sTermGUID + "')");


       oUpdt.executeUpdate("UPDATE " + DB.k_contacts + " SET " + DB.gu_geozone + "=NULL WHERE " + DB.gu_geozone + "='" + sTermGUID + "'");
     }


     if (DBBind.exists(oConn, DB.k_member_address, "U")) {
       if (DebugFile.trace)
         DebugFile.writeln("Statement.executeUpdate(UPDATE " + DB.k_member_address + " SET " + DB.gu_geozone + "=NULL WHERE " + DB.gu_geozone + "='" + sTermGUID + "')");

View Full Code Here


     if (DBBind.exists(oConn, DB.k_member_address, "U")) {
       if (DebugFile.trace)
         DebugFile.writeln("Statement.executeUpdate(UPDATE " + DB.k_member_address + " SET " + DB.gu_geozone + "=NULL WHERE " + DB.gu_geozone + "='" + sTermGUID + "')");


       oUpdt.executeUpdate("UPDATE " + DB.k_member_address + " SET " + DB.gu_geozone + "=NULL WHERE " + DB.gu_geozone + "='" + sTermGUID + "'");
     }


     oUpdt.close();


    // Find root term

View Full Code Here


    // Delete Synonyms
    if (DebugFile.trace)
      DebugFile.writeln("Statement.executeUpdate(DELETE FROM " + DB.k_thesauri + " WHERE " + DB.gu_synonym + "='" + sTermGUID + "')");


    oStmt.executeUpdate("DELETE FROM " + DB.k_thesauri + " WHERE " + DB.gu_synonym + "='" + sTermGUID + "'");


    // Delete Term and Childs
    if (DebugFile.trace)
      DebugFile.writeln("Statement.executeUpdate(DELETE FROM " + DB.k_thesauri + " WHERE " + sTermN + "=" + String.valueOf(oDlte.getInt(sTermN)) + " AND " + DB.id_domain + "=" + oDlte.getInt(DB.id_domain) + ")");

View Full Code Here


    // Delete Term and Childs
    if (DebugFile.trace)
      DebugFile.writeln("Statement.executeUpdate(DELETE FROM " + DB.k_thesauri + " WHERE " + sTermN + "=" + String.valueOf(oDlte.getInt(sTermN)) + " AND " + DB.id_domain + "=" + oDlte.getInt(DB.id_domain) + ")");


    oStmt.executeUpdate("DELETE FROM " + DB.k_thesauri + " WHERE " + sTermN + "=" + String.valueOf(oDlte.getInt(sTermN)) + " AND " + DB.id_domain + "=" + oDlte.getInt(DB.id_domain));


    // Delete root entry if term is a root one
    if (sRootTerm.equals(sTermGUID))
      oStmt.executeUpdate("DELETE FROM " + DB.k_thesauri_root + " WHERE " + DB.gu_rootterm + "='" + sTermGUID + "'");

View Full Code Here


    oStmt.executeUpdate("DELETE FROM " + DB.k_thesauri + " WHERE " + sTermN + "=" + String.valueOf(oDlte.getInt(sTermN)) + " AND " + DB.id_domain + "=" + oDlte.getInt(DB.id_domain));


    // Delete root entry if term is a root one
    if (sRootTerm.equals(sTermGUID))
      oStmt.executeUpdate("DELETE FROM " + DB.k_thesauri_root + " WHERE " + DB.gu_rootterm + "='" + sTermGUID + "'");


    oStmt.close();


    if (DebugFile.trace) {
      DebugFile.decIdent();

View Full Code Here


  // ************
    // New for v6.0


    if (isNull(DB.gu_workarea)) put(DB.gu_workarea, DBCommand.queryStr(oConn, "SELECT "+DB.gu_workarea+" FROM "+DB.k_addresses+" WHERE "+DB.gu_address+"='"+ getString(DB.gu_address)+"'"));
      oDlte.executeUpdate("DELETE FROM "+DB.k_meetings_lookup+" WHERE "+DB.id_section+"='"+DB.gu_address+"' AND "+DB.gu_owner+"='"+getString(DB.gu_workarea)+"' AND "+DB.vl_lookup+"='"+getString(DB.gu_address)+"'");


  // ************
    // New for v5.0


    if (DBBind.exists(oConn, DB.k_activities, "U")) {

View Full Code Here


  // ************
    // New for v5.0


    if (DBBind.exists(oConn, DB.k_activities, "U")) {
      oDlte.executeUpdate("UPDATE "+DB.k_activities+" SET "+DB.gu_address+"=NULL WHERE "+DB.gu_address+"='"+getString(DB.gu_address)+"'");
    }


    if (DBBind.exists(oConn, DB.k_x_activity_audience, "U")) {
      oDlte.executeUpdate("UPDATE "+DB.k_x_activity_audience+" SET "+DB.gu_address+"=NULL WHERE "+DB.gu_address+"='"+getString(DB.gu_address)+"'");
    }

View Full Code Here

    if (DBBind.exists(oConn, DB.k_activities, "U")) {
      oDlte.executeUpdate("UPDATE "+DB.k_activities+" SET "+DB.gu_address+"=NULL WHERE "+DB.gu_address+"='"+getString(DB.gu_address)+"'");
    }


    if (DBBind.exists(oConn, DB.k_x_activity_audience, "U")) {
      oDlte.executeUpdate("UPDATE "+DB.k_x_activity_audience+" SET "+DB.gu_address+"=NULL WHERE "+DB.gu_address+"='"+getString(DB.gu_address)+"'");
    }


    if (DBBind.exists(oConn, DB.k_sms_audit, "U")) {
      oDlte.executeUpdate("UPDATE "+DB.k_sms_audit+" SET "+DB.gu_address+"=NULL WHERE "+DB.gu_address+"='"+getString(DB.gu_address)+"'");
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.