Sending parameter to jasper queryString

[Sagar Deshmukh]

Hey guys i am totally blank about jasper report because i have use iText for my all project but now i want to use jasper and basically i want to learn. so please guid me, please see my below .jrxml file code

<queryString>
		<![CDATA[SELECT
     patientinfo.`datee` AS patientinfo_datee,
     patientinfo.`ptname` AS patientinfo_ptname,
     patientinfo.`age` AS patientinfo_age,
     patientinfo.`gen` AS patientinfo_gen,
     patientinfo.`addre` AS patientinfo_addre,
     patientinfo.`contno` AS patientinfo_contno,
     patientinfo.`wt` AS patientinfo_wt,
     patientinfo.`bp` AS patientinfo_bp,
     patientinfo.`height` AS patientinfo_height,
     patientinfo.`allergicto` AS patientinfo_allergicto,
     patientinfo.`kco` AS patientinfo_kco,
     patientinfo.`pulse` AS patientinfo_pulse,
     patientinfo.`symtoms` AS patientinfo_symtoms,
     patientinfo.`adv` AS patientinfo_adv,
     patientinfo.`rn` AS patientinfo_rn
FROM
     `patientinfo` patientinfo
WHERE
   [b]  rn = 14[/b]]]>
	</queryString>

insted of 14 i want to send user enter value at runtime using java code so how do i pass value in rn as per user enter.
Waiting for your helpfull reply

[James Boswell]

You need to declare a parameter in your report (jrxml) file:
<parameter name="rn" class="java.lang.Integer"/>
You also need to replace your hardcoded value of 14 in your query with a placeholder to the 'rn' parameter:
<queryString> <![CDATA[SELECT patientinfo.`datee` AS patientinfo_datee, patientinfo.`ptname` AS patientinfo_ptname, patientinfo.`age` AS patientinfo_age, patientinfo.`gen` AS patientinfo_gen, patientinfo.`addre` AS patientinfo_addre, patientinfo.`contno` AS patientinfo_contno, patientinfo.`wt` AS patientinfo_wt, patientinfo.`bp` AS patientinfo_bp, patientinfo.`height` AS patientinfo_height, patientinfo.`allergicto` AS patientinfo_allergicto, patientinfo.`kco` AS patientinfo_kco, patientinfo.`pulse` AS patientinfo_pulse, patientinfo.`symtoms` AS patientinfo_symtoms, patientinfo.`adv` AS patientinfo_adv, patientinfo.`rn` AS patientinfo_rn FROM `patientinfo` patientinfo WHERE [b] rn = $P{rn}[/b]]]> </queryString>
In your Java code, you pass a parameter using a Map when you fill the report:

Integer rnFromUser = ...;
Map parametersMap = new HashMap();  
parametersMap.put("rn", rnFromUser);
JasperPrint jasperPrint = JasperFillManager.fillReport(
jasperReport, parametersMap, jdbcConnection);

[Sagar Deshmukh]

Thanks James , God bles you