📄 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.4.2_03) on Mon Jun 07 16:42:23 BST 2004 --><TITLE>JDBCCategoryDataset (JFreeChart Class Library (version 0.9.20))</TITLE><META NAME="keywords" CONTENT="org.jfree.data.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 0.9.20))";}</SCRIPT></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=3 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="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-all.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"> <A HREF="../../../org/jfree/data/DefaultWindDataset.html" title="class in org.jfree.data"><B>PREV CLASS</B></A> <A HREF="../../../org/jfree/data/JDBCPieDataset.html" title="class in org.jfree.data"><B>NEXT CLASS</B></A></FONT></TD><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../index.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</FONT><BR>Class JDBCCategoryDataset</H2><PRE>java.lang.Object <IMG SRC="../../../resources/inherit.gif" ALT="extended by"><A HREF="../../../org/jfree/data/AbstractDataset.html" title="class in org.jfree.data">org.jfree.data.AbstractDataset</A> <IMG SRC="../../../resources/inherit.gif" ALT="extended by"><A HREF="../../../org/jfree/data/DefaultCategoryDataset.html" title="class in org.jfree.data">org.jfree.data.DefaultCategoryDataset</A> <IMG SRC="../../../resources/inherit.gif" ALT="extended by"><B>org.jfree.data.JDBCCategoryDataset</B></PRE><DL><DT><B>All Implemented Interfaces:</B> <DD><A HREF="../../../org/jfree/data/CategoryDataset.html" title="interface in org.jfree.data">CategoryDataset</A>, java.lang.Cloneable, <A HREF="../../../org/jfree/data/Dataset.html" title="interface in org.jfree.data">Dataset</A>, <A HREF="../../../org/jfree/data/KeyedValues2D.html" title="interface in org.jfree.data">KeyedValues2D</A>, java.io.ObjectInputValidation, java.io.Serializable, <A HREF="../../../org/jfree/data/Values2D.html" title="interface in org.jfree.data">Values2D</A></DD></DL><HR><DL><DT>public class <B>JDBCCategoryDataset</B><DT>extends <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html" title="class in org.jfree.data">DefaultCategoryDataset</A></DL><P>A <A HREF="../../../org/jfree/data/CategoryDataset.html" title="interface in org.jfree.data"><CODE>CategoryDataset</CODE></A> implementation over a database JDBC result set. The dataset is populated via a call to executeQuery 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. executeQuery can be called a number of times. The database connection is read-only and no write back facility exists.<P><P><DL><DT><B>Author:</B></DT> <DD>Bryan Scott Changes ------- 24-Sep-2003 : Added clearing results from previous queries to executeQuery following being highlighted on online forum (BS);</DD><DT><B>See Also:</B><DD><A HREF="../../../serialized-form.html#org.jfree.data.JDBCCategoryDataset">Serialized Form</A></DL><HR><P><!-- ======== NESTED CLASS SUMMARY ======== --><!-- =========== FIELD SUMMARY =========== --><!-- ======== CONSTRUCTOR SUMMARY ======== --><A NAME="constructor_summary"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Constructor Summary</B></FONT></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><B><A HREF="../../../org/jfree/data/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/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/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"><TD COLSPAN=2><FONT SIZE="+2"><B>Method Summary</B></FONT></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/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/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/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/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.DefaultCategoryDataset"><!-- --></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/DefaultCategoryDataset.html" title="class in org.jfree.data">DefaultCategoryDataset</A></B></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#addValue(double, java.lang.Comparable, java.lang.Comparable)">addValue</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#addValue(java.lang.Number, java.lang.Comparable, java.lang.Comparable)">addValue</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#clear()">clear</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#equals(java.lang.Object)">equals</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#getColumnCount()">getColumnCount</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#getColumnIndex(java.lang.Comparable)">getColumnIndex</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#getColumnKey(int)">getColumnKey</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#getColumnKeys()">getColumnKeys</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#getRowCount()">getRowCount</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#getRowIndex(java.lang.Comparable)">getRowIndex</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#getRowKey(int)">getRowKey</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#getRowKeys()">getRowKeys</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#getValue(java.lang.Comparable, java.lang.Comparable)">getValue</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#getValue(int, int)">getValue</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#hashCode()">hashCode</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#incrementValue(double, java.lang.Comparable, java.lang.Comparable)">incrementValue</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#removeColumn(java.lang.Comparable)">removeColumn</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#removeColumn(int)">removeColumn</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#removeRow(java.lang.Comparable)">removeRow</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#removeRow(int)">removeRow</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#removeValue(java.lang.Comparable, java.lang.Comparable)">removeValue</A>, <A HREF="../../../org/jfree/data/DefaultCategoryDataset.html#setValue(double, java.lang.Comparable, java.lang.Comparable)">setValue</A>, <A HREF="../../../org/jfree/data/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.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>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -