hibernate+spring中怎么得到connection

[hwt_211]

整合hibernate 和 spring的一个项目，其中怎么得到一个connection对象，我想使用connection对象操作存储过程

发现session.connection() 这个方法已经过时了。

怎么才能得到connection对象？

[dqsweet]

public class HibernateSessionFactory {

 

    /**

     * Location of hibernate.cfg.xml file.

     * Location should be on the classpath as Hibernate uses 

     * #resourceAsStream style lookup for its configuration file.

     * The default classpath location of the hibernate config file is

     * in the default package. Use #setConfigFile() to update

     * the location of the configuration file for the current session.  

      */

     private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";

       private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();

    private  static Configuration configuration = new Configuration();

    private static org.hibernate.SessionFactory sessionFactory;

    private static String configFile = CONFIG_FILE_LOCATION;

 

       static {

           try {

                     configuration.configure(configFile);

                     sessionFactory = configuration.buildSessionFactory();

              } catch (Exception e) {

                     System.err

                                   .println("%%%% Error Creating SessionFactory %%%%");

                     e.printStackTrace();

              }

    }

    private HibernateSessionFactory() {

    } 

[hwt_211]

1，只要先得到sessionFactory对象
2，然后通过sessionFactory的子类SessionFactoryImplementor 的 getConnectionProvider() 来 得到ConnectionProvider
3，connectionProvider。getConnection();

ConnectionProvider cp = ((SessionFactoryImplementor)factory).getConnectionProvider();
Connection connection = cp.getConnection();
得到了connection对象，下面就是jdbc代码了
记得关闭资源

[new_bird_0001]

如果spring中配置有datasource，可直接获取spring中的datasource来获得connection，不一定通过hibernate来获取。

[MR_ZHOUXING]

关键是怎么操作啊，求指导，非常感谢啊