org.forumj.dbextreme.db.dao.FJSubscribeDao.java Source code

Introduction

Here is the source code for org.forumj.dbextreme.db.dao.FJSubscribeDao.java

Source

/*
 * Copyright Andrew V. Pogrebnyak
 * 
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 *     http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.forumj.dbextreme.db.dao;

import static org.forumj.common.db.entity.IFJSubscribe.*;
import static org.forumj.dbextreme.db.dao.tool.QueryBuilder.*;

import java.io.IOException;
import java.sql.*;
import java.util.*;

import org.apache.commons.configuration.ConfigurationException;
import org.forumj.common.db.entity.*;
import org.forumj.common.web.Locale;
import org.forumj.dbextreme.db.entity.*;

/**
 * 
 * @author <a href="mailto:an.pogrebnyak@gmail.com">Andrew V. Pogrebnyak</a>
 */
public class FJSubscribeDao extends FJDao {

    public List<IFJSubscribe> findAll(IUser user, Integer active)
            throws SQLException, ConfigurationException, IOException {
        List<IFJSubscribe> result = new ArrayList<IFJSubscribe>();
        String query = getLoadSubscribesQuery();
        Connection conn = null;
        PreparedStatement st = null;
        try {
            conn = getConnection();
            st = conn.prepareStatement(query);
            st.setLong(1, user.getId());
            st.setInt(2, active);
            ResultSet rs = st.executeQuery();
            while (rs.next()) {
                IFJSubscribe subscribe = new FJSubscribe();
                subscribe.setId(rs.getLong(ID_FIELD_NAME));
                subscribe.setUser(user);
                subscribe.setTitleId(rs.getLong(TITLE_ID_FIELD_NAME));
                subscribe.setHead(rs.getString(HEAD_FIELD_NAME));
                subscribe.setStart(rs.getDate(START_DATE_FIELD_NAME));
                subscribe.setEnd(rs.getDate(END_DATE_FIELD_NAME));
                subscribe.setKey(rs.getLong(KEY_FIELD_NAME));
                subscribe.setType(rs.getInt(TYPE_FIELD_NAME));
                subscribe.setActive(rs.getInt(ACTIVE_FIELD_NAME));
                result.add(subscribe);
            }
        } finally {
            readFinally(conn, st);
        }
        return result;
    }

    public void create(IFJSubscribe subscribe) throws ConfigurationException, SQLException, IOException {
        String query = getCreateSubscribeQuery();
        Connection conn = null;
        PreparedStatement st = null;
        try {
            conn = getConnection();
            st = conn.prepareStatement(query);
            st.setLong(1, subscribe.getUser().getId());
            st.setLong(2, subscribe.getTitleId());
            st.setDate(3, new java.sql.Date(subscribe.getStart().getTime()));
            st.setLong(4, subscribe.getKey());
            st.setInt(5, subscribe.getType());
            st.executeUpdate();
        } finally {
            readFinally(conn, st);
        }
    }

    public void deleteByTitleId(long titleId, IUser user) throws ConfigurationException, SQLException, IOException {
        String query = getDeleteSubscribeByTitleIdQuery();
        Connection conn = null;
        PreparedStatement st = null;
        try {
            conn = getConnection();
            st = conn.prepareStatement(query);
            st.setLong(1, user.getId());
            st.setLong(2, titleId);
            st.executeUpdate();
        } finally {
            readFinally(conn, st);
        }
    }

    public void deleteById(long id, IUser user) throws ConfigurationException, SQLException, IOException {
        String query = getDeleteSubscribeByIdQuery();
        Connection conn = null;
        PreparedStatement st = null;
        try {
            conn = getConnection();
            st = conn.prepareStatement(query);
            st.setLong(1, user.getId());
            st.setLong(2, id);
            st.executeUpdate();
        } finally {
            readFinally(conn, st);
        }
    }

    public void deleteByKey(long key) throws ConfigurationException, SQLException, IOException {
        String query = getDeleteSubscribeByKeyQuery();
        Connection conn = null;
        PreparedStatement st = null;
        try {
            conn = getConnection();
            st = conn.prepareStatement(query);
            st.setLong(1, key);
            st.executeUpdate();
        } finally {
            readFinally(conn, st);
        }
    }

    public boolean isKeyPresent(Integer key) throws SQLException, ConfigurationException, IOException {
        String query = getIsSubscribeKeyPresentQuery();
        Connection conn = null;
        PreparedStatement st = null;
        try {
            conn = getConnection();
            st = conn.prepareStatement(query);
            st.setInt(1, key);
            ResultSet rs = st.executeQuery();
            if (rs.next()) {
                return true;
            } else {
                return false;
            }
        } finally {
            readFinally(conn, st);
        }
    }

    /**
     *  ?  ?  
     *
     * @param unknown_type $idUser
     * @return unknown
     * @throws SQLException 
     * @throws ConfigurationException 
     * @throws IOException 
     */
    public Boolean isUserSubscribed(Long threadId, Long userId)
            throws ConfigurationException, SQLException, IOException {
        String query = getIsUserSubscribedQuery();
        Connection conn = null;
        PreparedStatement st = null;
        try {
            conn = getConnection();
            st = conn.prepareStatement(query);
            st.setLong(1, userId);
            st.setLong(2, threadId);
            ResultSet rs = st.executeQuery();
            if (rs.next()) {
                return true;
            }
        } finally {
            readFinally(conn, st);
        }
        return false;
    }

    public List<IUser> getSubscribedUsers(Long threadId, Long userId)
            throws ConfigurationException, SQLException, IOException {
        List<IUser> result = new ArrayList<IUser>();
        String query = getSubscribersMailQuery();
        Connection conn = null;
        PreparedStatement st = null;
        try {
            conn = getConnection();
            st = conn.prepareStatement(query);
            st.setLong(1, threadId);
            st.setLong(2, userId);
            ResultSet rs = st.executeQuery();
            while (rs.next()) {
                IUser user = new User();
                user.setEmail(rs.getString("mail"));
                int lang = rs.getInt("lang");
                if (lang != 0) {
                    user.setLanguge(Locale.valueOfInteger(lang));
                }
                result.add(user);
            }
        } finally {
            readFinally(conn, st);
        }
        return result;
    }
}