Revision history [back]

tomcat6.0+zk3.6

code like this:

<zk> <zscript> String mcs=arg.get("para"); String mrpno=arg.get("rpno"); String mrpname=arg.get("rpname"); String mls=arg.get("ls"); </zscript>

<window id="pwin" title="Print Report" border="normal" width="480px" closable="true" position="center" maximizable="true"> <borderlayout height="100%"> <north maxsize="24" size="24" border="0"> <button label="Report!" onclick="showReport()"/> </north>

<zscript> import java.util.; import java.io.; import java.sql.*;
import net.sf.jasperreports.engine.JasperRunManager; import net.sf.jasperreports.engine.JRResultSetDataSource; import my.DBPool;

void showReport() { Connection conn = null; CallableStatement cstmt=null; ResultSet rs=null; report.setDatasource(null); Connection conn=DBPool.getPool().getConnection(); cstmt=conn.prepareCall("{call preport(?,?,?)}"); cstmt.setString(1,mrpno); cstmt.setString(2,mls); cstmt.setString(3,mcs);
rs=cstmt.executeQuery(); Map parameters = new HashMap(); parameters.put("date1", mcs.substring(0,mcs.indexOf(";"))); parameters.put("date2", mcs.substring(mcs.indexOf(";")+1)); report.setParameters(parameters); report.setSrc(mrpname); report.setDatasource( new JRResultSetDataSource(rs)); rs.close(); rs=null; cstmt.close(); cstmt=null; conn.close(); conn=null; }

</zscript> </window> </zk>

issue message:

type Status report

message 无法载入 /view/gr5e/zr5q3/0/D:/OpenSource/Tomcat 6.pdf。 原因： net.sf.jasperreports.engine.JRException: Unable to get next record.[SQL: 0, S1000]

description The requested resource (无法载入 /view/gr5e/zr5q3/0/D:/OpenSource/Tomcat 6.pdf。 原因： net.sf.jasperreports.engine.JRException: Unable to get next record.[SQL: 0, S1000] ) is no longer available, and no forwarding address is known.