StringBuffer的使用方法

	//需要重发的消息
	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());
	}