Scriptlet代码 public class ChartScriptlet extends JRDefaultScriptlet { /** * */ public void afterReportInit() throws JRScriptletException { Connection con=null; DefaultPieDataset pieDataset = new DefaultPieDataset(); try { Class.forName("Oracle.jdbc.driver.OracleDriver"); System.out.println("oracle.jdbc.driver.OracleDriver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } try {
con = DriverManager.getConnection( "jdbc:oracle:thin:@127.0.0.1.38:1521:ora8i", "user", "passWord");
String query = "select province.name as name,sum(bill.total) as total from province,bill,node where bill.node_id =node.id and node.province_id=province.id and bill.CREATE_TIME > to_date('2004-1-1','yyyy-MM-dd') group by province.name"; Statement stmt = con.createStatement();