Hibernate里使用Spring JdbcTemplate的代码。来自appfuse的UserDaoHibernate。

UserDaoHibernate.java

public String getUserPassword(Long userId) {
    JdbcTemplate jdbcTemplate =
            new JdbcTemplate(SessionFactoryUtils.getDataSource(getSessionFactory()));
    Table table = AnnotationUtils.findAnnotation(User.class, Table.class);
    return jdbcTemplate.queryForObject(
            "select password from " + table.name() + " where id=?", String.class, userId);
}