jdbcxydataset.html

jfreechart1。0。2的api。

<FONT color="green">320</FONT>                    default :<a name="line.320"></a>
<FONT color="green">321</FONT>                        this.isTimeSeries = false;<a name="line.321"></a>
<FONT color="green">322</FONT>                        break;<a name="line.322"></a>
<FONT color="green">323</FONT>                }<a name="line.323"></a>
<FONT color="green">324</FONT>    <a name="line.324"></a>
<FONT color="green">325</FONT>                // Get all rows.<a name="line.325"></a>
<FONT color="green">326</FONT>                // rows = new ArrayList();<a name="line.326"></a>
<FONT color="green">327</FONT>                while (resultSet.next()) {<a name="line.327"></a>
<FONT color="green">328</FONT>                    ArrayList newRow = new ArrayList();<a name="line.328"></a>
<FONT color="green">329</FONT>                    for (int column = 0; column &lt; numberOfColumns; column++) {<a name="line.329"></a>
<FONT color="green">330</FONT>                        Object xObject = resultSet.getObject(column + 1);<a name="line.330"></a>
<FONT color="green">331</FONT>                        switch (columnTypes[column]) {<a name="line.331"></a>
<FONT color="green">332</FONT>                            case Types.NUMERIC:<a name="line.332"></a>
<FONT color="green">333</FONT>                            case Types.REAL:<a name="line.333"></a>
<FONT color="green">334</FONT>                            case Types.INTEGER:<a name="line.334"></a>
<FONT color="green">335</FONT>                            case Types.DOUBLE:<a name="line.335"></a>
<FONT color="green">336</FONT>                            case Types.FLOAT:<a name="line.336"></a>
<FONT color="green">337</FONT>                            case Types.DECIMAL:<a name="line.337"></a>
<FONT color="green">338</FONT>                            case Types.BIGINT:<a name="line.338"></a>
<FONT color="green">339</FONT>                            case Types.SMALLINT:<a name="line.339"></a>
<FONT color="green">340</FONT>                                newRow.add(xObject);<a name="line.340"></a>
<FONT color="green">341</FONT>                                break;<a name="line.341"></a>
<FONT color="green">342</FONT>    <a name="line.342"></a>
<FONT color="green">343</FONT>                            case Types.DATE:<a name="line.343"></a>
<FONT color="green">344</FONT>                            case Types.TIME:<a name="line.344"></a>
<FONT color="green">345</FONT>                            case Types.TIMESTAMP:<a name="line.345"></a>
<FONT color="green">346</FONT>                                newRow.add(new Long(((Date) xObject).getTime()));<a name="line.346"></a>
<FONT color="green">347</FONT>                                break;<a name="line.347"></a>
<FONT color="green">348</FONT>                            case Types.NULL:<a name="line.348"></a>
<FONT color="green">349</FONT>                                break;<a name="line.349"></a>
<FONT color="green">350</FONT>                            default:<a name="line.350"></a>
<FONT color="green">351</FONT>                                System.err.println("Unknown data");<a name="line.351"></a>
<FONT color="green">352</FONT>                                columnTypes[column] = Types.NULL;<a name="line.352"></a>
<FONT color="green">353</FONT>                                break;<a name="line.353"></a>
<FONT color="green">354</FONT>                        }<a name="line.354"></a>
<FONT color="green">355</FONT>                    }<a name="line.355"></a>
<FONT color="green">356</FONT>                    this.rows.add(newRow);<a name="line.356"></a>
<FONT color="green">357</FONT>                }<a name="line.357"></a>
<FONT color="green">358</FONT>    <a name="line.358"></a>
<FONT color="green">359</FONT>                /// a kludge to make everything work when no rows returned<a name="line.359"></a>
<FONT color="green">360</FONT>                if (this.rows.size() == 0) {<a name="line.360"></a>
<FONT color="green">361</FONT>                    ArrayList newRow = new ArrayList();<a name="line.361"></a>
<FONT color="green">362</FONT>                    for (int column = 0; column &lt; numberOfColumns; column++) {<a name="line.362"></a>
<FONT color="green">363</FONT>                        if (columnTypes[column] != Types.NULL) {<a name="line.363"></a>
<FONT color="green">364</FONT>                            newRow.add(new Integer(0));<a name="line.364"></a>
<FONT color="green">365</FONT>                        }<a name="line.365"></a>
<FONT color="green">366</FONT>                    }<a name="line.366"></a>
<FONT color="green">367</FONT>                    this.rows.add(newRow);<a name="line.367"></a>
<FONT color="green">368</FONT>                }<a name="line.368"></a>
<FONT color="green">369</FONT>    <a name="line.369"></a>
<FONT color="green">370</FONT>                /// Determine max and min values.<a name="line.370"></a>
<FONT color="green">371</FONT>                if (this.rows.size() &lt; 1) {<a name="line.371"></a>
<FONT color="green">372</FONT>                    this.maxValue = 0.0;<a name="line.372"></a>
<FONT color="green">373</FONT>                    this.minValue = 0.0;<a name="line.373"></a>
<FONT color="green">374</FONT>                }<a name="line.374"></a>
<FONT color="green">375</FONT>                else {<a name="line.375"></a>
<FONT color="green">376</FONT>                    ArrayList row = (ArrayList) this.rows.get(0);<a name="line.376"></a>
<FONT color="green">377</FONT>                    this.maxValue = Double.NEGATIVE_INFINITY;<a name="line.377"></a>
<FONT color="green">378</FONT>                    this.minValue = Double.POSITIVE_INFINITY;<a name="line.378"></a>
<FONT color="green">379</FONT>                    for (int rowNum = 0; rowNum &lt; this.rows.size(); ++rowNum) {<a name="line.379"></a>
<FONT color="green">380</FONT>                        row = (ArrayList) this.rows.get(rowNum);<a name="line.380"></a>
<FONT color="green">381</FONT>                        for (int column = 1; column &lt; numberOfColumns; column++) {<a name="line.381"></a>
<FONT color="green">382</FONT>                            Object testValue = row.get(column);<a name="line.382"></a>
<FONT color="green">383</FONT>                            if (testValue != null) {<a name="line.383"></a>
<FONT color="green">384</FONT>                                double test = ((Number) testValue).doubleValue();<a name="line.384"></a>
<FONT color="green">385</FONT>                            <a name="line.385"></a>
<FONT color="green">386</FONT>                                if (test &lt; this.minValue) {<a name="line.386"></a>
<FONT color="green">387</FONT>                                    this.minValue = test;<a name="line.387"></a>
<FONT color="green">388</FONT>                                }<a name="line.388"></a>
<FONT color="green">389</FONT>                                if (test &gt; this.maxValue) {<a name="line.389"></a>
<FONT color="green">390</FONT>                                    this.maxValue = test;<a name="line.390"></a>
<FONT color="green">391</FONT>                                }<a name="line.391"></a>
<FONT color="green">392</FONT>                            }<a name="line.392"></a>
<FONT color="green">393</FONT>                        }<a name="line.393"></a>
<FONT color="green">394</FONT>                    }<a name="line.394"></a>
<FONT color="green">395</FONT>                }<a name="line.395"></a>
<FONT color="green">396</FONT>    <a name="line.396"></a>
<FONT color="green">397</FONT>                fireDatasetChanged(); // Tell the listeners a new table has arrived.<a name="line.397"></a>
<FONT color="green">398</FONT>            }<a name="line.398"></a>
<FONT color="green">399</FONT>            finally {<a name="line.399"></a>
<FONT color="green">400</FONT>                if (resultSet != null) {<a name="line.400"></a>
<FONT color="green">401</FONT>                    try {<a name="line.401"></a>
<FONT color="green">402</FONT>                        resultSet.close();<a name="line.402"></a>
<FONT color="green">403</FONT>                    }<a name="line.403"></a>
<FONT color="green">404</FONT>                    catch (Exception e) {<a name="line.404"></a>
<FONT color="green">405</FONT>                        // TODO: is this a good idea?<a name="line.405"></a>
<FONT color="green">406</FONT>                    }<a name="line.406"></a>
<FONT color="green">407</FONT>                }<a name="line.407"></a>
<FONT color="green">408</FONT>                if (statement != null) {<a name="line.408"></a>
<FONT color="green">409</FONT>                    try {<a name="line.409"></a>
<FONT color="green">410</FONT>                        statement.close();<a name="line.410"></a>
<FONT color="green">411</FONT>                    }<a name="line.411"></a>
<FONT color="green">412</FONT>                    catch (Exception e) {<a name="line.412"></a>
<FONT color="green">413</FONT>                        // TODO: is this a good idea?<a name="line.413"></a>
<FONT color="green">414</FONT>                    }<a name="line.414"></a>
<FONT color="green">415</FONT>                }<a name="line.415"></a>
<FONT color="green">416</FONT>            }<a name="line.416"></a>
<FONT color="green">417</FONT>    <a name="line.417"></a>
<FONT color="green">418</FONT>        }<a name="line.418"></a>
<FONT color="green">419</FONT>    <a name="line.419"></a>
<FONT color="green">420</FONT>        /**<a name="line.420"></a>
<FONT color="green">421</FONT>         * Returns the x-value for the specified series and item.  The<a name="line.421"></a>
<FONT color="green">422</FONT>         * implementation is responsible for ensuring that the x-values are<a name="line.422"></a>
<FONT color="green">423</FONT>         * presented in ascending order.<a name="line.423"></a>
<FONT color="green">424</FONT>         *<a name="line.424"></a>
<FONT color="green">425</FONT>         * @param  seriesIndex  the series (zero-based index).<a name="line.425"></a>
<FONT color="green">426</FONT>         * @param  itemIndex  the item (zero-based index).<a name="line.426"></a>
<FONT color="green">427</FONT>         *<a name="line.427"></a>
<FONT color="green">428</FONT>         * @return The x-value<a name="line.428"></a>
<FONT color="green">429</FONT>         *<a name="line.429"></a>
<FONT color="green">430</FONT>         * @see XYDataset<a name="line.430"></a>
<FONT color="green">431</FONT>         */<a name="line.431"></a>
<FONT color="green">432</FONT>        public Number getX(int seriesIndex, int itemIndex) {<a name="line.432"></a>
<FONT color="green">433</FONT>            ArrayList row = (ArrayList) this.rows.get(itemIndex);<a name="line.433"></a>
<FONT color="green">434</FONT>            return (Number) row.get(0);<a name="line.434"></a>
<FONT color="green">435</FONT>        }<a name="line.435"></a>
<FONT color="green">436</FONT>    <a name="line.436"></a>
<FONT color="green">437</FONT>        /**<a name="line.437"></a>
<FONT color="green">438</FONT>         * Returns the y-value for the specified series and item.<a name="line.438"></a>
<FONT color="green">439</FONT>         *<a name="line.439"></a>
<FONT color="green">440</FONT>         * @param  seriesIndex  the series (zero-based index).<a name="line.440"></a>
<FONT color="green">441</FONT>         * @param  itemIndex  the item (zero-based index).<a name="line.441"></a>
<FONT color="green">442</FONT>         *<a name="line.442"></a>
<FONT color="green">443</FONT>         * @return The yValue value<a name="line.443"></a>
<FONT color="green">444</FONT>         *<a name="line.444"></a>
<FONT color="green">445</FONT>         * @see XYDataset<a name="line.445"></a>
<FONT color="green">446</FONT>         */<a name="line.446"></a>
<FONT color="green">447</FONT>        public Number getY(int seriesIndex, int itemIndex) {<a name="line.447"></a>
<FONT color="green">448</FONT>            ArrayList row = (ArrayList) this.rows.get(itemIndex);<a name="line.448"></a>
<FONT color="green">449</FONT>            return (Number) row.get(seriesIndex + 1);<a name="line.449"></a>
<FONT color="green">450</FONT>        }<a name="line.450"></a>
<FONT color="green">451</FONT>    <a name="line.451"></a>
<FONT color="green">452</FONT>        /**<a name="line.452"></a>
<FONT color="green">453</FONT>         * Returns the number of items in the specified series.<a name="line.453"></a>
<FONT color="green">454</FONT>         *<a name="line.454"></a>
<FONT color="green">455</FONT>         * @param  seriesIndex  the series (zero-based index).<a name="line.455"></a>
<FONT color="green">456</FONT>         *<a name="line.456"></a>
<FONT color="green">457</FONT>         * @return The itemCount value<a name="line.457"></a>
<FONT color="green">458</FONT>         *<a name="line.458"></a>
<FONT color="green">459</FONT>         * @see XYDataset<a name="line.459"></a>
<FONT color="green">460</FONT>         */<a name="line.460"></a>
<FONT color="green">461</FONT>        public int getItemCount(int seriesIndex) {<a name="line.461"></a>
<FONT color="green">462</FONT>            return this.rows.size();<a name="line.462"></a>
<FONT color="green">463</FONT>        }<a name="line.463"></a>
<FONT color="green">464</FONT>    <a name="line.464"></a>
<FONT color="green">465</FONT>        /**<a name="line.465"></a>
<FONT color="green">466</FONT>         * Returns the number of items in all series.  This method is defined by <a name="line.466"></a>
<FONT color="green">467</FONT>         * the {@link TableXYDataset} interface.<a name="line.467"></a>
<FONT color="green">468</FONT>         * <a name="line.468"></a>
<FONT color="green">469</FONT>         * @return The item count.<a name="line.469"></a>
<FONT color="green">470</FONT>         */<a name="line.470"></a>
<FONT color="green">471</FONT>        public int getItemCount() {<a name="line.471"></a>
<FONT color="green">472</FONT>            return getItemCount(0);<a name="line.472"></a>
<FONT color="green">473</FONT>        }<a name="line.473"></a>
<FONT color="green">474</FONT>        <a name="line.474"></a>
<FONT color="green">475</FONT>        /**<a name="line.475"></a>
<FONT color="green">476</FONT>         * Returns the number of series in the dataset.<a name="line.476"></a>
<FONT color="green">477</FONT>         *<a name="line.477"></a>
<FONT color="green">478</FONT>         * @return The seriesCount value<a name="line.478"></a>
<FONT color="green">479</FONT>         *<a name="line.479"></a>
<FONT color="green">480</FONT>         * @see XYDataset<a name="line.480"></a>