UserListDAO.java from riverock at Krugle

Show UserListDAO.java syntax highlighted

/*
 * org.riverock.forum - Forum portlet
 *
 * Copyright (C) 2006, Riverock Software, All Rights Reserved.
 *
 * Riverock - The Open-source Java Development Community
 * http://www.riverock.org
 *
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public
 * License as published by the Free Software Foundation; either
 * version 2 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * General Public License for more details.
 *
 * You should have received a copy of the GNU General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
 */
package org.riverock.forum.dao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Types;
import java.util.List;
import java.util.ArrayList;

import org.apache.log4j.Logger;

import org.riverock.generic.db.DatabaseAdapter;
import org.riverock.generic.db.DatabaseManager;
import org.riverock.forum.bean.User;
import org.riverock.forum.bean.UserListBean;
import org.riverock.module.exception.ActionException;

/**
 * UserListDAO interface
 */
public class UserListDAO {
    private final static Logger log = Logger.getLogger(UserListDAO.class);

    public UserListBean execute(int start, int range, String keyword) throws ActionException {
        DatabaseAdapter adapter = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            UserListBean userListBean = new UserListBean();
            userListBean.setKeyword(keyword);
            adapter = DatabaseAdapter.getInstance();

            final String searchKeyword = "'%" + keyword + "%'";
            Long countRecord = DatabaseManager.getLongValue(adapter,
                "SELECT count(*) count_records " +
                "FROM   WM_FORUM_USER " +
                "WHERE  u_name LIKE ? " +
                "ORDER BY u_post DESC",
                new Object[]{searchKeyword},
                new int[] {Types.VARCHAR}
            );

            String sql =
                "SELECT u_id,u_name,u_avatar_id,u_email,u_regtime, " +
                "       u_address,u_post,u_lasttime,u_name " +
                "FROM   WM_FORUM_USER " +
                "WHERE  u_name LIKE ? " +
                "ORDER BY u_post DESC";
            ps = adapter.prepareStatement(sql);
            ps.setString(1, searchKeyword);
            rs = ps.executeQuery();

            int count = (countRecord != null ? countRecord.intValue() : 0);

            userListBean.setStart(start);
            userListBean.setRange(range);
            userListBean.setCount(count);
            List<User> userList = new ArrayList<User>();
            if (count > 0) {
                if (start > count) {
                    return null;
                }
                int j = 0;
                boolean isNext = true;
                while (isNext && j++ < start) {
                    isNext = rs.next();
                }

                for (int i = 0; isNext && i < range && !rs.isAfterLast(); i++) {
                    User user = new User();
                    user.setU_id(rs.getInt("u_id"));
                    user.setU_name(rs.getString("u_name"));
                    user.setU_avatar_id(rs.getInt("u_avatar_id"));
                    user.setU_email(rs.getString("u_email"));
                    user.setU_regtime(rs.getTimestamp("u_regtime"));
                    user.setU_address(rs.getString("u_address"));
                    user.setU_post(rs.getInt("u_post"));
                    user.setU_lasttime(rs.getTimestamp("u_lasttime"));
                    setUserRoleDescription( user );
                    userList.add(user);
                    rs.next();
                }
            }
            userListBean.setUsers(userList);
            return userListBean;

        }
        catch (Exception ex) {
            String es = "Error execute userListDAO";
            log.error(es, ex);
            throw new ActionException(es, ex);
        }
        finally {
            DatabaseManager.close(adapter, rs, ps);
            adapter = null;
            rs = null;
            ps = null;
        }
    }

    private void setUserRoleDescription(User user) {
        user.setR_name( "" );
    }
}
See more files for this project here