关于数据库查询多条纪录问题
下面是我的主要代码:
<% String sql="";
sql="select a,b,c,d,e from test
LinkedList LCHECK=OPDB.executeQuery(sql);
if(LCHECK.size()!=0)
{
out.print("<p>下面是查询结果:</p>");
out.print("<p>纪录的行数:"+LCHECK.size());
Vector[] Rows=new Vector[LCHECK.size()];
for(int i=0;i<=LCHECK.size();i++)
{
Rows[i] = (Vector)LCHECK.get(i);
}
%>
//输出这些记录
<%}else{
out.print("数据库为空:"+"<br>");
}%>
用Vector Rows=(Vector)LCHECK.get(0);查一条纪录没问题,但用上面的方法时出现下面错误提示,我改了半天也也没搞对,各位大哥帮帮忙吧!
org.apache.jasper.JasperException: Index: 5, Size: 5
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause
java.lang.IndexOutOfBoundsException: Index: 5, Size: 5
java.util.LinkedList.entry(LinkedList.java:360)
java.util.LinkedList.get(LinkedList.java:303)
org.apache.jsp.wyl.qyzczjtj_jsp._jspService(qyzczjtj_jsp.java:95)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)