rs = pt.executeQuery();
while(rs.next()) {
if(tbNumberList==null){
tbNumberList=new ArrayList<TblPhoneResources>();
}
TblPhoneResources tbNumber=new TblPhoneResources();
tbNumber.setId(rs.getInt("id"));
tbNumber.setPhone(rs.getString("phone"));
tbNumber.setPhoneStatus(rs.getString("phone_status"));
tbNumber.setChannelId(rs.getString("channel_id"));
tbNumber.setChannelName(rs.getString("chanel_name"));
tbNumber.setEnterTime(rs.getString("enter_time"));
tbNumber.setRemarks(rs.getString("remarks"));
tbNumberList.add(tbNumber);
}
} catch (Exception e) {
e.printStackTrace();