日期:2014-05-17 浏览次数:20690 次
public ArrayList getRedSeat()
{
ArrayList al=new ArrayList();
try {
ct=new ConnDB().getCon();
sm=ct.createStatement();
rs=sm.executeQuery("select uid,bhang,blie from ubuy where bspend>0");
while(rs.next())
{
UbuyBean ub=new UbuyBean();
ub.setUid(rs.getInt(1));
ub.setBhang(rs.getInt(2));
ub.setBlie(rs.getInt(3));
//System.out.println("ub.getUid()="+ub.getUid());
al.add(ub);
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally{
mbc.close();
}
return al;
}