databasehandler.html

数据挖掘方面最新软件

public java.sql.Statement <B>createStatement</B>()
                                   throws java.sql.SQLException</PRE>
<DL>
<DD>Create a statement where result sets will have the properties 
  TYPE_SCROLL_SENSITIVE and CONCUR_UPDATABLE. This means that the
  ResultSet is scrollable and also updatable. It will also directly show 
  all changes to the database made by others after this ResultSet was obtained.
  Will throw an <CODE>SQLException</CODE> if the handler is not connected.
<P>
<DD><DL>

<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE></DL>
</DD>
</DL>
<HR>

<A NAME="createPreparedStatement(java.lang.String)"><!-- --></A><H3>
createPreparedStatement</H3>
<PRE>
public java.sql.PreparedStatement <B>createPreparedStatement</B>(java.lang.String&nbsp;sqlString)
                                                   throws java.sql.SQLException</PRE>
<DL>
<DD>Create a prepared statement where result sets will have the properties 
  TYPE_SCROLL_SENSITIVE and CONCUR_UPDATABLE. This means that the
  ResultSet is scrollable and also updatable. It will also directly show 
  all changes to the database made by others after this ResultSet was obtained.
  Will throw an <CODE>SQLException</CODE> if the handler is not connected.
<P>
<DD><DL>

<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE></DL>
</DD>
</DL>
<HR>

<A NAME="commit()"><!-- --></A><H3>
commit</H3>
<PRE>
public void <B>commit</B>()
            throws java.sql.SQLException</PRE>
<DL>
<DD>Makes all changes to the database permanent. Invoking this method explicit is
 usually not necessary if the connection was created with AUTO_COMMIT set to true.
<P>
<DD><DL>

<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE></DL>
</DD>
</DL>
<HR>

<A NAME="query(java.lang.String)"><!-- --></A><H3>
query</H3>
<PRE>
<FONT SIZE="-1">@Deprecated
</FONT>public java.sql.ResultSet <B>query</B>(java.lang.String&nbsp;sqlQuery)
                         throws java.sql.SQLException</PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I>Use the method <A HREF="../../../../com/rapidminer/tools/jdbc/DatabaseHandler.html#createStatement()"><CODE>createStatement()</CODE></A> instead and perform the queries explicitely since this method would not allow closing the statement</I>
<P>
<DD>Executes the given SQL-Query. Only SQL-statements starting with "SELECT"
 (disregarding case) will be accepted. Any errors will result in an
 SQL-Exception being thrown.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sqlQuery</CODE> - An SQL-String.
<DT><B>Returns:</B><DD>A ResultSet-Object with the results of the query. The ResultSet
         is scrollable, but not updatable. It will not show changes to
         the database made by others after this ResultSet was obtained.
<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE></DL>
</DD>
</DL>
<HR>

<A NAME="addColumn(com.rapidminer.example.Attribute, java.lang.String)"><!-- --></A><H3>
addColumn</H3>
<PRE>
public void <B>addColumn</B>(<A HREF="../../../../com/rapidminer/example/Attribute.html" title="interface in com.rapidminer.example">Attribute</A>&nbsp;attribute,
                      java.lang.String&nbsp;tableName)
               throws java.sql.SQLException</PRE>
<DL>
<DD>Adds a column for the given attribute to the table with name tableName.
<P>
<DD><DL>

<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE></DL>
</DD>
</DL>
<HR>

<A NAME="removeColumn(com.rapidminer.example.Attribute, java.lang.String)"><!-- --></A><H3>
removeColumn</H3>
<PRE>
public void <B>removeColumn</B>(<A HREF="../../../../com/rapidminer/example/Attribute.html" title="interface in com.rapidminer.example">Attribute</A>&nbsp;attribute,
                         java.lang.String&nbsp;tableName)
                  throws java.sql.SQLException</PRE>
<DL>
<DD>Removes the column of the given attribute from the table with name
 tableName.
<P>
<DD><DL>

<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE></DL>
</DD>
</DL>
<HR>

<A NAME="createTable(com.rapidminer.example.ExampleSet, java.lang.String, int)"><!-- --></A><H3>
createTable</H3>
<PRE>
public void <B>createTable</B>(<A HREF="../../../../com/rapidminer/example/ExampleSet.html" title="interface in com.rapidminer.example">ExampleSet</A>&nbsp;exampleSet,
                        java.lang.String&nbsp;tableName,
                        int&nbsp;overwriteMode)
                 throws java.sql.SQLException</PRE>
<DL>
<DD>Creates a new table in this connection and fills it with the provided data.
<P>
<DD><DL>

<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE> - if the table should be overwritten but a table with this name already exists</DL>
</DD>
</DL>
<HR>

<A NAME="countRecords(java.sql.ResultSet)"><!-- --></A><H3>
countRecords</H3>
<PRE>
public int <B>countRecords</B>(java.sql.ResultSet&nbsp;rs)
                 throws java.sql.SQLException</PRE>
<DL>
<DD>Counts the number of records in the given result set.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>rs</CODE> - the ResultSet.
<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE></DL>
</DD>
</DL>
<HR>

<A NAME="getRapidMinerTypeIndex(int)"><!-- --></A><H3>
getRapidMinerTypeIndex</H3>
<PRE>
public static int <B>getRapidMinerTypeIndex</B>(int&nbsp;sqlType)</PRE>
<DL>
<DD>Returns for the given SQL-type the name of the corresponding RapidMiner-Type
 from com.rapidminer.tools.Ontology.
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="createAttributes(java.sql.ResultSet)"><!-- --></A><H3>
createAttributes</H3>
<PRE>
public static java.util.List&lt;<A HREF="../../../../com/rapidminer/example/Attribute.html" title="interface in com.rapidminer.example">Attribute</A>&gt; <B>createAttributes</B>(java.sql.ResultSet&nbsp;rs)
                                                  throws java.sql.SQLException</PRE>
<DL>
<DD>Creates a list of attributes reflecting the result set's column meta
 data.
<P>
<DD><DL>

<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE></DL>
</DD>
</DL>
<HR>

<A NAME="getDatabaseName(com.rapidminer.example.Attribute)"><!-- --></A><H3>
getDatabaseName</H3>
<PRE>
<FONT SIZE="-1">@Deprecated
</FONT>public static java.lang.String <B>getDatabaseName</B>(<A HREF="../../../../com/rapidminer/example/Attribute.html" title="interface in com.rapidminer.example">Attribute</A>&nbsp;attribute)</PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I>Use the open and close quotes for identifiers from the properties instead</I>
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getAllTableMetaData()"><!-- --></A><H3>
getAllTableMetaData</H3>
<PRE>
public java.util.Map&lt;java.lang.String,java.util.List&lt;<A HREF="../../../../com/rapidminer/tools/jdbc/ColumnIdentifier.html" title="class in com.rapidminer.tools.jdbc">ColumnIdentifier</A>&gt;&gt; <B>getAllTableMetaData</B>()
                                                                                     throws java.sql.SQLException</PRE>
<DL>
<DD><DL>

<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE></DL>
</DD>
</DL>
<!-- ========= END OF CLASS DATA ========= -->
<HR>


<!-- ======= START OF BOTTOM NAVBAR ====== -->
<A NAME="navbar_bottom"><!-- --></A>
<A HREF="#skip-navbar_bottom" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_bottom_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="class-use/DatabaseHandler.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
<a href="http://sourceforge.net"><img src="http://sourceforge.net/sflogo.php?group_id=114160&amp;type=2" width="125" height="37" border="0" alt="SourceForge.net Logo" /></a></EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../../../com/rapidminer/tools/jdbc/ColumnIdentifier.html" title="class in com.rapidminer.tools.jdbc"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../../../com/rapidminer/tools/jdbc/DatabaseService.html" title="class in com.rapidminer.tools.jdbc"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../index.html?com/rapidminer/tools/jdbc/DatabaseHandler.html" target="_top"><B>FRAMES</B></A>  &nbsp;
&nbsp;<A HREF="DatabaseHandler.html" target="_top"><B>NO FRAMES</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="../../../../allclasses-noframe.html"><B>All Classes</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="../../../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>


</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
  SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;<A HREF="#field_summary">FIELD</A>&nbsp;|&nbsp;<A HREF="#constructor_summary">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;<A HREF="#field_detail">FIELD</A>&nbsp;|&nbsp;<A HREF="#constructor_detail">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_bottom"></A>
<!-- ======== END OF BOTTOM NAVBAR ======= -->

<HR>
<i>Copyright &#169; 2001-2008 by <a href="http://rapid-i.com" target="_blank">Rapid-I</a></i>
</BODY>
</HTML>