Package org.jresearch.gossip.beans.forum

Examples of org.jresearch.gossip.beans.forum.Message


     */
    public Message getMessage(String mid) throws SQLException {
        Connection connection = this.dataSource.getConnection();
        PreparedStatement st = connection.prepareStatement(dbDriver
                .getQueries().getForumQueries().getSql_GET_MESSAGE());
        Message mess = null;
        ResultSet rs = null;

        try {
            st.setInt(1, Integer.parseInt(mid));
            rs = st.executeQuery();

            if (rs.next()) {
                mess = new Message();
                mess.setCentents(rs.getString("centents"));
                mess.setHeading(rs.getString("heading"));
                mess.setId(rs.getInt("id"));
                mess.setIntime(rs.getDate("intime"));
                mess.setIp(rs.getString("ip"));
                mess.setSender(rs.getString("sender"));
            }
        } finally {
            if (rs != null) {
                rs.close();
            }
View Full Code Here


        try {
            st.setInt(1, forum.getForumid());
            rs = (ResultSet) st.executeQuery();

            Message last = new Message();

            if (rs.next()) {
                last.setSender(rs.getString("m_from"));
                last.setIntime(rs.getTimestamp("t_stamp"));
                last.setCentents(rs.getString("cont"));
                last.setThreadSort(rs.getInt("sortby"));
                last.setId(rs.getInt("id"));
                forum.setLastMessThreadId(rs.getInt("tid"));
            }

            forum.setLastMessage(last);
        } finally {
View Full Code Here

        try {
            st.setInt(1, thread.getThreadid());
            rs = (ResultSet) st.executeQuery();

            Message last = new Message();

            if (rs.next()) {
                last.setSender(rs.getString("sender"));
                last.setIntime(rs.getTimestamp("intime"));
                last.setCentents(rs.getString("centents"));
                last.setId(rs.getInt("id"));
            }

            thread.setLastMessage(last);

            // TODO work around bug 863191
View Full Code Here

        try {
            st.setInt(1, topic.getThreadid());
            rs = (ResultSet) st.executeQuery();

            Message root = new Message();

            if (rs.next()) {
                root.setSender(rs.getString("sender"));
                root.setIntime(rs.getTimestamp("t_stamp"));
                root.setCentents(rs.getString("centents"));
                root.setId(rs.getInt("id"));
                root.setHeading(rs.getString("subject"));
                root.setIp(rs.getString("ip"));
                root.setThreadid(rs.getInt("tid"));
                root.setThreadSort(rs.getInt("sortby"));
            }

            topic.setRootMessage(root);
            topic.setSubject(root.getHeading());
        } finally {
            if (rs != null) {
                rs.close();
            }
        }
View Full Code Here

            for (int i = 0; i < groups.size(); i++) {
                ArrayList forums = ((Group) groups.get(i)).getForums();

                for (int j = 0; j < forums.size(); j++) {
                    Message last = ((Forum) forums.get(j)).getLastMessage();
                    last.setSenderInfo(userdao.getSenderInfo(
                            last.getSender()));
                }
            }

            request.setAttribute(IConst.REQUEST.GROUPS_KEY, groups);
        } catch (SQLException sqle) {
View Full Code Here

           

            Iterator it = recordsData.getRecords().iterator();

            while (it.hasNext()) {
                Message mess = ((Topic) it.next()).getLastMessage();
                mess.setSenderInfo(userdao.getSenderInfo(mess.getSender()));
            }

            request.setAttribute(IConst.REQUEST.RECORDS_DATA, recordsData);

            if (dao.checkMod(fid, user)) {
View Full Code Here

            dao.fillLastUpdatedTopicList(user, recordsData, lform.getBlock());
            Iterator it = recordsData.getRecords().iterator();

            while (it.hasNext()) {
                NewTopic nt = (NewTopic) it.next();
                Message mess = nt.getLastMessage();
                mess.setSenderInfo(userdao.getSenderInfo(mess.getSender()));
                nt.setMod_flag(dao.checkMod(nt.getForumid(), user) ? 1 : 0);
            }

            request.setAttribute(IConst.REQUEST.RECORDS_DATA, recordsData);
        } catch (SQLException sqle) {
View Full Code Here

      throws SystemException {
    ForumDAO dao = ForumDAO.getInstance();
    ProcessMessageForm pmForm = (ProcessMessageForm) form;
    try {
     
      Message mess = dao.getMessage(pmForm.getMid());
      log(request, "logs.LOG14", "mid=" + pmForm.getMid());
      if (mess != null) {
        dao.deleteMessage(pmForm);
      }
    } catch (SQLException sqle) {
View Full Code Here

      dao.fillMessagesList(user, recordsData, ptForm);
      Iterator it = recordsData.getRecords().iterator();
      boolean attachEnabled = Configurator.getInstance().getBoolean(
          IConst.CONFIG.ENABLE_FILE_UPLOAD);
      if (it.hasNext()) {
        Message mess = (Message) it.next();
        currThread.setSubject(mess.getHeading());
        mess.setSenderInfo(userdao.getSenderInfo(mess.getSender()));
        if (attachEnabled) {
          mess.setAttachments(dao.getAttachmentsInfo(mess.getId()));
        }
      } else {
        return (new ActionForward("/ShowForum.do?fid="
            + ptForm.getFid(), true));
      }
      while (it.hasNext()) {
        Message mess = (Message) it.next();
        mess.setSenderInfo(userdao.getSenderInfo(mess.getSender()));
        if (attachEnabled) {
          mess.setAttachments(dao.getAttachmentsInfo(mess.getId()));
        }
      }

      request.setAttribute(IConst.REQUEST.RECORDS_DATA, recordsData);
      request.setAttribute(IConst.REQUEST.CURR_THREAD, currThread);
View Full Code Here

          && (!isUserMod)) {
        return (mapping.findForward(IConst.TOKEN.DENIED));
      }
      session.setAttribute(IConst.REQUEST.CURR_THREAD, currThread);
      currThread.setSubject(dao.getThreadSubject(pmForm.getTid()));
      Message mess = dao.getMessage(pmForm.getMid());
      if (mess == null) {
        return (new ActionForward("/ShowThread.do?fid="
            + pmForm.getFid() + "&tid=" + pmForm.getTid()
            + "&block=" + pmForm.getBlock(), true));
      } else {
View Full Code Here

TOP

Related Classes of org.jresearch.gossip.beans.forum.Message

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.