我在页面中有这样的代码:
<%
int bbbid;
String tempSTR;
bbbid=0;
tempSTR=request.getParameter("boardid");
bbbid=java.lang.Integer.parseInt(tempSTR);
%>
...
<%
ResultSet rs1 = stmt.executeQuery("select boardtel,boardtopics from board where boardid=bbbid"); %>但是出错了,如果单独设置boardid=1还是可以.求指教!!!
报错内容如下
31: masterpwd=board.getBoardMasterpwd();
32: }
33: %>
34: <%
35: ResultSet rs1 = stmt.executeQuery("select boardtel,boardtopics from board where boardid=bbbid");
36: %>
37: <html>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.servlet.ServletException: [Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
<%
int bbbid;
String tempSTR;
bbbid=0;
tempSTR=request.getParameter("boardid");
bbbid=java.lang.Integer.parseInt(tempSTR);
%>
...
<%
ResultSet rs1 = stmt.executeQuery("select boardtel,boardtopics from board where boardid=bbbid"); %>但是出错了,如果单独设置boardid=1还是可以.求指教!!!
报错内容如下
31: masterpwd=board.getBoardMasterpwd();
32: }
33: %>
34: <%
35: ResultSet rs1 = stmt.executeQuery("select boardtel,boardtopics from board where boardid=bbbid");
36: %>
37: <html>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.servlet.ServletException: [Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
tempSTR=request.getParameter("boardid");
bbbid=java.lang.Integer.parseInt(tempSTR);
} catch ( Exception ex ) {
System.out.println(ex);
}
description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Exception in JSP: /xmlist.jsp:1815: } catch ( Exception ex ) {
16: System.out.println(ex);
17: }
18: ResultSet rs1 = stmt.executeQuery("select boardtel,boardtopics from board where boardid=bbbid");
19: %>
20: <%
21: String boardname,masterword,boardmaster,masteremail,masterpwd;
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.servlet.ServletException: [Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.xmlist_jsp._jspService(xmlist_jsp.java:360)
ResultSet rs1 = stmt.executeQuery("select boardtel,boardtopics from board where boardid=bbbid"); %>改成这样试试:
<%
ResultSet rs1 = stmt.executeQuery("select boardtel,boardtopics from board where boardid="+bbbid); %>
ResultSet rs1 = stmt.executeQuery("select boardtel,boardtopics from board where boardid=bbbid");
变量和字符串要区分好
上面这么写是给boardid赋值bbbid,而不是bbbid的值
ResultSet rs1 = stmt.executeQuery("select boardtel,boardtopics from board where boardid="+bbbid);
或(如果boardid为字符型)
ResultSet rs1 = stmt.executeQuery("select boardtel,boardtopics from board where boardid='"+bbbid+"'");