1 jpa specification 复杂查询，拼接group by 时，分页会触发select count (*),导致指定select * from table group by 字段，造成语法错误；
2 对于oracle number 类型，虽然JavaBean中定义啦 intege，但是单独查会造成无法转型bigdecimal错误
1 用hibernate的entityManager 构建
private EntityManager entityManager
public List<ViewEmployeeBase> getCheckboxInfo(String evaluateYear) {
// criteriaBuilder用于构建CriteriaQuery的构建器对象
CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
// criteriaQuery包含查询语句的各个部分，如where、max、sum、groupBy、orderBy等
CriteriaQuery<ViewEmployeeBase> criteriaQuery = criteriaBuilder.createQuery(ViewEmployeeBase.class);
// 获取查询实例的属性，select * from books
Root<ViewEmployeeBase> root = criteriaQuery.from(ViewEmployeeBase.class);
// 相当于select type,max(price) maxPrice,sum(price) sumPrice from books中select 与
// from之间的部分
criteriaQuery.multiselect(root.get("position").as(String.class));
// where type = 1
criteriaQuery.where(criteriaBuilder.equal(root.get("id").get("evaluateYear"), evaluateYear));
// group by type
criteriaQuery.groupBy(root.get("position"));
// criteriaQuery拼成的sql是select type,max(price) maxPrice,sum(price) sumPrice from
// books group by type；查询出的列与对象BookInfo的属性对应
// 记录当前sql查询结果总条数
// List<ViewEmployeeBase> counts = entityManager.createQuery(criteriaQuery).getResultList();
// sql查询对象
TypedQuery<ViewEmployeeBase> createQuery = entityManager.createQuery(criteriaQuery);
return createQuery.getResultList();
// 设置分页参数
}
excel导出图片指定的单元格 java java导出带图片的excel
Java Excel导出(包含图片) —— EasypoiEasypoi官网文档：http://doc.wupaas.com/docs/easypoi/easypoi-1c0u6ksp2r091一、添加 依赖<dependency>
<groupId>cn.afterturn</groupId>
<artif
