- hibernate、jpa返回指定数据类型、返回指定实体、返回某列、返回指定列
- hibernate中只选取某些列的写法
- hibernate如何返回一个Map对象 以及List<Map<String, Object>>
- jpa返回指定数据类型的自定义结果
- SpringBoot 使用JPA返回自定义类
或者参考我的这篇文章:https://blog.csdn.net/weixin_44480167/article/details/132256053
转自 https://lingkang.top/archives/jpa-fan-hui-zhi-ding-shu-ju-lei-xing
@Autowired
private EntityManager entityManager;
@GetMapping("/t")
@ResponseBody
public Object t() {
Session session = entityManager.unwrap(Session.class);
List<OrderEntity> result = session.createQuery(
"select v.id,v.type,price from OrderEntity v where v.id=:id",
Tuple.class
).setTupleTransformer((tuple, aliases) -> {
OrderEntity order = new OrderEntity();
order.setId((String) tuple[0]);
order.setType((String) tuple[1]);
order.setPrice((BigDecimal) tuple[2]);
return order;
}).
setParameter("id", "1690614502150PnG").list();
OrderEntity jpaTuple = result.get(0);
return jpaTuple;
}
结果
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-ZPDOMNw7-1690626526118)(/upload/2023/07/image-1690626306118.png)]