test


<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLInnoDBDialect
</prop>
<prop key="hibernate.show_sql">
true
</prop>
<prop key="hibernate.generate_statistics">
true
</prop>
<prop key="hibernate.cache.use_second_level_cache">
true
</prop>
<prop key="hibernate.cache.use_query_cache">
true
</prop>
<prop key="hibernate.cache.provider_class">
org.hibernate.cache.EhCacheProvider
</prop>

</props>
</property>


public String matchCondition(Map map){
StringBuffer hql = new StringBuffer("");
if(map!=null){
if(map.get("cities.id")!=null){
if((Long)map.get("cities.id")!=1L&&"1".equals(map.get("status"))){
hql.append(" and (p.cities.id =" + map.get("cities.id")+" or p.cities.id=1)");
}else{
hql.append(" and p.cities.id =" + map.get("cities.id"));
}
}
if(map.get("site.id")!=null){
hql.append(" and p.site.id=" + map.get("site.id"));
}
if(map.get("catalog.id")!=null){
hql.append(" and p.catalog.id=" + map.get("catalog.id"));
}
if(map.get("needLogistics")!=null){
hql.append(" and p.needLogistics ='"+ map.get("needLogistics")+"'");
}
if(map.get("status")!=null){
hql.append(" and p.status = '"+ map.get("status")+"'");
}
if(map.get("saleStatus")!=null){
hql.append(" and p.saleStatus ='"+ map.get("saleStatus")+"'");
}
if(map.get("beginTime")!=null){
hql.append(" and date_format(p.beginTime,'%Y-%m-%d') = '"+ map.get("beginTime")+"'");
}
if(map.get("endTime")!=null){
hql.append(" and date_format(p.endTime,'%Y-%m-%d') = '"+ map.get("endTime")+"'");
}
if(map.get("createTime")!=null){
hql.append(" and date_format(p.createTime,'%Y-%m-%d')='"+ map.get("createTime")+"'");
}
if(map.get("title")!=null){
hql.append(" and p.name like '%"+ map.get("title")+"%'");
}
}
return hql.toString();
}
  • 0
    点赞
  • 0
    评论
  • 0
    收藏
  • 一键三连
    一键三连
  • 扫一扫,分享海报

©️2021 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值