public List<ProductAccessoryEntity> searchAccessoryList(ProductAccessoryEntity bean,
Page<ProductAccessoryEntity> pageItems) {
/*String sql = "select * from plug_product_Accessory pa join plug_product_model pm on pm.id = pa.model_id where pa.Accessory like ?";
Query query = em.createNativeQuery(sql,ProductAccessoryEntity.class);
query.setParameter(1, "%"+bean.getAccessory()+"%");
List<ProductAccessoryEntity> accessoryList = query.getResultList();
for (ProductAccessoryEntity accessory : accessoryList) {
}
return accessoryList;*/
String jpql = "SELECT pa FROM ProductAccessoryEntity pa join pa.modelEntity pm where pa.accessory like ? ";
Query query = em.createQuery(jpql);
query.setParameter(1, "%"+bean.getAccessory()+"%");
return query.getResultList();
}
JPA模糊查询的方法
最新推荐文章于 2023-08-31 10:01:49 发布