Examples with MessageBean models.MessageBean used on opensource projects

Example 1 with MessageBean

use of models.MessageBean in project bil372-proje by mertserezli.

the class MessageDAO method getUserMessages.

public static List<MessageBean> getUserMessages(String usernameRequest) throws SQLException {
    List<MessageBean> result = new ArrayList<MessageBean>();
    String searchQuery = "Select * From Messages INNER JOIN Mes_Receivers ON Messages.mid=Mes_Receivers.mid Where receivers @> ARRAY['" + usernameRequest + "']::text[]";
    try {
        ConnectionManager connect = new ConnectionManager();
        currentConnection = connect.getConnection();
        ps = currentConnection.prepareStatement(searchQuery);
        rs = ps.executeQuery();
        while (rs.next()) {
            MessageBean m = new MessageBean();
            m.setmID(rs.getString("mID"));
            m.setReceiver((String[]) rs.getArray("receivers").getArray());
            m.setDate(rs.getDate("date_sent"));
            m.setSender(rs.getString("sent_by"));
            m.setTitle(rs.getString("title"));
            m.setContent(rs.getString("content"));
            result.add(m);
        }
    } finally {
        finalizeConnection(currentConnection, ps, rs);
    }
    return result;
}

Example 2 with MessageBean

use of models.MessageBean in project bil372-proje by mertserezli.

the class MessageDAO method getUserOutbox.

public static List<MessageBean> getUserOutbox(String usernameRequest) throws SQLException {
    List<MessageBean> result = new ArrayList<MessageBean>();
    String searchQuery = "Select * From Messages INNER JOIN Mes_Receivers ON Messages.mid=Mes_Receivers.mid Where sent_by='" + usernameRequest + "'";
    try {
        ConnectionManager connect = new ConnectionManager();
        currentConnection = connect.getConnection();
        ps = currentConnection.prepareStatement(searchQuery);
        rs = ps.executeQuery();
        while (rs.next()) {
            MessageBean m = new MessageBean();
            m.setmID(rs.getString("mid"));
            m.setReceiver((String[]) rs.getArray("receivers").getArray());
            m.setDate(rs.getDate("date_sent"));
            m.setSender(rs.getString("sent_by"));
            m.setTitle(rs.getString("title"));
            m.setContent(rs.getString("content"));
            result.add(m);
        }
    } finally {
        finalizeConnection(currentConnection, ps, rs);
    }
    return result;
}

Example 3 with MessageBean

use of models.MessageBean in project bil372-proje by mertserezli.

the class MessageServlet method doGet.

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, java.io.IOException {
    try {
        PrintWriter pw = response.getWriter();
        UserBean currentUser = (UserBean) request.getSession().getAttribute("currentSessionUser");
        java.sql.Date date = new java.sql.Date(Calendar.getInstance().getTime().getTime());
        MessageBean message = new MessageBean();
        message.setSender(currentUser.getUsername());
        message.setReceiver(request.getParameter("receivers").split(","));
        message.setDate(date);
        message.setTitle(request.getParameter("title"));
        message.setContent(request.getParameter("content"));
        boolean success = MessageDAO.sendMessage(message);
        if (success) {
            for (String receiver : message.getReceiver()) {
                NotificationBean notification = new NotificationBean();
                notification.setUsername(receiver);
                notification.setDate(date);
                notification.setNotification("(Mesaj)" + message.getSender() + " adli kullanici size mesaj gonderdi");
                NotificationDAO.sendNotification(notification);
            }
            pw.println("Message is sent succesfully");
            return;
        }
        pw.println("Message couldn't sent");
    } catch (Exception e) {
        e.printStackTrace();
    }
}