private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         

        try {
            c = "select * from users where email='" + jTextField1.getText() + "' and password='" + (String) jPasswordField2.getText() + "'";
            stm = con.prepareStatement(c);
            rs = stm.executeQuery();
            if (rs.next()) {
                LoginAndSignUp.LoggedEmail = rs.getString("email");
                new MailBox().setVisible(true);
                con.close();
            } else {
                JOptionPane.showMessageDialog(null, "No Such User Found", "Warning", JOptionPane.WARNING_MESSAGE);
            }
        } catch (SQLException e) {
            System.out.println(e);
        }
      }

 public void SortByDate() {
        refreshTable();
        DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
        for (int i = 0; i < mails.size(); i++) {
            date[i] = mails.get(i).getDate();
        }

        int temp = 0;
        int n = mails.size();
        for (int i = 0; i < n; i++) {
            for (int j = 1; j < (n - i); j++) {
                if (date[j - 1] > date[j]) {

                    temp = date[j - 1];
                    date[j - 1] = date[j];
                    date[j] = temp;
                }

            }
        }

        for (int i = 0; i < n; i++) {
            for (int j = 0; j < n; j++) {
                if (date[i] == mails.get(j).getDate()) {
                   /* Object[] row = new Object[4];
                    row[0] = mails.get(j).getDate();
                    row[1] = mails.get(j).getSender();
                    row[2] = mails.get(j).getSubjectA();
                    row[3] = mails.get(j).getBodyA();
                    model.addRow(row);  */
                }
            }

        }
    }

void SortBySender() {
        refreshTable();
        String sender[] = new String[mails.size()];
        for (int i = 0; i < mails.size(); i++) {
            sender[i] = mails.get(i).getSender();
        }
        mergeSort(sender, 0, sender.length - 1);
        DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
        for (int i = 0; i < mails.size(); i++) {

            for (int j = 0; j < mails.size(); j++) {
                if (sender[i] == mails.get(j).getSender()) {
                    Object[] row = new Object[4];
                    row[0] = mails.get(j).getDate();
                    row[1] = mails.get(j).getSender();
                    row[2] = mails.get(j).getSubjectA();
                    row[3] = mails.get(j).getBodyA();
                    model.addRow(row);
                }
            }

        }
    }

    public static void mergeSort(String[] a, int from, int to) {
        if (from == to) {
            return;
        }
        int mid = (from + to) / 2;

        mergeSort(a, from, mid);
        mergeSort(a, mid + 1, to);
        merge(a, from, mid, to);
    }

    public static void merge(String[] a, int from, int mid, int to) {
        int n = to - from + 1;
        String[] b = new String[n];
        int i1 = from;
        int i2 = mid + 1;
        int j = 0;

        while (i1 <= mid && i2 <= to) {
            if (a[i1].compareTo(a[i2]) < 0) {
                b[j] = a[i1];
                i1++;
            } else {
                b[j] = a[i2];
                i2++;
            }
            j++;
        }

        while (i1 <= mid) {
            b[j] = a[i1];
            i1++;
            j++;
        }

        while (i2 <= to) {
            b[j] = a[i2];
            i2++;
            j++;
        }

        for (j = 0; j < n; j++) {
            a[from + j] = b[j];
        }

    }

void SortByDate() {
       refreshTable();
       DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
       for (int i = 0; i < mails.size(); i++) {
           date[i] = mails.get(i).getDate();
       }

       int temp = 0;
       int n = mails.size();
       for (int i = 0; i < n; i++) {
           for (int j = 1; j < (n - i); j++) {
               if (date[j - 1] > date[j]) {

                   temp = date[j - 1];
                   date[j - 1] = date[j];
                   date[j] = temp;
               }

           }
       }

       for (int i = 0; i < n; i++) {
           for (int j = 0; j < n; j++) {
               if (date[i] == mails.get(j).getDate()) {
                   Object[] row = new Object[4];
                   row[0] = mails.get(j).getDate();
                   row[1] = mails.get(j).getSender();
                   row[2] = mails.get(j).getSubjectA();
                   row[3] = mails.get(j).getBodyA();
                   model.addRow(row);
               }
           }

       }
   }