### Question:
UsersJdbcAuthzRepository extends AbstractJdbcRepository implements UsersAuthzRepository { @Override public Users findByUsername(String username) { String sql = " select * from users where username = ? "; final List<Users> list = this.jdbcTemplate.query(sql, usersRowMapper, username); return list.isEmpty() ? null : list.get(0); }  @Override List<Users> findUsersByUsername(String username); @Override List<Roles> findAvailableRolesList(); @Override Users findByUsername(String username); @Override int saveUsers(final Users users); @Override Roles findRolesByGuid(String guid); @Override void insertUserRoles(final int userId, final int rolesId); @Override List<Roles> findUsersRolesList(String usersGuid); @Override List<String> findPermissionsByRoles(String rolesGuid);  }### Answer:
@Test public void findByUsername() throws Exception { final Users users = usersJdbcRepository.findByUsername("lise"); assertNull(users); }