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

       cvdl.clearParameters();
      if (tdbvo.getProjectID() !=0 )
      {
        cvdl.setSql("projecttimeslip.getprojecttimeSlip");
        cvdl.setInt(1, tdbvo.getProjectID());
        col = cvdl.executeQuery();
        ite = col.iterator();
        if(ite.hasNext())
        {
          HashMap hm = (HashMap)ite.next();
          tdbvo.setProjectTitle((String)hm.get("projecttitle"));

View Full Code Here


      if (tdbvo.getTaskID() !=0 )
      {
        cvdl.setSql("projecttimeslip.getactivitytimeSlip");
        cvdl.setInt(1, tdbvo.getTaskID());
        col = cvdl.executeQuery();
        ite = col.iterator();
        if(ite.hasNext())
        {
          HashMap hm = (HashMap)ite.next();
          tdbvo.setTaskTitle((String)hm.get("title"));

View Full Code Here

        cvdl.clearParameters();
      }
      if (tdbvo.getTicketID() !=0 )
      {
        cvdl.setSqlQuery("select subject from ticket where ticketid ="+tdbvo.getTicketID());
        col = cvdl.executeQuery();
        ite = col.iterator();
        if(ite.hasNext())
        {
          HashMap hm = (HashMap)ite.next();
          tdbvo.setTicket((String)hm.get("subject"));

View Full Code Here

    {


      CVDal cvdl = new CVDal(dataSource);
      cvdl.setSql( "projecttimeslip.selecttimeSlip" );
      cvdl.setInt( 1 , timeSlipId );
       Collection col = cvdl.executeQuery();
      Iterator ite = col.iterator();
      if (ite.hasNext())
      {
        HashMap hm = (HashMap)ite.next();

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

          // we filter over entity id
          str = "select pr.ProjectID, pr.ProjectTitle, pr.Description, pr.Status, pr.Start, pr.End, pr.EntityID, pr.EntityName from projectlist as pr, projectsearch WHERE pr.projectid = projectsearch.projectid and pr.EntityID="
              + entityID + sortStr;
        cvdl.setSqlQueryToNull();
        cvdl.setSqlQuery(str);
        col = cvdl.executeQuery();


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

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

          str = str + appendStr + " order by " + sortmem + " desc limit " + (beginindex - 1)
              + " , " + (endindex + 1) + ";";
          cvdl.setSqlQuery(str);
        }


        col = cvdl.executeQuery();


      }


      cvdl.setSql("project.deleteprojectlist");
      cvdl.executeUpdate();

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.