jasper report 5.5 jxml과 DB를 이용한 리포트 띄우기!

JAVASOURCE (report3.jrxml은 ireport를 이용해서 생성 해야함.)
package test; import java.sql.Connection; import java.sql.DriverManager; import java.util.HashMap; import java.util.Map; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.JasperReport; public class Test { /** The connection. */ static Connection connection = null; /** * Connect database. */ static void ConnectDatabase() { try { // Load the JDBC driver String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; Class.forName(driverName); // Create a connection to the database String url = "jdbc:sqlserver://127.0.0.1\\testdb:2433;databaseName=testdb;"; String username = "tester"; String password = "test!"; connection = DriverManager.getConnection(url, username, password); } catch (ClassNotFoundException e) { System.err.println("Could not find the database driver"); } catch (Exception e) { System.err.println("Could not connect to the database"); } } /** * The main method. * * @param args the arguments */ public static void main(String[] args) { JasperReport jasperReport; JasperPrint jasperPrint; long start = System.currentTimeMillis(); try { // Log log4j configuration System.out.println("Start"); System.out.println("--------"); System.out.println("Compile Jasper XML Report"); jasperReport = JasperCompileManager.compileReport("src/test/report3.jrxml"); System.out.println("time : " + (System.currentTimeMillis() - start)+ " ms."); System.out.println("Create Database connection"); ConnectDatabase(); System.out.println("time : " + (System.currentTimeMillis() - start)+ " ms."); System.out.println("Create parameters"); Map <String, Object> parameters = new HashMap<String, Object>(); parameters.put("ReportTitle", "User Report"); parameters.put("DataFile", "src/test/report3.jasper"); parameters.put("IdRange", 10); System.out.println("Generated report"); jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, connection); System.out.println("time : " + (System.currentTimeMillis() - start)+ " ms."); System.out.println("Generated PDF"); JasperExportManager.exportReportToPdfFile(jasperPrint, "c:\\a\\test.pdf"); System.out.println("time : " + (System.currentTimeMillis() - start)+ " ms."); } catch (Exception e) { e.printStackTrace(); } System.out.println("--------"); System.out.println("Done"); } }