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

com.centraview.common.CVDal.clearParameters()
Clears the value of all the parametrs set on the prepared statement. This should be used before firing more statemets on a single statement Delegates to PreparedStatement's clearParameters

      String otherWherClause = " (project.Owner = " + userID + " or project.Manager=" + userID
          + ")";
      CVUtility.getAllAccessibleRecords("Projects", "projectaccess", "project", "ProjectID",
          "Owner", otherWherClause, userID, cvdl);


      cvdl.clearParameters();


      if (sortmem.equals("Name"))
        sortmem = "projecttitle";
      else if (sortmem.equals("Entity"))
        sortmem = "EntityName";

View Full Code Here

      dl.setInt(9, userId);


      dl.executeUpdate();


      projectId = dl.getAutoGeneratedKey();
      dl.clearParameters();
  
    HashMap historyInfo = new HashMap();
    historyInfo.put("recordID",new Integer(projectId));
    historyInfo.put("recordTypeID", new Integer(Constants.ProjectModuleID));
    historyInfo.put("operation", new Integer(Constants.CREATED));

View Full Code Here


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


        String sortStr = "";
        if (sorttype == 'A') {
          sortStr = " order by " + sortmem + " ";
        } else {

View Full Code Here

        if (vec != null)
        {
          Number tempID = (Number) ((HashMap)vec.firstElement()).get("ModuleID");
          recordTypeId = tempID.intValue();
        }
        dl.clearParameters();


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

View Full Code Here

        if (vec != null)
        {
          Number tempID = (Number) ((HashMap)vec.firstElement()).get("ModuleID");
          recordTypeId = tempID.intValue();
        }
        dl.clearParameters();


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

View Full Code Here

        sb.setLength(11);
        String str = (new Integer(i)).toString();
        sb.replace((sb.length() - str.length()), (sb.length()), str);
        String newOrd = sb.toString();


        cvdl.clearParameters();
        if (!allRecords) {
          projectsList.setTotalNoOfRecords(projectsList.size());
        } else {
          int count = 0;
          cvdl.setSql("project.selectprojectcount");

View Full Code Here

        if (vec != null)
        {
          Number tempID = (Number) ((HashMap)vec.firstElement()).get("ModuleID");
          recordTypeId = tempID.intValue();
        }
        dl.clearParameters();


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

View Full Code Here

        projectsList.setBeginIndex(beginindex);
        projectsList.setEndIndex(endindex);


      }


      cvdl.clearParameters();


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

View Full Code Here


        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 "
            + "from timeslip ts, timeslipsearch, timeslipaccess tla "

View Full Code Here

      dl.setInt(8, userId);
      dl.setInt(9, projectId);


      dl.executeUpdate();


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


    HashMap historyInfo = new HashMap();

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.