Hibernate4使用Session获取Connection返回ResultSet

Hibernate4不能直接通过session获取到connection，须用如下方式实现：

 

@Test
    public void tests() throws SQLException {
        Session session=HibernateSessionFactory.getSession();
        ResultSet resultSet=session.doReturningWork(
                new ReturningWork<ResultSet>() {
                    @Override
                    public ResultSet execute(Connection connection) throws SQLException {
                        String sql="select * from t_auth";
                        PreparedStatement preparedStatement=connection.prepareStatement(sql);
                        ResultSet resultSet=preparedStatement.executeQuery();
                        return resultSet;
                    }
                }
        );
        while (resultSet.next()){
            System.out.println("rs:"+resultSet.getString("authid"));
        }
    }