java如何实现hibernate二级缓存上的查询与连接?
我试图在登录用户时实现二级缓存
我的设想是:- 无论何时验证用户,都需要从其他表中获取更多详细信息。就像在本例中一样,我使用内部联接从userdetails表中提取数据
每次验证用户时,它都会提取相同的数据。所以我不想每次用户尝试登录时都执行查询。在这种情况下,也许我可以使用二级缓存
不幸的是,我无法在这里实现hibernate的二级缓存
UserController
@Controller
public class UserController {
@Autowired
private UserDao userDao;
@RequestMapping("/getUserDetails")
public @ResponseBody List<UserDetailsMapping> userDetailsMappings(){
return userDao.getUserDetails();
}
}
UserDao
@Repository
public class UserDao {
@Autowired
private SessionFactory sessionFactory;
public List<UserDetailsMapping> getUserDetails(){
Session session = sessionFactory.openSession();
String sql ="select u.username,ud.address,ud.height,ud.weight from
User u inner join UserDetails ud \n" +
"on u.username=ud.username where u.username='sagar' and
u.password='sagar';";
Query query = session.createNativeQuery(sql,"userMapping")
.setCacheable(true);
List<UserDetailsMapping> list = query.getResultList();
return list;
}
}
用户。班级
@Entity
@Cacheable
@Cache(usage = CacheConcurrencyStrategy.READ_ONLY)
public class User {
@Id
private String username;
private String password;
**************constructors and getter setters**********
}
用户详细信息。班级
@Entity
@Cacheable
@Cache(usage = CacheConcurrencyStrategy.READ_ONLY)
@SqlResultSetMapping(name = "userMapping",
classes = {@ConstructorResult(targetClass = UserDetailsMapping.class,
columns = {
@ColumnResult(name = "username",type = String.class),
@ColumnResult(name = "address",type = String.class),
@ColumnResult(name = "height",type = Integer.class),
@ColumnResult(name = "weight",type = Integer.class)
})
})
public class UserDetails {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int id;
private String username;
private String address;
private String gender;
private int height;
private int weight;
**************constructors and getter setters**********
}
应用程序上下文配置
<bean id="sessionFactory" class="org.springframework.orm.
hibernate5.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.cache.use_second_level_cache">true</prop>
<prop key="hibernate.cache.region.factory_class">
org.hibernate.cache.ehcache.EhCacheRegionFactory</prop>
</props>
</property>
<property name="packagesToScan">
<list>
<value>com.test</value>
</list>
</property>
</bean>
共 (0) 个答案