jdbcxydataset.html

JFreeChart 9.20的文档 需要用JAVA在网页上做统计图的东东

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the range of the values in this dataset's range (y-values).</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.Number</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../org/jfree/data/JDBCXYDataset.html#getXValue(int, int)">getXValue</A></B>(int&nbsp;seriesIndex,
          int&nbsp;itemIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the x-value for the specified series and item.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.Number</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../org/jfree/data/JDBCXYDataset.html#getYValue(int, int)">getYValue</A></B>(int&nbsp;seriesIndex,
          int&nbsp;itemIndex)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns the y-value for the specified series and item.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../org/jfree/data/JDBCXYDataset.html#isTimeSeries()">isTimeSeries</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns <code>true</code> if the dataset represents time series data, and <code>false</code>
 otherwise.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../org/jfree/data/JDBCXYDataset.html#setTimeSeries(boolean)">setTimeSeries</A></B>(boolean&nbsp;timeSeries)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sets a flag that indicates whether or not the data represents a time series.</TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_org.jfree.data.AbstractXYDataset"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD><B>Methods inherited from class org.jfree.data.<A HREF="../../../org/jfree/data/AbstractXYDataset.html" title="class in org.jfree.data">AbstractXYDataset</A></B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../org/jfree/data/AbstractXYDataset.html#getX(int, int)">getX</A>, <A HREF="../../../org/jfree/data/AbstractXYDataset.html#getY(int, int)">getY</A></CODE></TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_org.jfree.data.AbstractSeriesDataset"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD><B>Methods inherited from class org.jfree.data.<A HREF="../../../org/jfree/data/AbstractSeriesDataset.html" title="class in org.jfree.data">AbstractSeriesDataset</A></B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../org/jfree/data/AbstractSeriesDataset.html#seriesChanged(org.jfree.data.SeriesChangeEvent)">seriesChanged</A></CODE></TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_org.jfree.data.AbstractDataset"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD><B>Methods inherited from class org.jfree.data.<A HREF="../../../org/jfree/data/AbstractDataset.html" title="class in org.jfree.data">AbstractDataset</A></B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../org/jfree/data/AbstractDataset.html#addChangeListener(org.jfree.data.DatasetChangeListener)">addChangeListener</A>, <A HREF="../../../org/jfree/data/AbstractDataset.html#clone()">clone</A>, <A HREF="../../../org/jfree/data/AbstractDataset.html#fireDatasetChanged()">fireDatasetChanged</A>, <A HREF="../../../org/jfree/data/AbstractDataset.html#getGroup()">getGroup</A>, <A HREF="../../../org/jfree/data/AbstractDataset.html#notifyListeners(org.jfree.data.DatasetChangeEvent)">notifyListeners</A>, <A HREF="../../../org/jfree/data/AbstractDataset.html#removeChangeListener(org.jfree.data.DatasetChangeListener)">removeChangeListener</A>, <A HREF="../../../org/jfree/data/AbstractDataset.html#setGroup(org.jfree.data.DatasetGroup)">setGroup</A>, <A HREF="../../../org/jfree/data/AbstractDataset.html#validateObject()">validateObject</A></CODE></TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD><B>Methods inherited from class java.lang.Object</B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE>equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</CODE></TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_org.jfree.data.XYDataset"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD><B>Methods inherited from interface org.jfree.data.<A HREF="../../../org/jfree/data/XYDataset.html" title="interface in org.jfree.data">XYDataset</A></B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../org/jfree/data/XYDataset.html#getX(int, int)">getX</A>, <A HREF="../../../org/jfree/data/XYDataset.html#getY(int, int)">getY</A></CODE></TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_org.jfree.data.Dataset"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD><B>Methods inherited from interface org.jfree.data.<A HREF="../../../org/jfree/data/Dataset.html" title="interface in org.jfree.data">Dataset</A></B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../org/jfree/data/Dataset.html#addChangeListener(org.jfree.data.DatasetChangeListener)">addChangeListener</A>, <A HREF="../../../org/jfree/data/Dataset.html#getGroup()">getGroup</A>, <A HREF="../../../org/jfree/data/Dataset.html#removeChangeListener(org.jfree.data.DatasetChangeListener)">removeChangeListener</A>, <A HREF="../../../org/jfree/data/Dataset.html#setGroup(org.jfree.data.DatasetGroup)">setGroup</A></CODE></TD>
</TR>
</TABLE>
&nbsp;
<P>

<!-- ============ FIELD DETAIL =========== -->


<!-- ========= CONSTRUCTOR DETAIL ======== -->

<A NAME="constructor_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Constructor Detail</B></FONT></TD>
</TR>
</TABLE>

<A NAME="JDBCXYDataset(java.lang.String, java.lang.String, java.lang.String, java.lang.String)"><!-- --></A><H3>
JDBCXYDataset</H3>
<PRE>
public <B>JDBCXYDataset</B>(java.lang.String&nbsp;url,
                     java.lang.String&nbsp;driverName,
                     java.lang.String&nbsp;user,
                     java.lang.String&nbsp;password)
              throws java.sql.SQLException,
                     java.lang.ClassNotFoundException</PRE>
<DL>
<DD>Creates a new dataset (initially empty) and establishes a new database connection.
<P>
<DT><B>Parameters:</B><DD><CODE>url</CODE> - URL of the database connection.<DD><CODE>driverName</CODE> - the database driver class name.<DD><CODE>user</CODE> - the database user.<DD><CODE>password</CODE> - the database user's password.
<DT><B>Throws:</B>
<DD><CODE>java.lang.ClassNotFoundException</CODE> - if the driver cannot be found.
<DD><CODE>java.sql.SQLException</CODE> - if there is a problem connecting to the database.</DL>
<HR>

<A NAME="JDBCXYDataset(java.sql.Connection)"><!-- --></A><H3>
JDBCXYDataset</H3>
<PRE>
public <B>JDBCXYDataset</B>(java.sql.Connection&nbsp;con)
              throws java.sql.SQLException</PRE>
<DL>
<DD>Creates a new dataset (initially empty) using the specified database connection.
<P>
<DT><B>Parameters:</B><DD><CODE>con</CODE> - the database connection.
<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE> - if there is a problem connecting to the database.</DL>
<HR>

<A NAME="JDBCXYDataset(java.sql.Connection, java.lang.String)"><!-- --></A><H3>
JDBCXYDataset</H3>
<PRE>
public <B>JDBCXYDataset</B>(java.sql.Connection&nbsp;con,
                     java.lang.String&nbsp;query)
              throws java.sql.SQLException</PRE>
<DL>
<DD>Creates a new dataset using the specified database connection, and populates it
 using data obtained with the supplied query.
<P>
<DT><B>Parameters:</B><DD><CODE>con</CODE> - the connection.<DD><CODE>query</CODE> - the SQL query.
<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE> - if there is a problem executing the query.</DL>

<!-- ============ METHOD DETAIL ========== -->

<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Method Detail</B></FONT></TD>
</TR>
</TABLE>

<A NAME="isTimeSeries()"><!-- --></A><H3>
isTimeSeries</H3>
<PRE>
public boolean <B>isTimeSeries</B>()</PRE>
<DL>
<DD>Returns <code>true</code> if the dataset represents time series data, and <code>false</code>
 otherwise.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>a boolean.</DL>
</DD>
</DL>
<HR>

<A NAME="setTimeSeries(boolean)"><!-- --></A><H3>
setTimeSeries</H3>
<PRE>
public void <B>setTimeSeries</B>(boolean&nbsp;timeSeries)</PRE>
<DL>
<DD>Sets a flag that indicates whether or not the data represents a time series.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>timeSeries</CODE> - the new value of the flag.</DL>
</DD>
</DL>
<HR>

<A NAME="executeQuery(java.lang.String)"><!-- --></A><H3>
executeQuery</H3>
<PRE>
public void <B>executeQuery</B>(java.lang.String&nbsp;query)
                  throws java.sql.SQLException</PRE>
<DL>
<DD>ExecuteQuery will attempt execute the query passed to it against the
 existing database connection.  If no connection exists then no action
 is taken.

 The results from the query are extracted and cached locally, thus
 applying an upper limit on how many rows can be retrieved successfully.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>query</CODE> - the query to be executed.
<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE> - if there is a problem executing the query.</DL>
</DD>
</DL>
<HR>

<A NAME="executeQuery(java.sql.Connection, java.lang.String)"><!-- --></A><H3>
executeQuery</H3>
<PRE>
public void <B>executeQuery</B>(java.sql.Connection&nbsp;con,
                         java.lang.String&nbsp;query)
                  throws java.sql.SQLException</PRE>
<DL>
<DD>ExecuteQuery will attempt execute the query passed to it against the
 provided database connection.  If connection is null then no action is taken

 The results from the query are extracted and cached locally, thus
 applying an upper limit on how many rows can be retrieved successfully.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>query</CODE> - the query to be executed.<DD><CODE>con</CODE> - the connection the query is to be executed against.
<DT><B>Throws:</B>
<DD><CODE>java.sql.SQLException</CODE> - if there is a problem executing the query.</DL>
</DD>
</DL>
<HR>

<A NAME="getXValue(int, int)"><!-- --></A><H3>
getXValue</H3>
<PRE>
public java.lang.Number <B>getXValue</B>(int&nbsp;seriesIndex,
                                  int&nbsp;itemIndex)</PRE>
<DL>
<DD>Returns the x-value for the specified series and item.  The
 implementation is responsible for ensuring that the x-values are
 presented in ascending order.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../org/jfree/data/XYDataset.html#getXValue(int, int)">getXValue</A></CODE> in interface <CODE><A HREF="../../../org/jfree/data/XYDataset.html" title="interface in org.jfree.data">XYDataset</A></CODE></DL>
</DD>