Populating a chart with a JDBC Resultset
When you execute SELECT statements against a JDBC connection, you get in return a ResultSet that contains all the records selected. To read the results, we provide a JDBCDataProvider, which works like a read-only, forward-only cursor, to which you can bind charts. This is a useful strategy for reducing memory usage and loading read-only data very quickly.
The following Java code creates a ResultSet and uses a JDBCDataProvider to populate the charts:
String url="jdbc:jtds:sqlserver://dbserver:1433/NetSamples"; java.sql.ResultSet rs = null; java.sql.Connection conn = null; Class.forName("net.sourceforge.jtds.jdbc.Driver"); conn = java.sql.DriverManager.getConnection(url,"webguest",""); String query = "SELECT * from SampleFinancial1"; java.sql.Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sql.ResultSet.CONCUR_READ_ONLY); rs = stmt.executeQuery(query); JDBCDataProvider provider = new JDBCDataProvider(rs); chart1.setDataSource(provider); conn.close();
|
Note: The above example uses the jTDS JDBC driver from The jTDS Project as an example. Any JDBC driver may be used to load data into the JDBCDataProvider and Chart FX for Java.
|