java如何实现hibernate二级缓存上的查询与连接？

Question

我试图在登录用户时实现二级缓存

我的设想是：- 无论何时验证用户，都需要从其他表中获取更多详细信息。就像在本例中一样，我使用内部联接从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>