List of executeQueryNonParsed() Examples

Examples of executeQueryNonParsed()

com.centraview.common.CVDal.executeQueryNonParsed()
Executes a Query (Select), and returns the java.sql.ResultSet delegates to PreparedStatement's executeQuery Make sure to clean up your own ResultSets when you are done. @author Kevin McAllister @return java.sql.ResultSet or null if a SQLexception is thrown by executeQuery

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

        "AND emf.folderId = emmf.folderId AND emmf.messageId = em.messageId " +
        "AND em.messageId = ? and emmf.folderId = ?";
        cvdal.setSqlQuery(query);
        cvdal.setInt(1,messageId);
        cvdal.setInt(2,folderId);
        results = cvdal.executeQueryNonParsed();
      }else{
        String query = "SELECT ea.accountId, ea.serverType, emf.Name, emf.Ftype " +
        "FROM emailaccount AS ea, emailmessage AS em, " +
        "emailmessagefolder AS emmf, emailfolder AS emf " +
        "WHERE ea.accountId = em.accountId " +

View Full Code Here

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

        "WHERE ea.accountId = em.accountId " +
        "AND emf.folderId = emmf.folderId AND emmf.messageId = em.messageId " +
        "AND em.messageId = ?";
        cvdal.setSqlQuery(query);
        cvdal.setInt(1,messageId);
        results = cvdal.executeQueryNonParsed();
      }


      results.next(); // do it once, we should only have one result.
      accountId = new Integer(results.getInt(1));
      serverType = results.getString(2);

View Full Code Here

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

        cvdal.setSqlQueryToNull();
        try {results.close();} catch (Exception e) { }
        String query = "SELECT folderId FROM emailfolder WHERE name = 'Trash' AND ftype = 'SYSTEM' AND accountID = ?";
        cvdal.setSqlQuery(query);
        cvdal.setInt(1, accountId.intValue());
        results = cvdal.executeQueryNonParsed();
        results.next(); // do it once, we should only have one result.
        trashFolderId = new Integer(results.getInt(1));
        // now that we know where to move, it simply move it there
        operationResult = this.moveMessageToFolder(individualId, messageId, trashFolderId.intValue());
      }

View Full Code Here

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

    // Now the query is ready, lets fire up the data access layer.
    StringBuffer domainQueryIds = new StringBuffer("(");
    CVDal cvdal = new CVDal(this.dataSource);
    ArrayList domain = new ArrayList();
    cvdal.setSqlQuery(query.toString());
    ResultSet domainResultSet = cvdal.executeQueryNonParsed();
    // Do this non-parsed so on one pass through the resultset
    // we can build the hashmap for display, and get the ids
    // gathered up for the query.
    try
    {

View Full Code Here

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

      int fieldIndex = ((Integer)criterion.get(SearchCriteriaVO.FIELD_KEY)).intValue();
      MergeField field = (MergeField)fieldList.get(fieldIndex);
      StringBuffer fieldQuery = new StringBuffer(field.getQuery());
      fieldQuery.append(domainQueryIds);
      cvdal.setSqlQuery(fieldQuery.toString());
      ResultSet fieldResultSet = cvdal.executeQueryNonParsed();
      HashMap fieldMap = new HashMap();
      try
      {
        while(fieldResultSet.next())
        {

View Full Code Here

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

    CVDal dataAccessLayer = new CVDal(pk.getDataSource());
    ResultSet resultSet = null;
    try {
      dataAccessLayer.setSql("reports.findreportcontentbypk");
      dataAccessLayer.setInt(1, pk.reportContentId);
      resultSet = dataAccessLayer.executeQueryNonParsed();
      if (!resultSet.next()) {
        throw new ObjectNotFoundException("Primary key does not exist");
      }
      return pk;
    }

View Full Code Here

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

    CVDal dataAccessLayer = new CVDal(key.getDataSource());
    ResultSet resultSet = null;
    try {
      dataAccessLayer.setSql("reports.loadreportcontent");
      dataAccessLayer.setInt(1, reportContentId);
      resultSet = dataAccessLayer.executeQueryNonParsed();
      if (!resultSet.next()) {
        throw new NoSuchEntityException("ReportContent Row does not exist");
      }
      this.reportId = resultSet.getInt(1);
      this.fieldId = resultSet.getInt(2);

View Full Code Here

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

    Vector keys = new Vector();
    try {
      dataAccessLayer.setSql("reports.findreportcontentbyreport");
      
      dataAccessLayer.setInt(1, reportId);
      resultSet = dataAccessLayer.executeQueryNonParsed();


      while (resultSet.next()) {
        int reportContentId = resultSet.getInt(1);
        keys.addElement(new ReportContentPK(reportContentId,ds));
      }

View Full Code Here

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

    CVDal dataAccessLayer = new CVDal(key.dataSource);
    ResultSet resultSet = null;
    try {
      dataAccessLayer.setSqlQuery("SELECT reporttypename FROM reporttype WHERE reporttypeid = ?");
      dataAccessLayer.setInt(1, reportTypeId);
      resultSet = dataAccessLayer.executeQueryNonParsed();
      if (!resultSet.next()) {
        throw new NoSuchEntityException("Row does not exist");
      }
      this.reportTypeName = resultSet.getString(1);
      isModified = false;

View Full Code Here

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

    CVDal dataAccessLayer = new CVDal(pk.dataSource);
    ResultSet resultSet = null;
    try {
      dataAccessLayer.setSqlQuery("SELECT reporttypeid FROM reporttype WHERE reporttypeid = ?");
      dataAccessLayer.setInt(1, pk.reportTypeId);
      resultSet = dataAccessLayer.executeQueryNonParsed();
      if (!resultSet.next()) {
        throw new ObjectNotFoundException("Primary key does not exist");
      }
      return pk;
    }

View Full Code Here

0 1 2

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.