connect to MySQL database

[2002 JI Open Discussion]

By: Umar Khatab - intercitra

connect to MySQL database

2003-10-30 19:08

I'm currently trying to run Jasper Report and integrate it with the rest of my Tomcat webapp which has already been working.

 

I've run the JasperReport samples, and they work.

Now the problem is that it seem difficult for me to integrate it with the webapp.

 

I have a few questions here.

 

[1]

 

File reportFile = new File(application.getRealPath("/frontpage/report/reports/WebappReport.jasper"));

String nama = request.getParameter("name");

String komentar = request.getParameter("comment");

 

Map parameters = new HashMap();

 

parameters.put("ReportTitle", "Backend User List");

parameters.put("BaseDir", reportFile.getParentFile());

parameters.put("Name", nama);

parameters.put("Comment", komentar);

................

 

 

I put two new parameters ("Name" and "Comment") in the sample to test whether they could show up in the report. If I enter the values like I show above, they won't show up in the pdf.

 

 

parameters.put("ReportTitle", "Backend User List");

parameters.put("BaseDir", reportFile.getParentFile());

parameters.put("Name", "MyName");

parameters.put("Comment", "MyComment");

................

 

But If I hardcode the values that way, they'll show up. I've tested that the values are already stored in variables 'nama' and 'komentar'. I've also tested, after putting the values in the Hashmap, to get the values back, and they show up.

 

I use the WebappReport.xml (also from samples). I've put this following lines in the parameters section:

 

<parameter name="Name" class="java.lang.Object"/>

<parameter name="Comment" class="java.lang.Object"/>

 

and the textfields as well.

 

 

Briefly speaking, the values of the parameters can only show up If they're hardcoded.

 

Anyone please point me out and correct my mistake.

 

[2] Please show me how to make a connection to MySQL database.

 

 

 

 

By: supportsib - supportsib

RE: connect to MySQL database

2004-03-11 01:30

how did u connect with mysql