Examples of com.centraview.common.CVDal.executeUpdate()

com.centraview.common.CVDal.executeUpdate()
Executes the SQL statement in this PreparedStatement object, which must be an SQL INSERT, UPDATE or DELETE statement; or an SQL statement that returns nothing, such as a DDL statement. @return int: Either (a) the row count for INSERT, UPDATE, orDELETE statements or (b) 0 for SQL statements that return nothing

        col = cvdl.executeQuery();


      }


      cvdl.setSql("project.deleteprojectlist");
      cvdl.executeUpdate();


      Iterator it = col.iterator();
      int i = 0;
      ModuleFieldRightMatrix mfrmx = CVUtility.getUserModuleRight("Projects", userID, false,
          this.dataSource);

View Full Code Here


        dl.setSql("project.addprojectlink");
        dl.setInt(1, projectId);
        dl.setInt(2, recordTypeId);
        dl.setInt(3, pvo.getContactID());
        dl.executeUpdate();
      }


      if (pvo.getGroupID() != 0)
      {
        dl.setSqlQuery("select ModuleID from module where name='Group'");

View Full Code Here


        dl.setSql("project.addprojectlink");
        dl.setInt(1, projectId);
        dl.setInt(2, recordTypeId);
        dl.setInt(3, pvo.getGroupID());
        dl.executeUpdate();
      }


      Vector customField = pvo.getCustomField();
      if (customField != null && customField.size() != 0)
      {

View Full Code Here


      cvdl.clearParameters();


      cvdl.setSqlQueryToNull();
      cvdl.setSqlQuery("DROP TABLE projectaccess");
      cvdl.executeUpdate();


      cvdl.destroy();


    } catch (Exception e) {
      e.printStackTrace();

View Full Code Here

          {
            dl.setSql("project.addcustomfieldscalar");
            dl.setInt(1, cvo.getFieldID());
            dl.setInt(2, projectId);
            dl.setString(3, cvo.getValue());
            dl.executeUpdate();
          }
        }
      }


      InitialContext ic = CVUtility.getInitialContext();

View Full Code Here

        searchString = searchString.substring(8);


        String str = "create TEMPORARY TABLE timeslipsearch " + searchString;
        cvdl.setSqlQueryToNull();
        cvdl.setSqlQuery(str);
        cvdl.executeUpdate();
        cvdl.clearParameters();


        str = "select ts.TimeSlipID, ts.ProjectID, project.ProjectTitle, ts.Description, "
            + "ts.CreatedBy, individual.FirstName, individual.LastName, "
            + "ts.activityid, ts.BreakTime, ts.Date, ts.Start, ts.End, activity.title "

View Full Code Here

        cvdl.setSqlQuery(str);
        col = cvdl.executeQuery();


        cvdl.setSqlQueryToNull();
        cvdl.setSqlQuery("DROP TABLE timeslipsearch");
        cvdl.executeUpdate();


        allRecords = false;


      } else {
        String appendStr = "";

View Full Code Here

      dl.setInt(6, pvo.getBudgetedHours());
      dl.setInt(7, pvo.getManagerID());
      dl.setInt(8, userId);
      dl.setInt(9, projectId);


      dl.executeUpdate();


      dl.clearParameters();
      dl.setSql("project.deleteprojectlink");
      dl.setInt(1, projectId);
      dl.executeUpdate();

View Full Code Here

      dl.executeUpdate();


      dl.clearParameters();
      dl.setSql("project.deleteprojectlink");
      dl.setInt(1, projectId);
      dl.executeUpdate();


    HashMap historyInfo = new HashMap();
    historyInfo.put("recordID",new Integer(projectId));
    historyInfo.put("recordTypeID", new Integer(Constants.ProjectModuleID));
    historyInfo.put("operation", new Integer(Constants.UPDATED));

View Full Code Here

      }


      cvdl.setSqlQueryToNull();
      cvdl.clearParameters();
      cvdl.setSqlQuery("drop table timeslipaccess");
      cvdl.executeUpdate();


      ModuleFieldRightMatrix mfrmx = CVUtility.getUserModuleRight("Time Slip", userID, false,
          this.dataSource);


      Iterator it = col.iterator();

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.