各位社友:
你们好,编译jsp代码出现如上错误,这是执行这个bean的代码,我不知道哪里错了,请各位帮帮忙,谢谢!
=========================================================================public ArrayList getAera_cash(String bdate,String pdate,String area,String custid,
String itemid,String salep) //区域业绩查询
{
ArrayList list=new ArrayList();
String str=null;
try
{ OracleDBConnection dbc=new OracleDBConnection();
//DBConnectionPool conn=new DBConnectionPool();
Connection conn=dbc.getConnection();//创建一个连接
CallableStatement stmt=conn.prepareCall("{add_cust_oe(to_date(bdate,'YYYY-MM-DD'),to_date(pdate,'YYYY-MM-DD'))}");
//CallableStatement stmt=dbc.prepareCall("{add_cust_oe}");
stmt.execute(); str="SELECT nvl(b.ATTRIBUTE1,'未划分区域') as area,a.ACCOUNT_NUMBER,b.PARTY_NAME,sum(qty) as qty_m,sum(a.PRICE) as price_m";
str= str + " FROM nbadd.add_cust_oe_price A,TT_WMS_CUST_A b";
str= str + " where a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER";
str= str + " and b.ORG_ID = 42";
str=str +"and (nvl(b.ATTRIBUTE1,'未划分区域') ='"+area +"' Or '"+area+"' is null)";
str= str + " AND (A.ACCOUNT_NUMBER = '"+custid +"' OR '"+ custid +"' IS NULL)";
str= str + " AND (A.CROSS_REFERENCE = '"+itemid +"' OR '"+itemid +"' IS NULL)";
str= str + " AND (A.NAME = '"+salep +"' OR '"+salep +"' IS NULL)";
str= str + " GROUP BY nvl(b.ATTRIBUTE1,'未划分区域') ,A.ACCOUNT_NUMBER,b.PARTY_NAME";
str= str + " order by nvl(b.ATTRIBUTE1,'未划分区域'),a.ACCOUNT_NUMBER";
ResultSet rs =dbc.executeQuery(str);
while(rs.next())
{
Achievement form=new Achievement();
form.setArea(rs.getString(1));
form.setPro_id(rs.getString(2));
form.setAch_name(rs.getString(3));
form.setCash(rs.getFloat(4));
form.setCash1(rs.getFloat(5));
list.add(form);
}
conn.close();
rs.close();
dbc.close();
stmt.close();
}
catch(Exception ex)
{
System.out.println(ex.getMessage()+"区域业绩查询");
}
return list;
}
你们好,编译jsp代码出现如上错误,这是执行这个bean的代码,我不知道哪里错了,请各位帮帮忙,谢谢!
=========================================================================public ArrayList getAera_cash(String bdate,String pdate,String area,String custid,
String itemid,String salep) //区域业绩查询
{
ArrayList list=new ArrayList();
String str=null;
try
{ OracleDBConnection dbc=new OracleDBConnection();
//DBConnectionPool conn=new DBConnectionPool();
Connection conn=dbc.getConnection();//创建一个连接
CallableStatement stmt=conn.prepareCall("{add_cust_oe(to_date(bdate,'YYYY-MM-DD'),to_date(pdate,'YYYY-MM-DD'))}");
//CallableStatement stmt=dbc.prepareCall("{add_cust_oe}");
stmt.execute(); str="SELECT nvl(b.ATTRIBUTE1,'未划分区域') as area,a.ACCOUNT_NUMBER,b.PARTY_NAME,sum(qty) as qty_m,sum(a.PRICE) as price_m";
str= str + " FROM nbadd.add_cust_oe_price A,TT_WMS_CUST_A b";
str= str + " where a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER";
str= str + " and b.ORG_ID = 42";
str=str +"and (nvl(b.ATTRIBUTE1,'未划分区域') ='"+area +"' Or '"+area+"' is null)";
str= str + " AND (A.ACCOUNT_NUMBER = '"+custid +"' OR '"+ custid +"' IS NULL)";
str= str + " AND (A.CROSS_REFERENCE = '"+itemid +"' OR '"+itemid +"' IS NULL)";
str= str + " AND (A.NAME = '"+salep +"' OR '"+salep +"' IS NULL)";
str= str + " GROUP BY nvl(b.ATTRIBUTE1,'未划分区域') ,A.ACCOUNT_NUMBER,b.PARTY_NAME";
str= str + " order by nvl(b.ATTRIBUTE1,'未划分区域'),a.ACCOUNT_NUMBER";
ResultSet rs =dbc.executeQuery(str);
while(rs.next())
{
Achievement form=new Achievement();
form.setArea(rs.getString(1));
form.setPro_id(rs.getString(2));
form.setAch_name(rs.getString(3));
form.setCash(rs.getFloat(4));
form.setCash1(rs.getFloat(5));
list.add(form);
}
conn.close();
rs.close();
dbc.close();
stmt.close();
}
catch(Exception ex)
{
System.out.println(ex.getMessage()+"区域业绩查询");
}
return list;
}
解决方案 »
- Struts2动态下载文件
- java 路径问题
- plugin和listener这两种上下文装载方式的区别?
- Tomcat配置Servlet出错!!
- jsp怎么生成动态脚本?
- 用JB开发代码,可以直接用import aa.aa.*这种方法来调用已经编译好的Class文件吗?
- jsp權限問題,現在頁面有1000多個,想實現象windows的那樣的權限管理,現在用到過濾器也不能很好解決,問題解決馬上結帳
- 关于Java Applet与HTML交互的问题
- ztree树,根节点怎么添加单击事件,顶级节点啊
- 穷举法输出所有可能(急)
- 用JSP 做的表格,请教一个问题,在线等=====
- 关于log4j生成的file日志的问题~~
===============================
bdate_y=trim(Request.Form ("bdate_y"))
bdate_m=trim(Request.Form ("bdate_m"))
bdate_d=trim(Request.Form ("bdate_d"))
edate_y=trim(Request.Form ("edate_y"))
edate_m=trim(Request.Form ("edate_m"))
edate_d=trim(Request.Form ("edate_d"))
j_y_b=trim(Request.Form ("j_y_b"))
j_m_b=trim(Request.Form ("j_m_b"))
j_d_b=trim(Request.Form ("j_d_b"))
j_y_e=trim(Request.Form ("j_y_e"))
j_m_e=trim(Request.Form ("j_m_e"))
j_d_e=trim(Request.Form ("j_d_e"))
custid=UCase(trim(Request.Form ("custid")))
itemid=trim(Request.Form ("itemid"))
salep=trim(Request.Form ("salep"))
area=Trim(request.Form("area"))
set conn_ERP=server.CreateObject("adodb.connection")
set cmd=server.CreateObject("adodb.command")
conn_ERP.Open "Provider=OraOLEDB.Oracle;Password=apps;Persist Security Info=True;User ID=apps;Data Source=prod_11"
set cmd.ActiveConnection=conn_ERP
cmd.CommandText="add_cust_oe"
cmd.commandType=4
cmd.Prepared = true
cmd.Parameters.Append cmd.CreateParameter("@p_sale_b",135,1 )
cmd.Parameters.Append cmd.CreateParameter("@p_sale_e",135,1 )
cmd("@p_sale_b")= (bdate_y+"-"+bdate_m+"-"+bdate_d)
cmd("@p_sale_e")= (edate_y+"-"+edate_m+"-"+edate_d)
cmd.Execute()
'response.write cmd str="SELECT nvl(b.ATTRIBUTE1,'未划分区域') as area,a.ACCOUNT_NUMBER,b.PARTY_NAME,sum(qty) as qty_m,sum(a.PRICE) as price_m"
str= str & " FROM nbadd.add_cust_oe_price A,TT_WMS_CUST_A b"
str= str & " where a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER"
str= str & " and b.ORG_ID = 42"
str=str &"and (nvl(b.ATTRIBUTE1,'未划分区域') ='"& area &"' Or '"&area&"' is null)"
str= str & " AND (A.ACCOUNT_NUMBER = '"& custid &"' OR '"& custid &"' IS NULL)"
str= str & " AND (A.CROSS_REFERENCE = '"& itemid &"' OR '"& itemid &"' IS NULL)"
str= str & " AND (A.NAME = '"& salep &"' OR '"& salep &"' IS NULL)"
str= str & " GROUP BY nvl(b.ATTRIBUTE1,'未划分区域') ,A.ACCOUNT_NUMBER,b.PARTY_NAME"
str= str & " order by nvl(b.ATTRIBUTE1,'未划分区域'),a.ACCOUNT_NUMBER"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open str,conn_ERP,1,3