Example #1
0
  public String deleteUser() {
    if (selectedUser != null) {
      if (!"admin".equals(selectedUser.getLoginName())) {
        List<Account> accountList = accountService.getAllByUser(selectedUser);
        for (Account account : accountList) {
          account.setDestroy(true);
          account.setUser(null);
          accountService.updateAccount(account);
        }
        List<Topic> topicList = messageService.findByUser(selectedUser);
        for (Topic topic : topicList) {
          List<Message> messageList = messageService.findByTopic(topic);
          topic.setLastMessage(null);
          messageService.editTopic(topic);
          for (Message message : messageList) {
            message.setSender(null);
            message.setTopic(null);
            messageService.removeMessage(message);
          }
          messageList.clear();
          messageService.removeTopic(topic);
        }

        topicList.clear();

        userService.removeUser(selectedUser);
        selectedUser = new User();
        return "listUser?faces-redirect=true";
      } else {
        FacesContext.getCurrentInstance()
            .addMessage(
                null,
                new FacesMessage(
                    FacesMessage.SEVERITY_INFO,
                    "Deleting error",
                    "This user has leaded projects or you tried to delete admin! >> nice try! "));
        return "listUser?faces-redirect=false";
      }
    } else {
      FacesContext.getCurrentInstance()
          .addMessage(
              null,
              new FacesMessage(
                  FacesMessage.SEVERITY_INFO,
                  "User has not selected",
                  "You did not select any user!"));
      return "listUser?faces-redirect=false";
    }
  }
Example #2
0
  public static synchronized Message execute_query(Connection con, String receiver, String sender) {
    CallableStatement callFunction = null;
    Message newMessage = new Message();
    try {

      // checking if the connection that is returning is not closed
      if (!con.isClosed()) {
        //				System.out.println("conencted!!");

        // prepare callable function
        callFunction = con.prepareCall(callableFunction);

        // setting the parameter for the callable function
        callFunction.setString(1, receiver);
        callFunction.setString(2, sender);

        callFunction.execute();
        ResultSet result = callFunction.getResultSet();
        result.next();
        if (result.getInt(7) == 1) {
          System.out.println("No message found!");
        } else {
          System.out.println(result.getString(1));
          newMessage.message = result.getString(1);
          newMessage.sender = result.getString(2);
          newMessage.reciever = result.getString(3);
          newMessage.messageID = UUID.fromString(result.getString(4));
          newMessage.timestamp = Timestamp.valueOf(result.getString(5));
        }

        return newMessage;
      }
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      // close the database connection
      if (callFunction != null) {
        try {
          callFunction.close();
          //					System.out.println("Call function closed");
        } catch (SQLException e) {
          // TODO Auto-generated catch block
          e.printStackTrace();
        }
      }
    }
    return null;
  }