加这句后就出现问题了:
String aStr="";
aStr=rs_anything.getString(3);javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Column index 3 is out of range.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.anything_jsp._jspService(anything_jsp.java:256)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Column index 3 is out of range.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)
com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
org.apache.jsp.anything_jsp._jspService(anything_jsp.java:185)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
String aStr="";
aStr=rs_anything.getString(3);javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Column index 3 is out of range.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.anything_jsp._jspService(anything_jsp.java:256)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Column index 3 is out of range.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)
com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
org.apache.jsp.anything_jsp._jspService(anything_jsp.java:185)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
解决方案 »
- 一个简单问题!
- jsp访问sqlserver出现了很奇怪的问题了,好急哦,救救我!
- JSP文件里处理一个switch语句遇到的问题,好急~~~~!!~!~!~急急~!~!~!~!
- SQL嵌套改写为hql
- 请各位大侠看看是什么错误!
- 关于分页的问题,在servlet中查询的数据库,在jsp中分页显示,但是首尾页和上一步下一步不许使用连接,只能用按钮,哪位达人能指点一下?
- session到期后如何将相应用户数据从数据库删除?
- 关于参数传递问题
- 请问用JavaScript怎样得到客户端的计算机名称??谢谢!!
- 请问各位大虾怎样才能把jsp和resin连上?
- 关于struts 下拉框取值的问题
- 有做过网站进来看看吧 给个建议
分拿来.呵呵。
还有就是你可以直接把数据库中的字段拿出来读也可以获取值的。
如:rs = stat.executeQuery("select a,b,c from tab");
String aStr = rs.getString("c");
你可以试试,功能是一样的。
aStr=rs_anything.getString(3);
数据库里没有第三个字段,应该是你要查询的返回值。在数据库里加上!
改成
String aStr="";
aStr=rs_anything.getString("aContent");
也不行,所以才郁闷