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

com.centraview.common.CVDal.executeQuery()
Executes a Query (Select), and returns the data as a Collection of HashMaps HashMap contains field names as key and field data as value delegates to PreparedStatement's executeQuery

        if (!allRecords) {
          projectsList.setTotalNoOfRecords(projectsList.size());
        } else {
          int count = 0;
          cvdl.setSql("project.selectprojectcount");
          Collection col2 = cvdl.executeQuery();
          Iterator ite2 = col2.iterator();
          if (ite2.hasNext()) {
            HashMap hm2 = (HashMap)ite2.next();
            count = ((Integer)hm2.get("count(pr.projectid)")).intValue();

View Full Code Here

            + "left outer join activity on task.activityid = activity.activityid "
            + "WHERE timeslipsearch.timeslipid =  ts.timeslipid and tla.TimeSlipID=ts.TimeSlipID";


        cvdl.setSqlQueryToNull();
        cvdl.setSqlQuery(str);
        col = cvdl.executeQuery();


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

View Full Code Here

              + " , "
              + (endindex + 1) + ";";
          cvdl.setSqlQuery(str);
        }


        col = cvdl.executeQuery();


      }


      cvdl.setSqlQueryToNull();
      cvdl.clearParameters();

View Full Code Here

      Vector vec = null;


      if (pvo.getEntityID() != 0)
      {
        dl.setSqlQuery("select ModuleID from module where name='entity'");
        vec = (Vector)dl.executeQuery();


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

View Full Code Here

        if (!allRecords) {
          timeSlipList.setTotalNoOfRecords(timeSlipList.size());
        } else {
          int count = 0;
          cvdl.setSql("project.selecttimeslipcount");
          Collection col2 = cvdl.executeQuery();
          Iterator ite2 = col2.iterator();
          if (ite2.hasNext()) {
            HashMap hm2 = (HashMap)ite2.next();
            count = ((Integer)hm2.get("count(timeslipid)")).intValue();

View Full Code Here

      }


      if (pvo.getContactID() != 0)
      {
        dl.setSqlQuery("select ModuleID from module where name='Individual'");
        dl.executeQuery();
        vec = (Vector)dl.executeQuery();


        if (vec != null)
        {
          Number tempID = (Number) ((HashMap)vec.firstElement()).get("ModuleID");

View Full Code Here


      if (pvo.getContactID() != 0)
      {
        dl.setSqlQuery("select ModuleID from module where name='Individual'");
        dl.executeQuery();
        vec = (Vector)dl.executeQuery();


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

View Full Code Here


      int taskCount = 1;
      dl.setSql("projecttask.selecttaskcount");
      dl.setInt(1, tvo.getProjectID());


      Collection countCol = dl.executeQuery();
      Iterator itCount = countCol.iterator();


      if (itCount.hasNext())
      {
        HashMap hm = (HashMap)itCount.next();

View Full Code Here

          + "left outer join individual on ts.CreatedBy = individual.IndividualID left outer join task on ts.activityID = task.activityID left outer join activity on task.activityid = activity.activityid where ts.projectid = "
          + projectId + " " + sortStr;


      cvdl.setSqlQuery(strTs);


      col = cvdl.executeQuery();


      Iterator it = col.iterator();
      int i = 0;
      while (it.hasNext()) {
        i++;

View Full Code Here

      }


      if (pvo.getGroupID() != 0)
      {
        dl.setSqlQuery("select ModuleID from module where name='Group'");
        vec = (Vector)dl.executeQuery();
        if (vec != null)
        {
          Number tempID = (Number) ((HashMap)vec.firstElement()).get("ModuleID");
          recordTypeId = tempID.intValue();
        }

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.