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

    CVDal dl = new CVDal(this.dataSource);
    Collection col = null;
    try {
      dl.setSql("project.getprojectstatuslist");
      col = dl.executeQuery();
      dl.clearParameters();
    } finally {
      dl.destroy();
    }
    return fillProjectStatusList(col);
  }

View Full Code Here

  {
     CVDal dl = new CVDal(this.dataSource);
     //ALLSQL.put("project.getprojectstatuslist", "select title from projectstatus");
     dl.setSql("project.getprojectstatuslist");
     Collection col = dl.executeQuery();
     dl.clearParameters();
       dl.destroy();
     return fillProjectStatusList(col);
  }


  /**

View Full Code Here

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


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

View Full Code Here

    if (ite.hasNext())
    {
      HashMap hm = (HashMap)ite.next();
      pvo.setModifierName((String)hm.get("CONCAT(firstname,' ',lastname)"));
    }
    cvdl.clearParameters();


    cvdl.setSql("project.getprojectentitylink");
    cvdl.setInt(1, projectId);
    col = cvdl.executeQuery();
    ite = col.iterator();

View Full Code Here

            dl.setSql("common.updateCustomFieldScalar");
            dl.setString(1, cvo.getValue());
            dl.setInt(2, cvo.getFieldID());
            dl.setInt(3, tvo.getActivityID());
            dl.executeUpdate();
            dl.clearParameters();
          }
        }
      }


      Collection actions = tvo.getActivityAction();

View Full Code Here

      HashMap hm = (HashMap)ite.next();
      pvo.setEntityID(((Long)hm.get("entityid")).intValue());
      pvo.setEntityName((String)hm.get("name"));
    }


    cvdl.clearParameters();


    cvdl.setSql("project.getprojectindividuallink");
    cvdl.setInt(1, projectId);
    col = cvdl.executeQuery();
    ite = col.iterator();

View Full Code Here

          dl.setString(2, message);
          dl.executeUpdate();


          String individualIDs = "";
          int actionId = dl.getAutoGeneratedKey();
          dl.clearParameters();
          ArrayList recipients = action.getRecipient();
          if (recipients != null)
          {
            Iterator it1 = recipients.iterator();
            while (it1.hasNext())

View Full Code Here

      HashMap hm = (HashMap)ite.next();
      pvo.setContactID(((Long)hm.get("individualid")).intValue());
      pvo.setContactName((String)hm.get("CONCAT(firstname , ' ' , lastname)"));
    }


    cvdl.clearParameters();


    cvdl.setSql("project.getprojectgrouplink");
    cvdl.setInt(1, projectId);
    col = cvdl.executeQuery();
    ite = col.iterator();

View Full Code Here

              dl.setSql("projecttask.addtaskalert");
              dl.setInt(1, tvo.getActivityID());
              dl.setInt(2, actionId);
              dl.setInt(3, individualID);
              dl.executeUpdate();
              dl.clearParameters();
              individualIDs += individualID + ",";
            }
          }


          if (individualIDs != null && individualIDs.endsWith(","))

View Full Code Here

      HashMap hm = (HashMap)ite.next();
      pvo.setGroupID(((Long)hm.get("groupid")).intValue());
      pvo.setGroupName((String)hm.get("name"));
    }


    cvdl.clearParameters();


    cvdl.setSql("project.projecthoursused");
    cvdl.setInt(1, projectId);
    col = cvdl.executeQuery();
    ite = 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.