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

            String fieldInfoString = "SELECT FieldName, "
              + "IsOnTable, RelationshipQuery, RealTableName "
              + "FROM searchfield WHERE SearchFieldID = ?";
            cvdal.setSqlQuery(fieldInfoString);
            cvdal.setInt(1, Integer.parseInt(searchCriteria.getFieldID()));
            Collection fieldResults = cvdal.executeQuery();
            cvdal.setSqlQueryToNull();
            if (fieldResults != null)
            {
              Iterator fieldIterator = fieldResults.iterator();
              if (fieldIterator.hasNext())

View Full Code Here

            } //end of else statement (thisTable.equals("methodofcontact"))...
          } // end else for if (searchCriteria.getTableID().equals(CUSTOM_FIELD_TABLEID))


          // built the query now get iterum results.
          cvdal.setSqlQuery(selectQuery.toString());
          Collection searchResults = cvdal.executeQuery();
          cvdal.setSqlQueryToNull();
          if (searchResults != null)
          {
            StringBuffer commaDelimitedIDs = new StringBuffer("");
            Iterator resultsIterator = searchResults.iterator();

View Full Code Here

      cvdl = new CVDal(dataSource);


      String str = "select mailFrom from emailmessage where MessageID in "+ allMailId + ";";
      cvdl.setSqlQueryToNull();
      cvdl.setSqlQuery(str);
      Collection col = cvdl.executeQuery();
      cvdl.clearParameters();


      Iterator iterator = col.iterator();
      while(iterator.hasNext())
      {

View Full Code Here

     //"select from emailstore where EmailFolder = ? and Messageid = ? ;");
        cvdl.setSql("email.selectemailstore");
          cvdl.setInt( 1, trashfolderid);
        cvdl.setInt( 2, mailId);


      Collection col = cvdl.executeQuery();
        cvdl.clearParameters();


      Iterator it = col.iterator();


      if (!(it.hasNext()))

View Full Code Here


      CVDal cvdl = new CVDal(dataSource);


      cvdl.setSql( "projecttimeslip.gettimeSlip" );
      cvdl.setInt( 1 , timeSlipId );
       Collection col = cvdl.executeQuery();
      Iterator ite = col.iterator();
      if (ite.hasNext())
      {
        HashMap hm = (HashMap)ite.next();
        tvo.setTimeSlipID(((Long)hm.get("timeslipid")).intValue());

View Full Code Here


      cvdl.setSqlQueryToNull();


      Number count = new Integer(0);
      cvdl.setSqlQuery("SELECT COUNT(*) AS count FROM literature");
      Collection results = (Collection)cvdl.executeQuery();
      if (results != null && results.size() > 0) {
        Iterator iter = results.iterator();
        while (iter.hasNext()) {
          HashMap row = (HashMap)iter.next();
          count = (Number)row.get("count");

View Full Code Here

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

View Full Code Here


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

View Full Code Here

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

View Full Code Here


      CVDal cvdl = new CVDal(dataSource);


      cvdl.setSql( "projecttimeslip.gettimeSlip" );
      cvdl.setInt( 1 , timeSlipId );
       Collection col = cvdl.executeQuery();
      Iterator ite = col.iterator();
      if (ite.hasNext())
      {
        HashMap hm = (HashMap)ite.next();
        tdbvo.setTimeSlipID(((Long)hm.get("timeslipid")).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.