Question

JSP运行出错Multiple annotations found at this line:

<%
String year=request.getParameter("year");
//获得某年按月份分组的总销售额的SQL语句
String strSql="select * from (select sum(je) as sumje,month(xsdate) as xsmonth from tb_sell where year(xsdate)='"+
year+"' group by month(xsdate) union select 0,MonthName from GetMonth() where MonthName not in (select month(xsdate) as xsmonth from tb_sell where year(xsdate)='"+
year+"' group by month(xsdate))) temp order by temp.xsmonth";
ResultSet rs=rst.getResult(strSql);//此处出错入下：【】
【//Multiple annotations found at this line:
//- The type java.lang.CharSequence cannot be resolved. It is indirectly
//referenced from required .class files
//- The type java.lang.CharSequence cannot be resolved. It is indirectly
//referenced from required .class files】
int counts=0;
if(!rs.next()){
out.println("<script language='javascript'>alert('"+year+"年没有销售记录');"+
"window.location.href='main.jsp';</script>");
}

Answer 1

你union的两个select语句里的字段要一致，就是后面的select 0,MonthName也要select 0 as sumje,MonthName as xsmonth