Doubt User table and Friend table

Question

Eae guys, I need help, I’m a beginner in java, and I’m doing a college job where it’s going to be a mini social network, at the beginning we will make user registration, within the class Beans, user receives a listfriends I’m having a doubt.

my question, how I will relate this in the DAO and if I need to add some data in the table USUARIO_AMIGO with status etc ???

Can someone give me an example.

Tables in the USUARIO database and the other AMIGO_USUARIO.

             Tabela USUARIO

+-----------+------------------+----------+----------------+
| CD_LOGIN  | NOME_DE_USUARIO  |  SENHA   | EMAIL_USUARIO  |
+-----------+------------------+----------+----------------+
|       1   |      test        |   test   |       test     |
|       2   |      test        |   test   |       test     |
+---------+----------+----------+--------------------------+

              Tabela AMIGO_USUARIO

+-----------+---------------+-----------------+
| CD_AMIGO  | EMAIL_USUARIO | EMAIL_USUARIO2  |
+-----------+---------------+-----------------+
|       1   |      test     |      test       |    
|       2   |      test     |      test       |           
+---------+----------+----------+-------------+

Answer 1

You should have in the associative table, the status. And another important point, use user code and not email. If one day the user wants to change the email, you will have problems.

Tabela AMIGO_USUARIO

+-----------+---------------+-----------------+-------------+
| CD_AMIGO  | CD_USUARIO1   | CD_USUARIO2     |   status    |
+-----------+---------------+-----------------+-------------+
|       1   |      test     |      test       |    1        |
|       2   |      test     |      test       |    0        |
+-----------+---------------+-----------------+-------------+

In DAO you don’t relate the data, you just access it. You will have the relationship in Model, it will represent the bank entity in your application. Ex:

public class Amizade {
        public Amigo amigo1;
        public Amigo amigo2;
        int status;
    }
    // Essa abaixo é a DAO
    public class AmizadeRepository{
       public ArrayList<Amizade> fetchAll(){
        // fazer a consulta e retornar a lista
       }
    }