@Override
    public User authencation(String username, int password) {
        try {
            if (username == null | username == "") {
                throw new NullPointerException("Name is empty or null.");
            }
            if (password <= 0) {
                throw new NullPointerException("Wrong password");
            }
            Connection con = ConnectorDatabase.getDBConnection();
            String sql = "select * from \"CHAT_XE\".\"USER\" WHERE USERNAME = ? AND PASSWORD = ?";
            PreparedStatement pstm = con.prepareStatement(sql);
            pstm.setString(1, username);
            pstm.setInt(2, password);
            int id = -999;
            String usernameUser = "";
            String status = "";
            String firstname = "";
            String surname = "";

            ResultSet rs = pstm.executeQuery();
            while (rs.next()) {
                id = rs.getInt("ID");
                usernameUser = rs.getString("USERNAME");
                status = rs.getString("STATUS");
                firstname = rs.getString("FIRSTNAME");
                surname = rs.getString("SURNAME");
            }
            if(id == -999){
                return null;
            }
            rs.close();
            pstm.close();
            con.close();
            return new User(id, usernameUser, STATUS_USER.valueOf(status), firstname, surname);
        } catch (SQLException ex) {
            ex.printStackTrace();
            throw new NullPointerException("SQL authencation failed.");
        }

    }