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.setSql("project.addcustomfieldscalar");
            dl.setInt(1, cvo.getFieldID());
            dl.setInt(2, projectId);
            dl.setString(3, cvo.getValue());
            dl.executeUpdate();
          }
        }
      }
      dl.destroy();
    }catch (Exception e){

View Full Code Here

    String query = this.buildTaskListQuery(applyFilter, individualId, cvdl, parameters);
    cvdl.setSqlQuery(query);
    list = cvdl.executeQueryList(1);
    cvdl.setSqlQueryToNull();
    cvdl.setSqlQuery("DROP TABLE alltasklist");
    cvdl.executeUpdate();


    if (applyFilter) {
      cvdl.setSqlQueryToNull();
      cvdl.setSqlQuery("DROP TABLE tasklistfilter");
      cvdl.executeUpdate();

View Full Code Here

    cvdl.executeUpdate();


    if (applyFilter) {
      cvdl.setSqlQueryToNull();
      cvdl.setSqlQuery("DROP TABLE tasklistfilter");
      cvdl.executeUpdate();
    }


    cvdl.destroy();
    cvdl = null;
    return new ValueListVO(list, parameters);

View Full Code Here

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

View Full Code Here

          "ProjectID", "owner", null, permissionSwitch);
    }
    parameters.setTotalRecords(numberOfRecords);
    String query = this.buildProjectListQuery(applyFilter, permissionSwitch, parameters);
    cvdl.setSqlQuery(query);
    cvdl.executeUpdate();
    cvdl.setSqlQueryToNull();


    cvdl
        .setSqlQuery("UPDATE projectlist, projectlink, entity SET projectlist.EntityID =  projectlink.recordid , projectlist.Entity = entity.name WHERE entity.entityid = projectlink.recordid and projectlink.projectid = projectlist.projectid and projectlink.recordtypeid = 14;");
    cvdl.executeUpdate();

View Full Code Here

    cvdl.executeUpdate();
    cvdl.setSqlQueryToNull();


    cvdl
        .setSqlQuery("UPDATE projectlist, projectlink, entity SET projectlist.EntityID =  projectlink.recordid , projectlist.Entity = entity.name WHERE entity.entityid = projectlink.recordid and projectlink.projectid = projectlist.projectid and projectlink.recordtypeid = 14;");
    cvdl.executeUpdate();
    cvdl.setSqlQueryToNull();


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

View Full Code Here


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

View Full Code Here

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

View Full Code Here

      dl.setInt(1, tvo.getProjectID());
      dl.setInt(2, tvo.getParentID());
      dl.setString(3, tvo.getIsMileStone());
      dl.setInt(4, tvo.getPercentComplete());
      dl.setInt(5, tvo.getActivityID());
      dl.executeUpdate();
      dl.clearParameters();


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

View Full Code Here

      cvdl.executeUpdate();
    }
    if (applyFilter || permissionSwitch) {
      cvdl.setSqlQueryToNull();
      cvdl.setSqlQuery("DROP TABLE listfilter");
      cvdl.executeUpdate();
    }
    cvdl.destroy();
    cvdl = null;
    return new ValueListVO(list, parameters);
  }

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.