/** @see com.mob.forum.dao.LuceneDAO#getPostsToIndex(LuceneReindexArgs, int, int) */ public List getPostsToIndex(int fromPostId, int toPostId) { List l = new ArrayList(); PreparedStatement p = null; ResultSet rs = null; try { p = JForumExecutionContext.getConnection() .prepareStatement(SystemGlobals.getSql("SearchModel.getPostsToIndexForLucene")); p.setInt(1, fromPostId); p.setInt(2, toPostId); rs = p.executeQuery(); while (rs.next()) { l.add(this.makePost(rs)); } } catch (SQLException e) { throw new DatabaseException(e); } finally { DbUtils.close(rs, p); } return l; }
// Permissions public void permissions() { int id = this.request.getIntParameter("group_id"); PermissionControl pc = new PermissionControl(); pc.setRoles(DataAccessDriver.getInstance().newGroupSecurityDAO().loadRoles(id)); String xmlconfig = SystemGlobals.getValue(ConfigKeys.CONFIG_DIR) + "/permissions.xml"; List sections = new XMLPermissionControl(pc).loadConfigurations(xmlconfig); GroupDAO gm = DataAccessDriver.getInstance().newGroupDAO(); this.context.put("sections", sections); this.context.put("group", gm.selectById(id)); this.setTemplateName(TemplateKeys.GROUP_PERMISSIONS); }
/** @see com.mob.forum.dao.LuceneDAO#getPostsData(int[]) */ public List getPostsData(int[] postIds, String orderDir) { if (postIds.length == 0) { return new ArrayList(); } List l = new ArrayList(); PreparedStatement p = null; ResultSet rs = null; try { String sql = SystemGlobals.getSql("SearchModel.getPostsDataForLucene"); sql = sql.replaceAll(":posts:", this.buildInClause(postIds)); if ("ASC".equals(orderDir)) { sql = sql + " ORDER BY p.post_id"; } else { sql = sql + " ORDER BY p.post_id DESC"; } p = JForumExecutionContext.getConnection().prepareStatement(sql); rs = p.executeQuery(); while (rs.next()) { Post post = this.makePost(rs); post.setPostUsername(rs.getString("username")); l.add(post); } } catch (SQLException e) { throw new DatabaseException(e); } finally { DbUtils.close(rs, p); } return l; }
/** @see com.mob.forum.dao.LuceneDAO#firstPostIdByDate(java.util.Date) */ public int firstPostIdByDate(Date date) { return this.getPostIdByDate(date, SystemGlobals.getSql("SearchModel.firstPostIdByDate")); }