test

最新推荐文章于 2023-08-15 10:54:36 发布

xmayxmei

最新推荐文章于 2023-08-15 10:54:36 发布

阅读量85

点赞数

文章标签： Hibernate Cache XML

本文链接：https://blog.csdn.net/xmayxmei/article/details/83665759

版权


<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();
	}