jdbcdatabasemetadata.java

一个可以在applet窗体上持行sql语句并显示返回结果的程序

   * Is "ALTER TABLE" with add column supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsAlterTableWithAddColumn() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Is "ALTER TABLE" with drop column supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsAlterTableWithDropColumn() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Is column aliasing supported?
   *
   * <P>If so, the SQL AS clause can be used to provide names for
   * computed columns or to provide alias names for columns as
   * required.
   *
   * A JDBC Compliant<sup><font size=-2>TM</font></sup> driver
   * always returns true.
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsColumnAliasing() {
    if(Trace.TRACE) Trace.trace();
    return true;
    // InterBase (iscdrv32.dll) returns false
  }
  /**
   * Are concatenations between NULL and non-NULL values NULL?
   *
   * A JDBC Compliant<sup><font size=-2>TM</font></sup> driver always
   * returns true.
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean nullPlusNonNullIsNull() {
    if(Trace.TRACE) Trace.trace();
    return true;
    // Access (odbcjt32.dll) returns false
  }
  /**
   * Is the CONVERT function between SQL types supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsConvert() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * Is CONVERT between the given SQL types supported?
   * <P><font color="#009900">
   * In Hypersonic SQL, conversions are made over Strings, so
   * everything theoretically is possible.
   * </font><P>
   * @param fromType the type to convert from
   * @param toType the type to convert to
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsConvert(int fromType,int toType) {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * Are table correlation names supported?
   *
   * A JDBC Compliant<sup><font size=-2>TM</font></sup> driver
   * always returns true.
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsTableCorrelationNames() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * If table correlation names are supported, are they restricted
   * to be different from the names of the tables?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsDifferentTableCorrelationNames() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * Are expressions in "ORDER BY" lists supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsExpressionsInOrderBy() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * Can an "ORDER BY" clause use columns not in the SELECT statement?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsOrderByUnrelated() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * Is some form of "GROUP BY" clause supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsGroupBy() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * Can a "GROUP BY" clause use columns not in the SELECT?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsGroupByUnrelated() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * Can a "GROUP BY" clause add columns not in the SELECT
   * provided it specifies all the columns in the SELECT?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsGroupByBeyondSelect() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * Is the escape character in "LIKE" clauses supported?
   *
   * A JDBC Compliant<sup><font size=-2>TM</font></sup> driver
   * always returns true.
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsLikeEscapeClause() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * Are multiple ResultSets from a single execute supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsMultipleResultSets() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Can we have multiple transactions open at once (on different
   * connections)?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsMultipleTransactions() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * Can columns be defined as non-nullable?
   *
   * A JDBC Compliant<sup><font size=-2>TM</font></sup> driver
   * always returns true.
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsNonNullableColumns() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * Is the ODBC Minimum SQL grammar supported?
   *
   * All JDBC Compliant<sup><font size=-2>TM</font></sup> drivers
   * must return true.
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsMinimumSQLGrammar() {
    if(Trace.TRACE) Trace.trace();
    // todo
    return false;
  }
  /**
   * Is the ODBC Core SQL grammar supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsCoreSQLGrammar() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Is the ODBC Extended SQL grammar supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsExtendedSQLGrammar() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Is the ANSI92 entry level SQL grammar supported?
   *
   * All JDBC Compliant<sup><font size=-2>TM</font></sup> drivers must
   * return true.
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsANSI92EntryLevelSQL() {
    if(Trace.TRACE) Trace.trace();
    // todo
    return false;
  }
  /**
   * Is the ANSI92 intermediate SQL grammar supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsANSI92IntermediateSQL() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Is the ANSI92 full SQL grammar supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsANSI92FullSQL() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Is the SQL Integrity Enhancement Facility supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsIntegrityEnhancementFacility() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Is some form of outer join supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsOuterJoins() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * Are full nested outer joins supported?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsFullOuterJoins() {
    if(Trace.TRACE) Trace.trace();
    // todo
    return false;
  }
  /**
   * Is there limited support for outer joins?  (This will be true
   * if supportFullOuterJoins is true.)
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsLimitedOuterJoins() {
    if(Trace.TRACE) Trace.trace();
    return true;
  }
  /**
   * What's the database vendor's preferred term for "schema"?
   *
   * @return the vendor term
   */
  public String getSchemaTerm() {
    if(Trace.TRACE) Trace.trace();
    return "";
  }
  /**
   * What's the database vendor's preferred term for "procedure"?
   *
   * @return the vendor term
   */
  public String getProcedureTerm() {
    if(Trace.TRACE) Trace.trace();
    return "";
  }
  /**
   * What's the database vendor's preferred term for "catalog"?
   *
   * @return the vendor term
   */
  public String getCatalogTerm() {
    if(Trace.TRACE) Trace.trace();
    return "";
  }
  /**
   * Does a catalog appear at the start of a qualified table name?
   * (Otherwise it appears at the end)
   *
   * @return true if it appears at the start
   */
  public boolean isCatalogAtStart() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * What's the separator between catalog and table name?
   *
   * @return the separator string
   */
  public String getCatalogSeparator() {
    if(Trace.TRACE) Trace.trace();
    return "";
  }
  /**
   * Can a schema name be used in a data manipulation statement?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsSchemasInDataManipulation() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Can a schema name be used in a procedure call statement?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsSchemasInProcedureCalls() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Can a schema name be used in a table definition statement?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsSchemasInTableDefinitions() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Can a schema name be used in an index definition statement?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsSchemasInIndexDefinitions() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Can a schema name be used in a privilege definition statement?
   *
   * @return <code>true</code> if so; <code>false</code> otherwise
   */
  public boolean supportsSchemasInPrivilegeDefinitions() {
    if(Trace.TRACE) Trace.trace();
    return false;
  }
  /**
   * Can a catalog name be used in a data manipulation statement?