コード例 #1
0
  /**
   * returns display column name from the actual column name.
   *
   * @param aliasName String
   * @param columnName String
   * @return String
   * @throws DAOException
   */
  private String getColumnDisplayName(
      String childTableAliasName, String columnName, String parentTableAliasName)
      throws DAOException {
    String displayColumnName = null;
    try {
      JDBCDAO jdbcDao = (JDBCDAO) DAOFactory.getInstance().getDAO(Constants.JDBC_DAO);
      jdbcDao.openSession(null);
      Logger.out.debug("Alias Name : ............." + childTableAliasName);

      String sql =
          "SELECT sc.display_name, tab.alias_name FROM   "
              + "catissue_search_display_data sc, catissue_table_relation tr, "
              + "catissue_interface_column_data col, catissue_query_table_data tab, catissue_query_table_data maintab "
              + "WHERE  tr.relationship_id = sc.relationship_id AND "
              + "col.identifier = sc.col_id AND col.table_id = tab.table_id AND "
              + "maintab.table_id = tr.parent_table_id "
              + "AND maintab.alias_name = '"
              + parentTableAliasName
              + "' AND tab.alias_name='"
              + childTableAliasName
              + "' AND col.COLUMN_NAME='"
              + columnName
              + "'";

      Logger.out.debug("DATA ELEMENT SQL : " + sql);

      List list = jdbcDao.executeQuery(sql, null, false, null);
      String nameSql =
          "select DISPLAY_NAME from CATISSUE_QUERY_TABLE_DATA where ALIAS_NAME='"
              + parentTableAliasName
              + "'";
      List nameList = jdbcDao.executeQuery(nameSql, null, false, null);
      String tableDisplayName = new String();
      if (!nameList.isEmpty()) {
        List rowNameList = (List) nameList.get(0);
        tableDisplayName = (String) rowNameList.get(0);
      }
      Logger.out.debug("tableDisplayName in getviewelements:" + tableDisplayName);
      Logger.out.debug("list.size()************************" + list.size());
      Iterator iterator = list.iterator();
      int i = 0;
      while (iterator.hasNext()) {
        List rowList = (List) iterator.next();
        displayColumnName = (String) rowList.get(0) + " : " + tableDisplayName;
      }
      jdbcDao.closeSession();
    } catch (ClassNotFoundException classExp) {
      throw new DAOException(classExp.getMessage(), classExp);
    }
    return displayColumnName;
  }
コード例 #2
0
  /**
   * To get the aliasName corresponding to the tableName.
   *
   * @param tableName The name of the table.
   * @return The aliasName corresponding to the tableName.
   * @throws DAOException
   * @throws ClassNotFoundException
   */
  public String getAliasName(String tableName) throws DAOException, ClassNotFoundException {
    String aliasName = new String();
    JDBCDAO jdbcDAO = (JDBCDAO) DAOFactory.getInstance().getDAO(Constants.JDBC_DAO);
    jdbcDAO.openSession(null);
    String sql =
        "select ALIAS_NAME from CATISSUE_QUERY_TABLE_DATA where TABLE_NAME='" + tableName + "'";
    List list = jdbcDAO.executeQuery(sql, null, false, null);
    jdbcDAO.closeSession();

    if (!list.isEmpty()) {
      List rowList = (List) list.get(0);
      aliasName = (String) rowList.get(0);
    }
    return aliasName;
  }
コード例 #3
0
  /**
   * Returns the Vector of DataElement objects for the select clause of the query. And also list the
   * column names in the columnList list.
   *
   * @param aliasNameList The Set of the alias names for which the DataElements are to be created.
   * @param columnList List of column names to be shown in the spreadsheet view.
   * @param OnlyDefaultAttribute true if the required column should be Default view columns.
   * @return the Vector of DataElement objects for the select clause of the query.
   * @throws DAOException
   */
  public Vector getViewElements(List aliasNameList, List columnList, boolean OnlyDefaultAttribute)
      throws DAOException {
    Vector vector = new Vector();
    try {
      JDBCDAO jdbcDao = (JDBCDAO) DAOFactory.getInstance().getDAO(Constants.JDBC_DAO);
      jdbcDao.openSession(null);

      Iterator aliasNameIterator = aliasNameList.iterator();
      while (aliasNameIterator.hasNext()) {
        String aliasName = (String) aliasNameIterator.next();
        Logger.out.debug("Alias Name : ............." + aliasName);

        String sql =
            " SELECT tableData2.ALIAS_NAME, temp.COLUMN_NAME, temp.TABLES_IN_PATH, "
                + " temp.DISPLAY_NAME, temp.ATTRIBUTE_TYPE "
                + " from CATISSUE_QUERY_TABLE_DATA tableData2 join "
                + " ( SELECT  columnData.COLUMN_NAME, columnData.TABLE_ID, displayData.DISPLAY_NAME, "
                + " relationData.TABLES_IN_PATH, columnData.ATTRIBUTE_TYPE "
                + " FROM CATISSUE_INTERFACE_COLUMN_DATA columnData, "
                + " CATISSUE_TABLE_RELATION relationData, "
                + " CATISSUE_QUERY_TABLE_DATA tableData, "
                + " CATISSUE_SEARCH_DISPLAY_DATA displayData "
                + " where relationData.CHILD_TABLE_ID = columnData.TABLE_ID and "
                + " relationData.PARENT_TABLE_ID = tableData.TABLE_ID and "
                + " relationData.RELATIONSHIP_ID = displayData.RELATIONSHIP_ID and ";

        String defaultViewCondition = " displayData.DEFAULT_VIEW_ATTRIBUTE = 1 and ";

        String sql1 =
            " columnData.IDENTIFIER = displayData.COL_ID and "
                + " tableData.ALIAS_NAME = '"
                + aliasName
                + "') temp "
                + " on temp.TABLE_ID = tableData2.TABLE_ID";

        if (OnlyDefaultAttribute) sql = sql + defaultViewCondition + sql1;
        else sql = sql + sql1;

        Logger.out.debug("DATA ELEMENT SQL : " + sql);

        List list = jdbcDao.executeQuery(sql, null, false, null);
        String nameSql =
            "select DISPLAY_NAME from CATISSUE_QUERY_TABLE_DATA where ALIAS_NAME='"
                + aliasName
                + "'";
        List nameList = jdbcDao.executeQuery(nameSql, null, false, null);
        String tableDisplayName = new String();
        if (!nameList.isEmpty()) {
          List rowNameList = (List) nameList.get(0);
          tableDisplayName = (String) rowNameList.get(0);
        }
        Logger.out.debug("tableDisplayName in getviewelements:" + tableDisplayName);
        Logger.out.debug("list.size()************************" + list.size());
        String[] columnNames = new String[list.size()];
        Iterator iterator = list.iterator();
        int i = 0;
        while (iterator.hasNext()) {
          List rowList = (List) iterator.next();
          DataElement dataElement = new DataElement();
          dataElement.setTableName((String) rowList.get(0));
          String fieldName = (String) rowList.get(1);

          Logger.out.debug("fieldName*********************" + fieldName);
          dataElement.setField(fieldName + "." + (String) rowList.get(2));
          dataElement.setFieldType((String) rowList.get(4));
          vector.add(dataElement);
          columnList.add((String) rowList.get(3) + " : " + tableDisplayName);
        }
      }
      jdbcDao.closeSession();
    } catch (ClassNotFoundException classExp) {
      throw new DAOException(classExp.getMessage(), classExp);
    }
    return vector;
  }