如何为sessionFactory.getCurrentSession（）启用休眠过滤器？
|
假设有一个结构如下的User表：
用户
项目清单
userId（PK）
公司（PK）
用户名
地址...等
我只想检索当前公司的用户（用户可以通过UI更改公司，因此公司是运行时参数）
类似地，还有许多其他表具有与公用列（公司）相似的结构，并且我想将数据限制为仅当前公司，因此我正在使用休眠过滤器来过滤数据。
休眠注释：
<bean id=\"sessionFactory\"
class=\"org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean\">
<property name=\"dataSource\">
<ref bean=\"dataSource\" />
</property>
<property name=\"hibernateProperties\">
<props>
<prop key=\"hibernate.dialect\">Dialect....</prop>
<prop key=\"hibernate.show_sql\">true</prop>
<prop key=\"hibernate.generate_statistics\">true</prop>
<prop key=\"hibernate.connection.release_mode\">after_transaction</prop>
<prop key=\"hibernate.cache.use_second_level_cache\">false</prop>
</props>
</property>
<property name=\"annotatedClasses\">
<list>
<value>User</value>
.....
</list>
</property>
</bean>
private Session getSession(){
Session session = sessionFactory.getCurrentSession();
Filter filter = session.enableFilter(\"restrictToCurrentCompany\");
filter.setParameter(\"currentCompanyNumber\", UserUtils.getCurrentCompany());
return sessionFactory.getCurrentSession();
}
没有找到相关结果
已邀请:
2 个回复
犀耽澄协吻
public class BaseDAO { // ... possibly some other methods and variables @Autowired(required = true) private SessionFactory sessionFactory; protected Session getSession() { //Your session filter logic above } }<?xml version=\"1.0\" encoding=\"UTF-8\"?> <beans ... xmlns:aop=\"http://www.springframework.org/schema/aop\" xsi:schemaLocation=\" ... http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd\"> ... <aop:config> <aop:aspect id=\"forceFilter\" ref=\"sessionFilterAdvice\"> <aop:pointcut id=\"hibernateSessionFactoryGetSession\" expression=\"execution(* org.hibernate.SessionFactory.openSession(..))\" /> <aop:after-returning method=\"setupFilter\" pointcut-ref=\"hibernateSessionFactoryGetSession\" returning=\"session\" /> </aop:aspect> </aop:config> ... </beans>package net.grogscave.example; import org.hibernate.Filter; import org.hibernate.Session; import org.springframework.stereotype.Service; @Service public class SessionFilterAdvice { public void setupFilter(Session session) { Session session = sessionFactory.getCurrentSession(); Filter filter = session.enableFilter(\"restrictToCurrentCompany\"); filter.setParameter(\"currentCompanyNumber\", UserUtils.getCurrentCompany()); } }吠强祷豪硅
<hibernate-mapping package=\"com.ABC.dvo\"> <class name=\"ItemMasterDVO\" table=\"Item_Master\"> .... <set name=\"inventoryTaxesSet\" inverse=\"true\" cascade=\"all\"> <key column=\"item_ID\" /> <one-to-many class=\"InventoryTaxesDVO\" /> <filter name=\"filterByFacilityIDs\" condition=\"Facility_ID in(:facilityIDsParam)\"/> </set> </class> <filter-def name=\"filterByFacilityIDs\"> <filter-param name=\"facilityIDsParam\" type=\"string\"/> </filter-def> </hibernate-mapping>public List<ItemMasterDVO> getItemMaster(String[] itemIDs, String[] facilityIDs){ Session session = getSessionFactory().getCurrentSession(); Criteria criteria = session.createCriteria(ItemMasterDVO.class) .add(Restrictions.in(\"itemNumber\", itemIDs)) .setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY); if(facilityIDs!=null && facilityIDs.length>0){ org.hibernate.Filter filter = session.enableFilter(\"filterByFacilityIDs\"); filter.setParameterList(\"facilityIDsParam\", facilityIDs); } criteria.addOrder(Order.asc(\"itemNumber\")); List<ItemMasterDVO> result = criteria.list(); return result; }