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

      }


      dl.setSql("projecttask.selecttaskaction");
      dl.setInt(1, tvo.getActivityID());
      Collection countCol = dl.executeQuery();
      dl.clearParameters();
      Iterator itCount = countCol.iterator();
      while (itCount.hasNext())
      {
        HashMap hm = (HashMap)itCount.next();
        if (hm.get("actionid") != null)

View Full Code Here

        pvo.setModified((Timestamp)project.get("Modified"));
      if (project.get("Created") != null)
        pvo.setCreated((Timestamp)project.get("Created"));
    }


    cvdl.clearParameters();
    cvdl.setSql("project.getindname");
    cvdl.setInt(1, pvo.getCreator());
    col = cvdl.executeQuery();
    ite = col.iterator();
    if (ite.hasNext())

View Full Code Here

        {
          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

    {
      HashMap hm = (HashMap)ite.next();
      pvo.setCreatorName((String)hm.get("CONCAT(firstname,' ',lastname)"));
    }


    cvdl.clearParameters();


    cvdl.setSql("project.getindname");
    cvdl.setInt(1, pvo.getModifiedBy());
    col = cvdl.executeQuery();
    ite = col.iterator();

View Full Code Here

      list = cvdal.executeQueryList(1);
      cvdal.setSqlQueryToNull();


      cvdal.setSqlQuery("SELECT count(*) AS NoOfRecords FROM garbagelist");
      Collection colList = cvdal.executeQuery();
      cvdal.clearParameters();
      cvdal.setSqlQueryToNull();


    if (colList != null)
    {
     Iterator it = colList.iterator();

View Full Code Here

      }
      } //end of while statement (resultsIterator.hasNext())
    } //end of if statement (resultsCollection != null)


    cvdal.setSqlQueryToNull();
    cvdal.clearParameters();
    sqlQuery = "SELECT SearchTableID,SearchFieldID,DisplayName,FieldType " +
      " FROM searchfield WHERE SearchTableID in ("+tableIDs.toString()+")  and IsGlobalReplaceField ='Y'";
    cvdal.setSqlQuery(sqlQuery);
    Collection fieldCollections = cvdal.executeQuery();
    if (fieldCollections != null)

View Full Code Here


    // If we found the tableId for the customfield associated to the selected table.
    // We must have to get all the fields associated to the table.
    if(flagCustomFields){
      cvdal.setSqlQueryToNull();
      cvdal.clearParameters();


      sqlQuery = "SELECT CustomFieldID , Name, FieldType FROM" +
             " customfield where RecordType = ?;";
      cvdal.setSqlQuery(sqlQuery);
      cvdal.setInt(1,replaceTableID);

View Full Code Here


    //Get the Primary Table for this module.
    String mainTableQuery = "SELECT TablePrimaryKey,  TableName FROM "+
          "searchtable where SearchTableID = ?";
    cvdal.setSqlQueryToNull();
    cvdal.clearParameters();
    cvdal.setSqlQuery(mainTableQuery);
    cvdal.setInt(1, primaryTableID.intValue());
    Collection mainTableResults = cvdal.executeQuery();
    cvdal.setSqlQueryToNull();
    if (mainTableResults != null)

View Full Code Here

    //Get the Primary Table for this module.
    mainTableQuery = "SELECT sf.RealFieldName, sf.SearchTableID , sf.DisplayName , st.TableName, sf.RelationshipQuery, " +
          " sf.IsOnGlobalReplaceTable, sf.RealTableName, sf.SubRelationshipQuery FROM searchtable st,searchfield sf where sf.SearchTableID "+
          " = st.SearchTableID and sf.searchFieldID = ?";
    cvdal.setSqlQueryToNull();
    cvdal.clearParameters();
    cvdal.setSqlQuery(mainTableQuery);
    cvdal.setInt(1, replaceFieldID);
    mainTableResults = cvdal.executeQuery();
    cvdal.setSqlQueryToNull();
    if (mainTableResults != null)

View Full Code Here

    CVDal cvdal = new CVDal(this.dataSource);


    try {
      cvdal.setSqlQuery("SELECT EmailAccountID AS accountID FROM supportemailaccount");
      Collection results = cvdal.executeQuery();
      cvdal.clearParameters();
      cvdal.setSqlQueryToNull();
      if (results != null && results.size() > 0) {
        Iterator iter = results.iterator();
        while (iter.hasNext()) {
          HashMap row = (HashMap)iter.next();

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.