rs = pt.executeQuery();
while (rs.next()) {
if (tbSMResultList == null) {
tbSMResultList = new ArrayList<TbSMResult>();
}
TbSMResult tsr = new TbSMResult();
tsr.setID(rs.getInt("ID"));
tsr.setSM_Type(rs.getInt("SM_Type"));
tsr.setSM_ID(rs.getInt("SM_ID"));
tsr.setSubTime(rs.getString("SubTime"));
tsr.setOrgAddr(rs.getString("OrgAddr"));
tsr.setDestAddr(rs.getString("DestAddr"));
tsr.setSM_Content(rs.getString("SM_Content"));
tsr.setSendTime(rs.getString("SendTime"));
tsr.setMsgID(rs.getString("MsgID"));
tsr.setService_ID(rs.getString("Service_ID"));
tsr.setFee_UserType(rs.getString("Fee_UserType"));
tsr.setFee_Terminal_ID(rs.getString("Fee_Terminal_ID"));
tsr.setMsg_Fmt(rs.getInt("Msg_Fmt"));
tsr.setFeeType(rs.getString("FeeType"));
tsr.setFeeCode(rs.getInt("FeeCode"));
tsr.setValid_Time(rs.getString("Valid_Time"));
tsr.setSent_Time(rs.getString("Sent_Time"));
tsr.setMsg_Status(rs.getString("Msg_Status"));
tsr.setTryTimes(rs.getInt("TryTimes"));
tsr.setRecv_Status(rs.getString("Recv_Status"));
tsr.setRecv_Time(rs.getString("Recv_Time"));
tsr.setReserve1(rs.getInt("Reserve1"));
tsr.setReserve2(rs.getString("Reserve2"));
tsr.setCreatorID(rs.getString("CreatorID"));
tsr.setSMType(rs.getInt("SMType"));
tsr.setMessageID(rs.getString("MessageID"));
tsr.setDestAddrType(rs.getInt("DestAddrType"));
tbSMResultList.add(tsr);
}
} catch (Exception e) {