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()


      try {
        String query = getQueryForResultReport(userId, reportId, search, dataAccessLayer);


        dataAccessLayer.setSqlQuery(query);
        resultSet = dataAccessLayer.executeQueryNonParsed();
        ResultSetMetaData metaData = resultSet.getMetaData();
        int cols = metaData.getColumnCount();
        int i = 0;
        boolean exclude = false;
        boolean[] isDate = new boolean[cols + 1];

View Full Code Here

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

        // searchfield.searchfieldid=? and searchfield.searchtableid =
        // searchtable.searchtableid
        dataAccessLayer.setSql("reports.getfieldname");
      }
      dataAccessLayer.setInt(1, fieldId);
      resultSet = dataAccessLayer.executeQueryNonParsed();
      while (resultSet.next()) {
        name = resultSet.getString(1) + "." + resultSet.getString(3);
      }
    } catch (SQLException e) {
      logger.error("[Exception][ReportFacadeEJB.getFieldName] Exception Thrown: " + e);

View Full Code Here

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

      // from reportcontent, searchfield
      // where reportcontent.reportid = ? and
      // reportcontent.fieldid=searchfield.searchfieldid
      dataAccessLayer.setSql("reports.gettitles");
      dataAccessLayer.setInt(1, reportId);
      resultSet = dataAccessLayer.executeQueryNonParsed();
      String tableId = "";
      int fieldId;
      while (resultSet.next()) {
        tableId = resultSet.getString(2);
        fieldId = resultSet.getInt(3);

View Full Code Here

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

          try {
            cvdal.setSqlQuery("SELECT name FROM customfield WHERE customFieldId = ?");
            // the third thing returned on the result set is the fieldId
            // in this case the customfieldid, to get the name.
            cvdal.setInt(1, fieldId);
            customFieldNameRS = cvdal.executeQueryNonParsed();
            if (customFieldNameRS.next()) {
              titles.add(customFieldNameRS.getString(1));
            } else {
              titles.add("Result Column");
            }

View Full Code Here

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

    int tableId = 0;
    try {
      dataAccessLayer.setSql("reports.gettableid");


      dataAccessLayer.setInt(1, fieldId);
      resultSet = dataAccessLayer.executeQueryNonParsed();


      while (resultSet.next()) {


        tableId = resultSet.getInt(1);
      }

View Full Code Here

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


      dataAccessLayer.setSqlQuery("select searchtable.searchtableid, searchtable.tablename, "
          + " searchtable.displayname from reportmodule, searchtable " + " where searchtable.searchtableid=reportmodule.searchtableid "
          + " and reportmodule.moduleid=? ");
      dataAccessLayer.setInt(1, moduleId);
      resultSet = dataAccessLayer.executeQueryNonParsed();


      while (resultSet.next()) {
        tableId = resultSet.getInt(1);
        tableName = resultSet.getString(2);
        tableFullName = resultSet.getString(3);

View Full Code Here

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

    try {


      if (!String.valueOf(tableId).equals(SearchVO.CUSTOM_FIELD_TABLEID)) {
        dataAccessLayer.setSql("reports.getfields");
        dataAccessLayer.setInt(1, tableId);
        resultSet = dataAccessLayer.executeQueryNonParsed();
      } else {
        // we need to get the custom fields, first find the id for cvtable
        // based on the moduleId.
        Number cvTableId = null;
        String sqlString = "SELECT cv.tableid AS id FROM cvtable AS cv, module "

View Full Code Here

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

        // now get the list of Fields.
        sqlString = "SELECT customfieldid AS SearchFieldID, name AS DisplayName FROM customfield " + "WHERE recordtype = ?";
        dataAccessLayer.setSqlQueryToNull();
        dataAccessLayer.setSqlQuery(sqlString);
        dataAccessLayer.setInt(1, cvTableId.intValue());
        resultSet = dataAccessLayer.executeQueryNonParsed();
      }
      while (resultSet.next()) {
        fieldId = resultSet.getInt(1);
        fieldFullName = resultSet.getString(2);
        TheItem field = new TheItem(fieldId, fieldFullName);

View Full Code Here

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

    CVDal dataAccessLayer = new CVDal(this.dataSource);
    try {


      String sqlString = "SELECT count(*) FROM report";
      dataAccessLayer.setSqlQuery(sqlString);
      resultSet = dataAccessLayer.executeQueryNonParsed();
      while (resultSet.next()) {


        returnValue = resultSet.getLong(1);
      }

View Full Code Here

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

    CVDal dataAccessLayer = new CVDal(pk.dataSource);
    ResultSet resultSet = null;
    try {
      dataAccessLayer.setSql("reports.findreportbypk");
      dataAccessLayer.setInt(1, pk.reportId);
      resultSet = dataAccessLayer.executeQueryNonParsed();
      if (!resultSet.next()) {
        throw new ObjectNotFoundException("Cannot Find report: "+pk.toString());
      }
      return pk;
    } catch (SQLException e) {

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.