SQL sql = sqlBuilder.constructSQLForSelect("Messages",false,new Column[]{new Column("SUBJECT"),new Column("SENDER")},condition,null,null,3,2);
//SQL sql = sqlBuilder.constructSQLForSelect("Messages",true,null,condition,null,null);
logger.debug("通过SQLBuilder构建的SQL: " + sql.getSQLString());
return (List)sqlExecutor.execute(sql);
}finally{
/* 关闭事务 */
transaction.close();
}