public Actor buscarPorCodUsuario(String username) { if (username == null) { return null; } Query query = getSession().createSQLQuery( "select a.CO_ATOR as \"cod\", a.CO_USUARIO as \"codUsuario\", a.NO_ATOR as \"nome\", a.DS_EMAIL as \"email\" " + " FROM " + Constants.SCHEMA + ".VW_ATOR a " + " WHERE UPPER(trim(a.CO_USUARIO)) = :codUsuario"); query.setParameter("codUsuario", username.toUpperCase()); Object[] dados = (Object[]) query.uniqueResult(); Actor actor = null; if (dados != null) { actor = new Actor(); if (dados[0] != null) { actor.setCod(((Number) dados[0]).intValue()); } actor.setCodUsuario(dados[1].toString()); actor.setNome((String) dados[2]); actor.setEmail((String) dados[3]); } return actor; }
@Override public Object transformTuple(Object[] objects, String[] strings) { if (objects == null || objects.length == 0) { return null; } Actor actor = new Actor(); for (int i = 0; i < strings.length; i += 1) { Object rawObject = objects[i]; switch (strings[i]) { case COD: actor.setCod(castToInteger(rawObject)); break; case COD_USUARIO: actor.setCodUsuario(String.valueOf(rawObject)); break; case NOME: actor.setNome((String) rawObject); break; case EMAIL: actor.setEmail((String) rawObject); break; default: } } return actor; }
@Override public Object transformTuple(Object[] objects, String[] strings) { if (objects == null || objects.length == 0) { return null; } Actor actor = new Actor(); for (int i = 0; i < strings.length; i += 1) { Object rawObject = objects[i]; switch (strings[i]) { case COD: actor.setCod(castToInteger(rawObject)); break; case COD_USUARIO: actor.setCodUsuario(String.valueOf(rawObject)); break; case NOME: actor.setNome((String) rawObject); break; case EMAIL: actor.setEmail((String) rawObject); break; default: } } return actor; }
@Override public Object transformTuple(Object[] objects, String[] strings) { if (objects == null || objects.length == 0) { return null; } Actor actor = new Actor(); for (int i = 0; i < strings.length; i += 1) { Object rawObject = objects[i]; switch (strings[i]) { case COD: actor.setCod(castToInteger(rawObject)); break; case COD_USUARIO: actor.setCodUsuario(String.valueOf(rawObject)); break; case NOME: actor.setNome((String) rawObject); break; case EMAIL: actor.setEmail((String) rawObject); break; default: } } return actor; }