<%@page import="SoftwareFX.ChartFX.*"%>
<%
ChartServer chart1 = new ChartServer(application,request,response );
String url="jdbc:jtds:sqlserver://dbserver1:1433/NetSamples";
java.sql.ResultSet rs = null;
java.sql.Connection conn = null;
try {
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);
}
catch (Exception e) {
out.println("Got an exception! <br>");
out.println(e.getMessage());
}
JDBCDataProvider provider = new JDBCDataProvider(rs);
//Setting the chart1 series
chart1.getDataType().setItem(0,DataType.LABEL);
chart1.getDataType().setItem(1,DataType.VALUE);
chart1.getDataType().setItem(2,DataType.VALUE);
chart1.getAxisX().getLabelsFormat().setFormat(AxisFormat.DATE);
SeriesAttributes series0 = chart1.getSeries().getItem(0);
series0.setGallery(Gallery.LINES);
series0.setLineWidth((short)2);
series0.setMarkerShape(MarkerShape.NONE);
series0.setYAxis(YAxis.MAIN);
SeriesAttributes series1 = chart1.getSeries().getItem(1);
series1.setGallery(Gallery.AREA);
series1.setBorder(true);
series1.setYAxis(YAxis.SECONDARY);
chart1.getAxisY().setGridlines(true);
Axis axis = chart1.getAxis().getItem(YAxis.SECONDARY);
axis.setMax(200000000);
axis.setMin(0);
axis.setVisible(false);
chart1.setRightGap(30);
chart1.setDataSource(provider);
conn.close();
%>
<%=chart1.getHtmlTag("450","280")%>
|