When creating a dvt:pieGraph, an object of GraphDataModel
class needs to be passed as input to it.
class needs to be passed as input to it.
The below code helps to understand how to create
GraphDataModel object.
GraphDataModel object.
In the below code, I am taking data from database.
|
public static GraphDataModel getGraphDataModel(String table, String cust_id) throws Exception {
String[]
columnLabels = { “” };
String[]
columnNames = getColumnNames(table);//User defind Method, returns all column names of the given table
int size =
columnNames.length;
if
(ignoreFields != null)
size =
size – ignoreFields.size();
Object[][]
data2 = new Object[1][size];
String[]
seriesLabels = new String[size];
Connection
con = createConnection(); //Method to return connection object
Statement
stmt = con.createStatement(); StringBuilder query = new StringBuilder(“SELECT * FROM ” + table+ “where cust_id=”+cust_id);
System.out.println(“Query
of graph: ” + query);
ResultSet rs
= stmt.executeQuery(query);
if
(rs.next()) {
for (int
i = 0, j = 0; i < columnNames.length && j < size; i++) {
if
(“cust_id”.equals(columnNames[i])) continue; seriesLabels[j] = columnNames[i]; data2[0][j] = new Double(rs.getDouble(i + 1));
j++;
}
}
rs.close();
stmt.close();
con.close();
oracle.dss.dataView.LocalXMLDataSource ds =
new
oracle.dss.dataView.LocalXMLDataSource(columnLabels, seriesLabels, data2); GraphDataModel graphData =
new
oracle.adf.view.faces.bi.model.GraphDataModel(); graphData.setDataSource(ds);
return
graphData;} |
No Comments