关于数组的问题,在线等!
想把数据库中的某个字段的数据取出赋给数组,可是数组的每个元素都是一样的。错误在哪里?
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="school.oper.oper" %>
<%
oper oper = new oper();
int count=oper.getBookCount();
String mc;
String book[] = new String[count];
ResultSet rs=oper.getBookType();
while(rs.next())
{
mc=rs.getString("type_mc");
for(int i=0;i<book.length;i++)
{
book[i]=mc;
}
}
for(int j=0;j<book.length;j++)
{
out.println("book["+j+"]"+book[j]+"<br>");
}
rs.close();
oper.closeConnect();
%>
如果改成这样,错误提示是No data found.又是怎么回事?
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="school.oper.oper" %>
<%
oper oper = new oper();
int count=oper.getBookCount();
String mc;
String book[] = new String[count];
ResultSet rs=oper.getBookType();
while(rs.next())
{
for(int i=0;i<book.length;i++)
{
book[i]=rs.getString("type_mc");;
}
}
for(int j=0;j<book.length;j++)
{
out.println("book["+j+"]"+book[j]+"<br>");
}
rs.close();
oper.closeConnect();
%>