rs = pt.executeQuery();
while(rs.next()) {
if(tblChannelInfoList==null){
tblChannelInfoList=new ArrayList<TblChannelInfo>();
}
TblChannelInfo tblChannelInfo=new TblChannelInfo();
tblChannelInfo.setId(rs.getInt("id"));
tblChannelInfo.setAgentId(rs.getString("agent_id"));
tblChannelInfo.setChannelId(rs.getString("channel_id"));
tblChannelInfo.setChannelName(rs.getString("channel_name"));
tblChannelInfo.setChannelSort(rs.getString("channel_sort"));
tblChannelInfo.setBelongDistrict(rs.getString("belong_district"));
tblChannelInfo.setBelongArea(rs.getString("belong_area"));
tblChannelInfo.setAgentsPhone(rs.getString("agents_phone"));
tblChannelInfo.setEnterTime(rs.getString("enter_time"));
tblChannelInfo.setRemarks(rs.getString("remarks"));
tblChannelInfoList.add(tblChannelInfo);
}
} catch (Exception e) {
e.printStackTrace();