Francrt's questions

I need a couple of exclusive Queries to check an "availability" factor within a db.

The query is okay so far I have been raising it in various ways and I think this is the most correct but it keeps giving me an error

    from Usuario judge where judge.juez = 1 and judge.idusuario  not in Usuariomaraton

Could someone tell me what is wrong with the query that is why I am not able to extract what I am looking for (All users that have judge value 1 and are not in the Usuariomaraton table).

We have a DB with a User table that has a column of type Tinyint (Since it is a boolean) and we are working with Hibernate. My User model has a variable, autogenerated, of type Byte to designate that user value (setters & getters).

The thing is that inside this method:

    public boolean CreateJudge(int idusuario){
    boolean newJ = false;

    try{
        newJ = true;
        this.session = Hibernate.getSessionFactory().getCurrentSession();
        Usuario newJudge = new Usuario(master.setJuez((byte) 1), idusuario);
        session.save(newJudge);
        session.close();

    }catch (Exception e){ 
        e.printStackTrace();
    }     
    return newJ;
}

What I want is to be able to give that value 1 to the byte and thus force that user to be a judge.

Any ideas? The proposed code does not work and I have already tried:

   Usuario newJudge = new Usuario(master.setJuez(1), idusuario);

The goal is to do a LogIn through an HQL, I'm currently at this point in the code:

    public boolean LogIn(String nickname, String password){
        boolean inAnswer = false;

            try{
                inAnswer = true;
                this.session = Hibernate.getSessionFactory().getCurrentSession();
                Query login = session.createQuery ("From Usuario usser  "
                            + "where usser.Nickname ='"+nickname+"' & usser.Password ='"+password+"'");

            }catch (Exception e){
                e.printStackTrace();
            }
        return inAnswer;
    }

My question is, can I implement an if/switch inside that try that does a comparison of the nickname and password variables with the login object? Something like:

        if(login.equals(String nickname, String password))

I am trying to generate a ArrayListusers from a DB, the case is that when executing the PreparedStatementit returns a NullPointerand tells me that the connection object is null, it is something that does not happen to me in other statements that I have and they work.

I leave the code of Arraythe and the code of the class Conecta(Objeto Conect):

      public class Usuario {

      private int id;
      private String nickName;
      private String password;    
      private String Email; 
      private ConectaDB conexion;

      public ArrayList<Usuario> getUsuarios(){
      Connection con = null;
      con = conexion.conecta();
      ArrayList<Usuario> Usuarios = new ArrayList();                    
      PreparedStatement getData = conexion.preparedStatement("SELECT IDUsuario, Nickname, Password, Email FROM usuario");           
      ResultSet data;

      try{            
      data = getData.executeQuery();
      while(data.next()){
        id = data.getInt(1);
        nickName = data.getString(2);
        password = data.getString(3);
        Email = data.getString(4);
      Usuario usser = new Usuario(data.getInt(1), data.getString(2), data.getString(3), data.getString(4));
      Usuarios.add(usser);
      }
       return Usuarios;
  } catch(SQLException e){              
    }  return Usuarios;
} 

And here is the code for the Connect class:

  public class ConectaDB {

    public static Connection conecta(){

          Connection conecta=null;

          try{
              Class.forName("com.mysql.jdbc.Driver");
              String servidor="jdbc:mysql://xxxxxx:xxxx/bbdd_g1"; //conectamos a nuestra propia maquina
              String usuario="admin_g1";
              String password="a7586";
              //inicializamos objeto conecta, del tipo connection
              conecta = (Connection)DriverManager.getConnection(servidor, usuario, password);

          }catch(ClassNotFoundException e)
          {
              System.out.println(e.getMessage());
          }
            catch(Exception e) //capturar el resto de exceptions
          {
              System.out.println(e.getMessage());
          }finally{
              return conecta;//como el default de los case, pero se ejecuta si o si
          }

    }    

    public PreparedStatement preparedStatement(String x) {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }
}

Thanks for the help!