缺少的部分補充如下:
UserModel.selectAllByGroup = SELECT TOP %d \
user_email, u.user_id, user_posts, user_regdate, username, deleted, user_karma, user_from, \
user_website, user_viewemail \
FROM jforum_users u, jforum_user_groups ug \
WHERE u.user_id = ug.user_id \
AND ug.group_id = ?
/**
* @see net.jforum.dao.UserDAO#selectAllByGroup(int, int, int)
*/
public List selectAllByGroup(int groupId, int startFrom, int count)
{
String sql = SystemGlobals.getSql("UserModel.selectAllByGroup");
sql = sql.replaceAll("%d", String.valueOf(startFrom + count));
PreparedStatement p = null;
ResultSet rs = null;
try {
p = JForumExecutionContext.getConnection().prepareStatement(sql);
p.setInt(1, groupId);
rs = p.executeQuery();
return this.processSelectAll(rs);
}
catch (SQLException e) {
throw new DatabaseException(e);
}
finally {
DbUtils.close(rs, p);
}
}