SQL sql = sqlBuilder.constructSQLForSelect("Messages", false, null, null, "", "SendTime desc", (getPageOffset()-1)*getPageRows(), getPageRows());
/* 执行SQL语句,并返回结果 */
List messages = (List)sqlExecutor.execute(sql, Message.class);
Iterator messagesIT = messages.iterator();
while(messagesIT.hasNext()){
Message message = (Message)messagesIT.next();
// message.setEmail(HTMLHelper.toHTMLString(message.getEmail()));
//System.out.println("message.getRevertContent():"+message.getRevertContent());
// message.setRevertContent(HTMLHelper.toHTMLString(message.getRevertContent()));
// message.setReverter(HTMLHelper.toHTMLString(message.getReverter()));
// message.setSender(HTMLHelper.toHTMLString(message.getSender()));
// message.setSubject(HTMLHelper.toHTMLString(message.getSubject()));
// message.setContent(HTMLHelper.toHTMLString(message.getContent()));
message.setSendTime(DateTimeHelper.formatDateTimetoString(message.getSendTime()));
message.setRevertTime(DateTimeHelper.formatDateTimetoString(message.getRevertTime()));
}
return messages;
}finally{
transaction.close();
}