public List<Record> queryList(String sql, Map<String, Object> params) { return createQuery(sql, params).list(); }
@Override public List<AuthzSSOLogin> loadLoginsInSession(AuthzSSOSession session) { List<AuthzSSOLoginEntity> entities = null; if(null != loadLoginsInSessionCommand) { entities = dao.createQuery(AuthzSSOLoginEntity.class, loadLoginsInSessionCommand).list(); }else{ entities = dao.createCriteriaQuery(AuthzSSOLoginEntity.class).where("session_id = ?", session.getId()).list(); } List<AuthzSSOLogin> logins = new ArrayList<>(); for(AuthzSSOLoginEntity entity : entities) { logins.add(createLoginFromEntity(entity)); } return logins; }
@Override public List<AuthzSSOLogin> loadLoginsInSession(AuthzSSOSession session) { List<AuthzSSOLoginEntity> entities = null; if(null != loadLoginsInSessionCommand) { entities = dao.createQuery(AuthzSSOLoginEntity.class, loadLoginsInSessionCommand).list(); }else{ entities = dao.createCriteriaQuery(AuthzSSOLoginEntity.class).where("session_id = ?", session.getId()).list(); } List<AuthzSSOLogin> logins = new ArrayList<>(); for(AuthzSSOLoginEntity entity : entities) { logins.add(createLoginFromEntity(entity)); } return logins; }
@Override public Object apply(ActionParams params) { Map<String,Object> map = params.toMap(); Object result; if(command.getMetadata().isSelect()) { //todo: page query, total count Query query = dao.createQuery(command).params(map); if(null != returnType) { if(returnType.isSimpleType()) { result = Converts.convert(query.scalarValueOrNull(), returnType.asSimpleType().getJavaType()); }else if(returnType.isCollectionType() && returnType.asCollectionType().getElementType().isSimpleType()) { result = query.scalars().list(returnType.asCollectionType().getElementType().asSimpleType().getJavaType()); }else { result = query.list(); } }else { result = query.list(); } }else{ //todo: the return type must be simple type result = dao.executeUpdate(command, map); if(null != returnType) { result = Converts.convert(result, returnType.asSimpleType().getJavaType()); } } return ApiResponse.of(result); }