一个简单问题,答对了马上给分.
我现在想要实现一个有下拉菜单的可选择查询内容的东东.
代码如下:
<%@ page language="java" contentType="text/html;charset=GB2312"%>
<%@ page import="com.zhang.SqlBean,java.sql.*,com.zhang.*"%>
<% Convert xxx = new Convert();
SqlBean xx = new SqlBean();
String dwdm = request.getParameter("select"); //上个页面传过来
String text=request.getParameter("text");
if(text.equals("")||text==null)
{
out.println();
return;
}
String selectStr="";
ResultSet rs=null;
%>
<%Switch(dwdm){
case '1':
text=Integer.parseInt("text");
selectStr = "SELECT AAB001,AAB005 FROM AA001 WHERE AAB001=text";
rs = xx.executeQuery(selectStr);
break;
case '2':
selectStr = "SELECT AAB001,AAB005 FROM AA001 WHERE AAB005 like '%text%'";
rs=xx.executeQuery(selectStr);
break;
case '3':
selectStr = "SELECT AAB001,AAB005 FROM AA001 WHERE AAB002=text";
rs=xx.executeQuery(selectStr);
break;
case '4':
selectStr = "SELECT AAB001,AAB005 FROM AA001 WHERE AAB002=text";
rs=xx.executeQuery(selectStr);
break;
case '5':
text=Integer.parseInt("text");
selectStr = "SELECT AAB001,AAB005 FROM AA001 WHERE AAB001=text";
rs = xx.executeQuery(selectStr);
break;
case '6':
text=Integer.parseInt("text");
selectStr = "SELECT AAB001,AAB005 FROM AA001 WHERE AAB001=text";
rs = xx.executeQuery(selectStr);
break;
}%>
<p align="left"> 单位代码
单位名称
<br>
<%while(rs.next()){
%>
<%=rs.getString("AAB001")%>
<a href="/nssb2/fenlei.jsp?dwbh=<%=rs.getString("AAB001")%>"><%=xxx.db2page(rs.getString("AAB005"))
%></a>
<br>
<% }
%>
</p>
报错如下:
An error occurred between lines: 17 and 47 in the jsp file: /nssb2/e.jsp
Generated servlet error:
D:\Tomcat4.0\work\Standalone\localhost\_\nssb2\e$jsp.java:85: ';' expected.
Switch(dwdm){;
^
An error occurred between lines: 17 and 47 in the jsp file: /nssb2/e.jsp
Generated servlet error:
D:\Tomcat4.0\work\Standalone\localhost\_\nssb2\e$jsp.java:87: 'case' outside switch statement.
case '1':
^
An error occurred between lines: 17 and 47 in the jsp file: /nssb2/e.jsp
Generated servlet error:
D:\Tomcat4.0\work\Standalone\localhost\_\nssb2\e$jsp.java:92: 'case' outside switch statement.
case '2':
^
An error occurred between lines: 17 and 47 in the jsp file: /nssb2/e.jsp
Generated servlet error:
D:\Tomcat4.0\work\Standalone\localhost\_\nssb2\e$jsp.java:96: 'case' outside switch statement.
case '3':
^
An error occurred between lines: 17 and 47 in the jsp file: /nssb2/e.jsp
Generated servlet error:
D:\Tomcat4.0\work\Standalone\localhost\_\nssb2\e$jsp.java:100: 'case' outside switch statement.
case '4':
^
An error occurred between lines: 17 and 47 in the jsp file: /nssb2/e.jsp
Generated servlet error:
D:\Tomcat4.0\work\Standalone\localhost\_\nssb2\e$jsp.java:104: 'case' outside switch statement.
case '5':
^
An error occurred between lines: 17 and 47 in the jsp file: /nssb2/e.jsp
Generated servlet error:
D:\Tomcat4.0\work\Standalone\localhost\_\nssb2\e$jsp.java:109: 'case' outside switch statement.
case '6':
^
7 errors, 1 warning
请问诸位高手,我应该如何修改?