📄 jdbccategorydataset.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><!--NewPage--><HTML><HEAD><!-- Generated by javadoc (build 1.5.0_07) on Fri Aug 25 15:15:38 BST 2006 --><TITLE>JDBCCategoryDataset (JFreeChart Class Library (version 1.0.2))</TITLE><META NAME="keywords" CONTENT="org.jfree.data.jdbc.JDBCCategoryDataset class"><LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style"><SCRIPT type="text/javascript">function windowTitle(){ parent.document.title="JDBCCategoryDataset (JFreeChart Class Library (version 1.0.2))";}</SCRIPT><NOSCRIPT></NOSCRIPT></HEAD><BODY BGCOLOR="white" onload="windowTitle();"><!-- ========= START OF TOP NAVBAR ======= --><A NAME="navbar_top"><!-- --></A><A HREF="#skip-navbar_top" 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_top_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> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/JDBCCategoryDataset.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../index-files/index-1.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> </TR></TABLE></TD><TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM></EM></TD></TR><TR><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> PREV CLASS <A HREF="../../../../org/jfree/data/jdbc/JDBCPieDataset.html" title="class in org.jfree.data.jdbc"><B>NEXT CLASS</B></A></FONT></TD><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../../index.html?org/jfree/data/jdbc/JDBCCategoryDataset.html" target="_top"><B>FRAMES</B></A> <A HREF="JDBCCategoryDataset.html" target="_top"><B>NO FRAMES</B></A> <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: NESTED | FIELD | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">DETAIL: FIELD | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD></TR></TABLE><A NAME="skip-navbar_top"></A><!-- ========= END OF TOP NAVBAR ========= --><HR><!-- ======== START OF CLASS DATA ======== --><H2><FONT SIZE="-1">org.jfree.data.jdbc</FONT><BR>Class JDBCCategoryDataset</H2><PRE>java.lang.Object <IMG SRC="../../../../resources/inherit.gif" ALT="extended by "><A HREF="../../../../org/jfree/data/general/AbstractDataset.html" title="class in org.jfree.data.general">org.jfree.data.general.AbstractDataset</A> <IMG SRC="../../../../resources/inherit.gif" ALT="extended by "><A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html" title="class in org.jfree.data.category">org.jfree.data.category.DefaultCategoryDataset</A> <IMG SRC="../../../../resources/inherit.gif" ALT="extended by "><B>org.jfree.data.jdbc.JDBCCategoryDataset</B></PRE><DL><DT><B>All Implemented Interfaces:</B> <DD>java.io.ObjectInputValidation, java.io.Serializable, java.lang.Cloneable, <A HREF="../../../../org/jfree/data/category/CategoryDataset.html" title="interface in org.jfree.data.category">CategoryDataset</A>, <A HREF="../../../../org/jfree/data/general/Dataset.html" title="interface in org.jfree.data.general">Dataset</A>, <A HREF="../../../../org/jfree/data/KeyedValues2D.html" title="interface in org.jfree.data">KeyedValues2D</A>, <A HREF="../../../../org/jfree/data/Values2D.html" title="interface in org.jfree.data">Values2D</A></DD></DL><HR><DL><DT><PRE>public class <A HREF="../../../../src-html/org/jfree/data/jdbc/JDBCCategoryDataset.html#line.93"><B>JDBCCategoryDataset</B></A><DT>extends <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html" title="class in org.jfree.data.category">DefaultCategoryDataset</A></DL></PRE><P>A <A HREF="../../../../org/jfree/data/category/CategoryDataset.html" title="interface in org.jfree.data.category"><CODE>CategoryDataset</CODE></A> implementation over a database JDBC result set. The dataset is populated via a call to <A HREF="../../../../org/jfree/data/jdbc/JDBCCategoryDataset.html#executeQuery(java.lang.String)"><CODE>executeQuery(String)</CODE></A> with the string SQL query. The SQL query must return at least two columns. The first column will be the category name and remaining columns values (each column represents a series). Subsequent calls to <A HREF="../../../../org/jfree/data/jdbc/JDBCCategoryDataset.html#executeQuery(java.lang.String)"><CODE>executeQuery(String)</CODE></A> will refresh the dataset. <p> The database connection is read-only and no write back facility exists. <p> NOTE: Many people have found this class too restrictive in general use. For the greatest flexibility, please consider writing your own code to read data from a <code>ResultSet</code> and populate a <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html" title="class in org.jfree.data.category"><CODE>DefaultCategoryDataset</CODE></A> directly.<P><P><DL><DT><B>See Also:</B><DD><A HREF="../../../../serialized-form.html#org.jfree.data.jdbc.JDBCCategoryDataset">Serialized Form</A></DL><HR><P><!-- ======== CONSTRUCTOR SUMMARY ======== --><A NAME="constructor_summary"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"><B>Constructor Summary</B></FONT></TH></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><B><A HREF="../../../../org/jfree/data/jdbc/JDBCCategoryDataset.html#JDBCCategoryDataset(java.sql.Connection)">JDBCCategoryDataset</A></B>(java.sql.Connection connection)</CODE><BR> Create a new dataset with the given database connection.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><B><A HREF="../../../../org/jfree/data/jdbc/JDBCCategoryDataset.html#JDBCCategoryDataset(java.sql.Connection, java.lang.String)">JDBCCategoryDataset</A></B>(java.sql.Connection connection, java.lang.String query)</CODE><BR> Creates a new dataset with the given database connection, and executes the supplied query to populate the dataset.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><B><A HREF="../../../../org/jfree/data/jdbc/JDBCCategoryDataset.html#JDBCCategoryDataset(java.lang.String, java.lang.String, java.lang.String, java.lang.String)">JDBCCategoryDataset</A></B>(java.lang.String url, java.lang.String driverName, java.lang.String user, java.lang.String passwd)</CODE><BR> Creates a new dataset with a database connection.</TD></TR></TABLE> <!-- ========== METHOD SUMMARY =========== --><A NAME="method_summary"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"><B>Method Summary</B></FONT></TH></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD><TD><CODE><B><A HREF="../../../../org/jfree/data/jdbc/JDBCCategoryDataset.html#executeQuery(java.sql.Connection, java.lang.String)">executeQuery</A></B>(java.sql.Connection con, java.lang.String query)</CODE><BR> Populates the dataset by executing the supplied query against the existing database connection.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD><TD><CODE><B><A HREF="../../../../org/jfree/data/jdbc/JDBCCategoryDataset.html#executeQuery(java.lang.String)">executeQuery</A></B>(java.lang.String query)</CODE><BR> Populates the dataset by executing the supplied query against the existing database connection.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> boolean</CODE></FONT></TD><TD><CODE><B><A HREF="../../../../org/jfree/data/jdbc/JDBCCategoryDataset.html#getTranspose()">getTranspose</A></B>()</CODE><BR> Returns a flag that controls whether or not the table values are transposed when added to the dataset.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD><TD><CODE><B><A HREF="../../../../org/jfree/data/jdbc/JDBCCategoryDataset.html#setTranspose(boolean)">setTranspose</A></B>(boolean transpose)</CODE><BR> Sets a flag that controls whether or not the table values are transposed when added to the dataset.</TD></TR></TABLE> <A NAME="methods_inherited_from_class_org.jfree.data.category.DefaultCategoryDataset"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor"><TH ALIGN="left"><B>Methods inherited from class org.jfree.data.category.<A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html" title="class in org.jfree.data.category">DefaultCategoryDataset</A></B></TH></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#addValue(double, java.lang.Comparable, java.lang.Comparable)">addValue</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#addValue(java.lang.Number, java.lang.Comparable, java.lang.Comparable)">addValue</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#clear()">clear</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#equals(java.lang.Object)">equals</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#getColumnCount()">getColumnCount</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#getColumnIndex(java.lang.Comparable)">getColumnIndex</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#getColumnKey(int)">getColumnKey</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#getColumnKeys()">getColumnKeys</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#getRowCount()">getRowCount</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#getRowIndex(java.lang.Comparable)">getRowIndex</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#getRowKey(int)">getRowKey</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#getRowKeys()">getRowKeys</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#getValue(java.lang.Comparable, java.lang.Comparable)">getValue</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#getValue(int, int)">getValue</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#hashCode()">hashCode</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#incrementValue(double, java.lang.Comparable, java.lang.Comparable)">incrementValue</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#removeColumn(java.lang.Comparable)">removeColumn</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#removeColumn(int)">removeColumn</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#removeRow(java.lang.Comparable)">removeRow</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#removeRow(int)">removeRow</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#removeValue(java.lang.Comparable, java.lang.Comparable)">removeValue</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#setValue(double, java.lang.Comparable, java.lang.Comparable)">setValue</A>, <A HREF="../../../../org/jfree/data/category/DefaultCategoryDataset.html#setValue(java.lang.Number, java.lang.Comparable, java.lang.Comparable)">setValue</A></CODE></TD></TR></TABLE> <A NAME="methods_inherited_from_class_org.jfree.data.general.AbstractDataset"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor"><TH ALIGN="left"><B>Methods inherited from class org.jfree.data.general.<A HREF="../../../../org/jfree/data/general/AbstractDataset.html" title="class in org.jfree.data.general">AbstractDataset</A></B></TH></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><A HREF="../../../../org/jfree/data/general/AbstractDataset.html#addChangeListener(org.jfree.data.general.DatasetChangeListener)">addChangeListener</A>, <A HREF="../../../../org/jfree/data/general/AbstractDataset.html#clone()">clone</A>, <A HREF="../../../../org/jfree/data/general/AbstractDataset.html#fireDatasetChanged()">fireDatasetChanged</A>, <A HREF="../../../../org/jfree/data/general/AbstractDataset.html#getGroup()">getGroup</A>, <A HREF="../../../../org/jfree/data/general/AbstractDataset.html#hasListener(java.util.EventListener)">hasListener</A>, <A HREF="../../../../org/jfree/data/general/AbstractDataset.html#notifyListeners(org.jfree.data.general.DatasetChangeEvent)">notifyListeners</A>, <A HREF="../../../../org/jfree/data/general/AbstractDataset.html#removeChangeListener(org.jfree.data.general.DatasetChangeListener)">removeChangeListener</A>, <A HREF="../../../../org/jfree/data/general/AbstractDataset.html#setGroup(org.jfree.data.general.DatasetGroup)">setGroup</A>, <A HREF="../../../../org/jfree/data/general/AbstractDataset.html#validateObject()">validateObject</A></CODE></TD></TR></TABLE> <A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -