|
楼主 |
发表于 2016-11-14 22:04:26
|
显示全部楼层
您好,设置java文件所在的dsrc或者src右键设置为源码路径后有报错。
文件名:chartProcedure.java(报错),
导入声明(!号警告);
ChartProcedure(报错)下,BX2016(ACTION 报错),点击进去打开chartProcedure.java文件:
报错的地方是:
sqlMap.put(SQL.DEFAULT_DB_NAME,mysql);
报错信息:mysql cannot be resolved to a variable:
chartProcedure.java文件全部代码:
import com.justep.util.Utils;
public class ChartProcedure {
public static Table bx2016(String skyname,String skyid,Integer skyindex,java.sql.Date skydata1,java.sql.Date skydata2){
System.out.print(skyindex);
System.out.print(skydata1);
Integer wrapperi = new Integer(skyindex);
int skytemp = wrapperi.intValue();
System.out.print(skytemp);
int age = 16;
if(age <= 18){
String mysql = "select sName,sum(fBXZE) AS fBXZE from Erp_bmreportview u left join er_bxsq a on a.fSQR like CONCAT('%',u.sName,'%') and ( a.fDJZT='已审批 ' and a.sqrq between '"+skydata1+"' AND '"+skydata2+"' ) where u.sParent='"+skyid+"' GROUP BY sName;";
}
HashMap<String,String> sqlMap=new HashMap<String,String>();
sqlMap.put(SQL.DEFAULT_DB_NAME,mysql);
return SQL.select(sqlMap, null,"/ERP/Baoxiao/bxgoodslist/data" );
}
}
|
|