jsp中是这样传递参数吗？

[jancky2001]

<a href="MenuDelete_check.jsp?ID=<%=rs.getInt("Menu_id")%>">删除</a>

[jancky2001]

但是一运行页面就出错：
500 Servlet Exception
java.sql.SQLException: [Oracle][ODBC]Invalid column number <1>.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataInteger(JdbcOdbc.java:3171)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataInteger(JdbcOdbcResultSet.java:5317)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(JdbcOdbcResultSet.java:548)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(JdbcOdbcResultSet.java:566)
at _menudelete__jsp._jspService(/MenuDelete.jsp:82)
at com.caucho.jsp.JavaPage.service(JavaPage.java:74)
at com.caucho.jsp.Page.subservice(Page.java:476)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:176)
at com.caucho.server.http.Invocation.service(Invocation.java:277)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:129)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:158)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:484)


--------------------------------------------------------------------------------
Resin 2.0.3 (built Wed Oct 17 10:11:08 PDT 2001)

[Kosame]

你取的那一列是什么类型的？用rs.getString("Menu_id")试试

[jancky2001]

我用的oracle数据库，menu_id的数据类型是number!

[Kosame]

改成
<a href="MenuDelete_check.jsp?ID=<%=rs.getInt('Menu_id')%>">删除</a>
再试试

[jancky2001]

谢谢各位，我搞定了！

[happynet]

可以这样传递呀！