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

      dl.executeUpdate();
      dl.clearParameters();


      dl.setSql("projecttask.deletetaskassigned");
      dl.setInt(1, tvo.getActivityID());
      dl.executeUpdate();
      dl.clearParameters();


      HashMap assigned = (HashMap)tvo.getAssignedTo();
      Iterator ite = null;
      if (assigned != null)

View Full Code Here

    String filter = parameters.getFilter();
    CVDal cvdl = new CVDal(this.dataSource);
    if (filter != null && filter.length() > 0) {
      String str = "CREATE TABLE timeslipslistfilter " + filter;
      cvdl.setSqlQuery(str);
      cvdl.executeUpdate();
      cvdl.setSqlQueryToNull();
      applyFilter = true;
    }
    int numberOfRecords = 0;
    if (applyFilter) {

View Full Code Here

          "TimeSlipID", "CreatedBy", null, permissionSwitch);
    }
    parameters.setTotalRecords(numberOfRecords);
    String query = this.buildTimeslipsListQuery(applyFilter, permissionSwitch, parameters);
    cvdl.setSqlQuery(query);
    cvdl.executeUpdate();
    cvdl.setSqlQueryToNull();


    cvdl.setSqlQuery("SELECT * FROM timeslipslist");
    list = cvdl.executeQueryList(1);
    cvdl.setSqlQueryToNull();

View Full Code Here

          int assignedTo = ((Integer)ite.next()).intValue();


          dl.setSql("projecttask.addtaskassigned");
          dl.setInt(1, tvo.getActivityID());
          dl.setInt(2, assignedTo);
          dl.executeUpdate();
          dl.clearParameters();
        }
      }


      dl.setSql("projecttask.selecttaskaction");

View Full Code Here


    cvdl.setSqlQuery("SELECT * FROM timeslipslist");
    list = cvdl.executeQueryList(1);
    cvdl.setSqlQueryToNull();
    cvdl.setSqlQuery("DROP TABLE timeslipslist");
    cvdl.executeUpdate();
    // throw away the temp filter table, if necessary.
    if (applyFilter) {
      cvdl.setSqlQueryToNull();
      cvdl.setSqlQuery("DROP TABLE timeslipslistfilter");
      cvdl.executeUpdate();

View Full Code Here

        if (hm.get("actionid") != null)
        {
          int actionidd = ((Long)hm.get("actionid")).intValue();
          dl.setSql("projecttask.deletetaskalertaction");
          dl.setInt(1, actionidd);
          dl.executeUpdate();
          dl.clearParameters();
          dl.setSql("projecttask.deletetaskalert");
          dl.setInt(1, actionidd);
          dl.executeUpdate();
          dl.clearParameters();

View Full Code Here

    cvdl.executeUpdate();
    // throw away the temp filter table, if necessary.
    if (applyFilter) {
      cvdl.setSqlQueryToNull();
      cvdl.setSqlQuery("DROP TABLE timeslipslistfilter");
      cvdl.executeUpdate();
    }
    if (applyFilter || permissionSwitch) {
      cvdl.setSqlQueryToNull();
      cvdl.setSqlQuery("DROP TABLE listfilter");
      cvdl.executeUpdate();

View Full Code Here

          dl.setInt(1, actionidd);
          dl.executeUpdate();
          dl.clearParameters();
          dl.setSql("projecttask.deletetaskalert");
          dl.setInt(1, actionidd);
          dl.executeUpdate();
          dl.clearParameters();
        }
      }


      Vector customField = tvo.getCustomField();

View Full Code Here

      String filter = parameters.getFilter();
      
      if (filter != null && filter.length() > 0) {
        String str = "CREATE TABLE customviewlistfilter " + filter;
        cvdal.setSqlQuery(str);
        cvdal.executeUpdate();
        cvdal.setSqlQueryToNull();
        applyFilter = true;
      }
      int numberOfRecords = 0;
      if (applyFilter) {

View Full Code Here

      cvdal.setSqlQueryToNull();
      
      if (applyFilter){
        cvdal.setSqlQueryToNull();
        cvdal.setSqlQuery("DROP TABLE customviewlistfilter");
        cvdal.executeUpdate();
      }
      if (applyFilter || permissionSwitch) {
        cvdal.setSqlQueryToNull();
        cvdal.setSqlQuery("DROP TABLE listfilter");
        cvdal.executeUpdate();

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.