String sql = "select * from field where sort_id > '"+now_id+"' and sort_id < 5";
ResultSet rs = act_fieldsort.select(sql);
while(rs.next())
{
int sort_ids = rs.getInt("sort_id");
out.println(sort_ids);
}
我怎么把while循环的值放到一个string类型的数组中去呢?
ResultSet rs = act_fieldsort.select(sql);
while(rs.next())
{
int sort_ids = rs.getInt("sort_id");
out.println(sort_ids);
}
我怎么把while循环的值放到一个string类型的数组中去呢?
像这样:
List l=new ArrayList();
while(rs.next())
{
String sort_ids = rs.getString("sort_id");
l.add(sort_ids);
out.println(sort_ids);
}
String ids[]=null;
if(l.size()>0)
ids = new String[l.size()];
for(int i=0;i<l.size;i++)
{
ids[i] = (String)l.get(i);
}
int b=0;
while(rs.next())
{
// int sort_ids = rs.getInt("sort_id");
a[b]=rs.getInt("sort_id");
b++;
}