Getting data from Database

[2001 JI Open Discussion]

By: Albert - jagerkiss

Getting data from Database

2002-09-05 01:38

Hi Teodor,

 

I've read your example code:

 

<%@ page errorPage="jasperError.jsp" %>

<%@ page import="dori.jasper.engine.*" %>

<%@ page import="java.util.*" %>

<%@ page import="java.io.*" %>

<%@ page import="java.sql.*" %>

<%@ page import="java.awt.*" %>

 

<%

String driver = "weblogic.jdbc.mssqlserver4.Driver";

String connectString = "jdbc:weblogic:mssqlserver4:kermit:1433?db=Northwind";

String user = "sa";

String password = "";

 

 

Class.forName(driver);

Connection conn = DriverManager.getConnection(connectString, user, password);

 

JasperReport jasperReport = null;

jasperReport = JasperManager.loadReport("../data/FirstJasper.jasper");

 

//Preparing parameters

Image image = Toolkit.getDefaultToolkit().createImage("dukesign.jpg");

MediaTracker traker = new MediaTracker(new Panel());

traker.addImage(image, 0);

try

{

traker.waitForID(0);

}

catch (Exception e)

{

e.printStackTrace();

}

 

Map parameters = new HashMap();

parameters.put("ReportTitle", "The First Jasper Report Ever");

parameters.put("MaxOrderID", new Integer(10500));

parameters.put("SummaryImage", image);

 

JasperPrint jasperPrint = JasperManager.fillReport(jasperReport, parameters, conn);

 

ByteArrayOutputStream baos = JasperManager.printReportToPdf(jasperPrint);

 

response.setContentType("application/pdf");

response.setContentLength(baos.size());

ServletOutputStream outStream = response.getOutputStream();

baos.writeTo(outStream);

outStream.flush();

%>

 

I still don't know which part of this code do the query to database. All I could find was code fragment which did making connection to database.

 

So my question is, where can I insert my query string?

 

Thanks,

Albert

 

 

By: Teodor Danciu - teodord

RE: Getting data from Database

2002-09-05 02:41

 

Hi,

 

The SQL query is specified in the XML report

template.

See the "queryString" element in the

"Quick Reference".

 

This XML report template was initially compiled

to obtain that .jasper file you see in the code.

 

Take a look at the docs. I know they are not much,

but at least you get an idea about the whole thing.

 

I hope this helps.

Teodor

 

 

 

By: Albert - jagerkiss

RE: Getting data from Database

2002-09-05 18:49

Hi again, Teodor!

 

While I was trying to compile an xml file with ant, I received error message "file:C:/ALBERT/TEST/FirstJasper.xml:17: Config file is not of expected XML type" (with file FirstJasper had been edited).

 

<jasperReport

 

name="FirstJasper"

columnCount="2"

printOrder="Vertical"

pageWidth="595"

pageHeight="842"

columnWidth="270"

columnSpacing="15"

leftMargin="20"

rightMargin="20"

topMargin="30"

bottomMargin="30"

isTitleNewPage="false"

isSummaryNewPage="false"> ---------> this is the 17th line.

 

What makes this error?

 

Thanks a lot,

Albert