使用spring-data-jpa需要特别弥补的地方,这点mapper处理比较好
//弥补jpa单实体的不足用不同的工厂类操作复杂sql,mapper这点比较好在处理了单实体查询直接不用daoimpl下,即使用
xml进行复杂查询也不需要daoimpl
jpa 复杂操作弥补:
public class TbPowerGroupBeanDaoImpl implements ITbPowerGroupBeanDao {
@Autowired
public ESteelSqlSessionTemplate sqlSessionTemplate;
@Override
public List<Map<String,Object>> getBigPowerMenu(Map<String, Object> param) {
// TODO Auto-generated method stub
return sqlSessionTemplate.selectList("account.getBigPowerMenu", param);
}
}
public class UserBListDaoImpl implements UserBListDaoHelper{
@PersistenceContext
private EntityManager em;
@Override
public List<CusFirmBean> findCustomerExceptOne(Map<String, Object> paraMap) {
StringBuffer sb = new StringBuffer();
sb.append(" select distinct t.CUSTOMER_ID,t.CUSTOMER_KEY,t.CUSTOMER_NAME ");
sb.append(" from tb_user_blist t1 left join tb_cus_firm t on(t1.blist_customer_key=t.customer_key) ");
sb.append(" left join TB_USER_BLIST_LABEL t2 on(t1.blist_id=t2.blist_id) left join TB_USER_LABEL t3 on(t2.label_id=t3.label_id) ");
sb.append(" where t1.CUSTOMER_KEY=:CUSTOMER_KEY ");
if (!StringUtils.isNullObj(paraMap.get("CUSTOMER_NAME"))) {
sb.append(" and t.CUSTOMER_NAME like '%'||:CUSTOMER_NAME||'%'");
}
if (!StringUtils.isNullObj(paraMap.get("CUSTOMER_SEARCHKEY"))) {
sb.append(" and t.CUSTOMER_ID = :CUSTOMER_SEARCHKEY ");
}
if (!StringUtils.isNullObj(paraMap.get("label_name"))) {
sb.append(" and t3.label_name =:LABEL_NAME ");
}
if (!StringUtils.isNullObj(paraMap.get("selectedCustomerKey"))
&¶Map.get("selectedCustomerKey").toString()!="[]") {
sb.append(" and t.CUSTOMER_KEY not in (:selectedCustomerKey)");
}
sb.append(" and t.CUS_TRADE_KIND = 'A'");
Query query = em.createNativeQuery(sb.toString());
query.setParameter("CUSTOMER_KEY", paraMap.get("CUSTOMER_KEY"));
if (!StringUtils.isNullObj(paraMap.get("CUSTOMER_NAME"))) {
query.setParameter("CUSTOMER_NAME", paraMap.get("CUSTOMER_NAME"));
}
if (!StringUtils.isNullObj(paraMap.get("CUSTOMER_SEARCHKEY"))) {
query.setParameter("CUSTOMER_SEARCHKEY", ((String) paraMap.get("CUSTOMER_SEARCHKEY")).toUpperCase());
}
if (!StringUtils.isNullObj(paraMap.get("label_name"))) {
query.setParameter("LABEL_NAME", paraMap.get("label_name"));
}
if (!StringUtils.isNullObj(paraMap.get("selectedCustomerKey"))
&¶Map.get("selectedCustomerKey").toString()!="[]") {
query.setParameter("selectedCustomerKey", paraMap.get("selectedCustomerKey"));
}
List<Object[]> list = query.getResultList();
List<CusFirmBean> rstList = new ArrayList<CusFirmBean> ();
if(list!=null && list.size()>0) {
for(Object[] obj : list) {
CusFirmBean cus = new CusFirmBean ();
cus.setCustomerId(obj[0]!=null?obj[0].toString():"");
cus.setCustomerKey(NumberUtils.toLong(obj[1].toString()));
cus.setCustomerName(obj[2].toString());
rstList.add(cus);
}
}
return rstList;
}
}
jpa dao层直接操作(只限于单实体):
@Component("basLkpService")
public class BasLkpServiceImpl implements BasLkpService {
@Autowired
public BasAreaDao basAreaDao;
@Autowired
public BasLkpDao basLkpDao;
@Override
public List<BasAreaBean> getAllProvince() {
return basAreaDao.findByAreaLevel("1");
}
@Override
public BasLkpBean getTbBasLkpByBusinessTypeLookupType(String businessType, String priceType) {
BasLkpBeanPK pk=new BasLkpBeanPK();
pk.setBusinessType(businessType);
pk.setLookupType(priceType);
return basLkpDao.findOne(pk);
}
}
相关推荐
赠送jar包:spring-data-jpa-2.0.9.RELEASE.jar; 赠送原API文档:spring-data-jpa-2.0.9.RELEASE-javadoc.jar; 赠送源代码:spring-data-jpa-2.0.9.RELEASE-sources.jar; 赠送Maven依赖信息文件:spring-data-jpa...
spring-data-commons-1.7.2.RELEASEspring-data-jpa-1.5.2.RELEASE-java datajpa
赠送jar包:spring-data-jpa-2.0.9.RELEASE.jar; 赠送原API文档:spring-data-jpa-2.0.9.RELEASE-javadoc.jar; 赠送源代码:spring-data-jpa-2.0.9.RELEASE-sources.jar; 赠送Maven依赖信息文件:spring-data-jpa...
spring-data-jpa spring data jap
java运行依赖jar包
spring-data-jpa
在使用Spring-data-jpa进行分页查询时,需要遵循以下步骤: 引入依赖 在pom.xml文件中加入spring-boot-starter-data-jpa依赖,使得项目可以使用Spring-data-jpa框架对数据库进行操作。 手动创建实体类 手动创建一...
spring data jpa最新版本1.8.0,包含了spring-data-jpa-1.8.0.RELEASE.jar,spring-data-jpa-1.8.0.RELEASE-javadoc.jar以及 spring-data-jpa-1.8.0.RELEASE-sources.jar文档和源代码
java运行依赖jar包
实现spring-data-jpa的增删改查方法,该项目是maven项目,需要maven支持
java运行依赖jar包
java运行依赖jar包
spring-data-jpa-1.5.2
springboot-spring-data-jpa项目练习,整合了增删改查springboot-spring-data-jpa项目练习,整合了增删改查
NULL 博文链接:https://mybar.iteye.com/blog/1863390
使用SpringBoot 集成Spring-data-jpa,Druid连接池,thymeleaf模板实现的一个简单网上商城项目
spring-data-jpa知识。
spring-data-jpa-reference1.3.pdf
Spring Boot使用spring-data-jpa配置Mysql多数据源,可用版本
spring-data-jpa-1.4.2.RELEASE.jar