日期:2014-05-19  浏览次数:20859 次

http://baike.baidu.com/view/913128.htm
请帮我看看为什么会出这个错:
<%@ page contentType="text/html;charset=utf-8" language="java"
isELIgnored="false"%>
<%@page import="com.sinosoft.module.sinoform.ConfigSinoForm"%>
<%@page import="com.sinosoft.dao.DBAccess"%>
<%@page import="com.sinosoft.dao.DBTool"%>
<%@page import="java.util.*"%>
<%@page import="sun.jdbc.rowset.CachedRowSet"%>
<%@page import="com.sinosoft.util.tool.JDateToolkit"%>
<%@page import="com.sjzx.registered.StaticConstants"%>
<%@page import="com.sjzx.registered.ReturnOptions"%>
<%@page import="com.syzx.inputData.DataBean"%>
<%@page import="java.util.ArrayList"%>
<%@ taglib uri="/WEB-INF/product/report/taglib/report.tld"
prefix="report"%>
<%@ taglib uri="/WEB-INF/product/report/taglib/report-applet.tld"
prefix="ra"%>
<%
//表格标题
String title = "";
//用戶名,预留
String userID; 
//选择年份
String selectedyear = request.getParameter("yearbox");
//选择填报类型
String selectedtype = request.getParameter("typetbox");
//选择分类ID
String selectedID = request.getParameter("IDbox");
//转出sql语句
StringBuilder usedSql = new StringBuilder();

String page_id = request.getParameter("resourceId") == null ? "1"
: request.getParameter("resourceId");  
System.out.println(page_id);
ConfigSinoForm voe = new ConfigSinoForm();
//获取reportId
String reportId;
if(request.getParameter("resourceId")==null|request.getParameter("resourceId")=="1"){
reportId = request.getParameter("reportId");
}else{
reportId = voe.getReport(page_id)[0];
}

//判断提交状态
boolean state = false;
if(selectedtype != null && selectedyear !=null){
state = true;
}

//构造SQL
if(state){
if(selectedtype.equals("A表")){
usedSql.append("select varchar1,double1,double2 from market_custom_child where main_id='1' and varchar1 like '"+selectedyear+"%' and varchar2='11' and varchar3="+selectedID+" order by varchar1");
}
if(selectedtype.equals("B表")){
usedSql.append("select varchar1,double1,double2 from market_custom_child where main_id='2' and varchar1 like '"+selectedyear+"%' and varchar2='11' order by varchar1");
}
if(selectedtype.equals("C表")){
usedSql.append("select varchar1,double1,double2 from market_custom_child where main_id='3' and varchar1 like '"+selectedyear+"%' and varchar2='11' order by varchar1");
}

title="现在展示"+selectedtype+"在"+selectedyear+"年"+selectedID+"的月份对比图";
}

//获取库中年份信息
DBTool dbtool = DBAccess.getDBTool();
String dbsource = "platform";

ArrayList yearList = new ArrayList();
ArrayList IDList = new ArrayList();

String sql = "select distinct varchar1 from market_custom_child order by varchar1;";
CachedRowSet crsYear = (CachedRowSet) dbtool.queryAllRes(dbsource, sql);
//将年份查询结果逐条写入年份List中
while (crsYear.next()) {
DataBean dbyear = new DataBean();
dbyear.setS1((crsYear.getString("varchar1")).substring(0,4));
int i=0;
for(; i<yearList.size(); i++){
if(((DataBean)yearList.get(i)).getS1().equals(dbyear.getS1())){
break;
}
}
if(i == yearList.size())
yearList.add(dbyear);
}