while(rs.next())//如果有下一条记录就循环
{
Items items=new Items();
items.setId(rs.getInt("id"));
items.setName(rs.getString("name"));
items.setCity(rs.getString("city"));
items.setNumber(rs.getInt("number"));
items.setPrice(rs.getInt("price"));
items.setPicture(rs.getString("picture"));
list.add(items);//把一个商品加入集合
feverrun