程序包 weka.experiment

类 InstanceQuery

java.lang.Object
weka.experiment.DatabaseUtils
weka.experiment.InstanceQuery
所有已实现的接口:
Serializable, OptionHandler, RevisionHandler

public class InstanceQuery extends DatabaseUtils implements OptionHandler
Convert the results of a database query into instances. The jdbc driver and database to be used default to "jdbc.idbDriver" and "jdbc:idb=experiments.prp". These may be changed by creating a java properties file called DatabaseUtils.props in user.home or the current directory. eg:

 jdbcDriver=jdbc.idbDriver
 jdbcURL=jdbc:idb=experiments.prp
 

Command line use just outputs the instances to System.out.

Valid options are:

 -Q <query>
  SQL query to execute.
 
 -S
  Return sparse rather than normal instances.
 
 -U <username>
  The username to use for connecting.
 
 -P <password>
  The password to use for connecting.
 
 -D
  Enables debug output.
 
版本:
$Revision: 11887 $
作者:
Len Trigg (trigg@cs.waikato.ac.nz)
另请参阅:
  • 构造器详细资料

    • InstanceQuery

      public InstanceQuery() throws Exception
      Sets up the database drivers
      抛出:
      Exception - if an error occurs
  • 方法详细资料

    • listOptions

      public Enumeration listOptions()
      Returns an enumeration describing the available options

      指定者:
      listOptions 在接口中 OptionHandler
      返回:
      an enumeration of all options
    • setOptions

      public void setOptions(String[] options) throws Exception
      Parses a given list of options. Valid options are:

       -Q <query>
        SQL query to execute.
       
       -S
        Return sparse rather than normal instances.
       
       -U <username>
        The username to use for connecting.
       
       -P <password>
        The password to use for connecting.
       
       -D
        Enables debug output.
       
      指定者:
      setOptions 在接口中 OptionHandler
      参数:
      options - the list of options as an array of strings
      抛出:
      Exception - if an option is not supported
    • queryTipText

      public String queryTipText()
      Returns the tip text for this property
      返回:
      tip text for this property suitable for displaying in the explorer/experimenter gui
    • setQuery

      public void setQuery(String q)
      Set the query to execute against the database
      参数:
      q - the query to execute
    • getQuery

      public String getQuery()
      Get the query to execute against the database
      返回:
      the query
    • sparseDataTipText

      public String sparseDataTipText()
      Returns the tip text for this property
      返回:
      tip text for this property suitable for displaying in the explorer/experimenter gui
    • setSparseData

      public void setSparseData(boolean s)
      Sets whether data should be encoded as sparse instances
      参数:
      s - true if data should be encoded as a set of sparse instances
    • getSparseData

      public boolean getSparseData()
      Gets whether data is to be returned as a set of sparse instances
      返回:
      true if data is to be encoded as sparse instances
    • getOptions

      public String[] getOptions()
      Gets the current settings of InstanceQuery
      指定者:
      getOptions 在接口中 OptionHandler
      返回:
      an array of strings suitable for passing to setOptions()
    • retrieveInstances

      public Instances retrieveInstances() throws Exception
      Makes a database query using the query set through the -Q option to convert a table into a set of instances
      返回:
      the instances contained in the result of the query
      抛出:
      Exception - if an error occurs
    • retrieveInstances

      public Instances retrieveInstances(String query) throws Exception
      Makes a database query to convert a table into a set of instances
      参数:
      query - the query to convert to instances
      返回:
      the instances contained in the result of the query, NULL if the SQL query doesn't return a ResultSet, e.g., DELETE/INSERT/UPDATE
      抛出:
      Exception - if an error occurs
    • main

      public static void main(String[] args)
      Test the class from the command line. The instance query should be specified with -Q sql_query
      参数:
      args - contains options for the instance query
    • getRevision

      public String getRevision()
      Returns the revision string.
      指定者:
      getRevision 在接口中 RevisionHandler
      覆盖:
      getRevision 在类中 DatabaseUtils
      返回:
      the revision