现在报表显示的中文问题解决了,但是从jsp传递到ireport中的参数还是有问题,报错如下:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: Error preparing statement for executing the report query : select b.equipment_number,b.location,c.state_info,d.data,d.date,e.data_type from c_equipment b,c_equipment_state c,zxm_data d,c_data_type e where b.id_colliery=? and b.id_state=c.id_state and b.id_equipment=d.id_equipment and d.id_type=e.id_type and d.date<? and d.date>?;
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.coal_jsp._jspService(org.apache.jsp.coal_jsp:289)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : select b.equipment_number,b.location,c.state_info,d.data,d.date,e.data_type from c_equipment b,c_equipment_state c,zxm_data d,c_data_type e where b.id_colliery=? and b.id_state=c.id_state and b.id_equipment=d.id_equipment and d.id_type=e.id_type and d.date<? and d.date>?;
net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:333)
net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:98)
net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:663)
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:704)
net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)
org.apache.jsp.coal_jsp._jspService(org.apache.jsp.coal_jsp:181)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.