jdbc获取单个或几个返回值时使用

jdbc获取单个或几个返回值时使用

Query query = getEntityManager().createNativeQuery(sumSql);

		query.unwrap(SQLQuery.class).setResultTransformer(
				Transformers.ALIAS_TO_ENTITY_MAP);
		Map<String, Object> result = (Map<String, Object>)query.getSingleResult();
		if (result != null ) {
			countTotal= result.get("countTotal").toString();
			costAmount = result.get("costAmount").toString();
		}

Query query = getEntityManager().createQuery(queryString);
			
			result = query.getSingleResult();
			if( Integer.valueOf(String.valueOf(result).toString()) == 1 ){
				flag = true;
			}