//需要重发的消息
public String initResendMessage(String MNO) {
log.info("开始查询重发消息....");
String sql = "select distinct b.MSGID from push_message a,PUSH_MESSAGE_DETAIL b where b.STATE='0' and b.SENDTIME <=to_char(sysdate+1/(24*60),'yyyy-mm-dd hh24:mi:ss') and to_number(a.livetime)>=(select floor(to_number(sysdate-to_date(a.sendtime,'yyyy-mm-dd hh24:mi:ss'))*24*60*60) as spanSeconds from dual) and a.msgid=b.msgid";
ArrayList<LinkedHashMap<String,String>> messageIDLists = (ArrayList<LinkedHashMap<String,String>>)dbHelper.excuteQuerysql(sql);
StringBuffer tempBuffer = new StringBuffer();
if(messageIDLists.size()>0){
for (HashMap<String,String> map : messageIDLists) {
String tempMessageID = map.get("MSGID");
tempBuffer.append(tempMessageID+",");
}
log.info("重发消息的ID为"+tempBuffer.toString());
log.info("需要重发的消息数:"+messageIDLists.size());
}
return StringUtil.deleteEndComma(tempBuffer.toString());
}
StringBuffer的使用方法
最新推荐文章于 2022-01-22 09:57:38 发布