Hibernate框架中，使用JDBC语法

来源：互联网发布：苏州二手房成交数据编辑：程序博客网时间：2024/06/05 08:23

/** * 调用存储过程 *  * @param PRONAME * @return */public CallableStatement citePro(final String PRONAME){Session session = getCurrentSession();CallableStatement pro = session.doReturningWork(new ReturningWork<CallableStatement>() {@Overridepublic CallableStatement execute(Connection connection)throws SQLException {CallableStatement resultSet = connection.prepareCall(PRONAME);return resultSet;}});return pro;}

或者

/** * 使用JDBC执行sql语句 *  * @return */public void xx() throws SQLException {Session session = getCurrentSession();ResultSet resultSet=session.doReturningWork(new ReturningWork<ResultSet>() {@Overridepublic ResultSet execute(Connection connection) throws SQLException {String sql="select * from tableName";PreparedStatement preparedStatement=connection.prepareStatement(sql);ResultSet resultSet=preparedStatement.executeQuery();return resultSet;}});while (resultSet.next()){System.out.println("rs:"+resultSet.getString("authid"));}}

就是这个doReturnWork方法，里面通过内部类，把resultset对象一层一层返回给这个doReturnWork，这样就可以像用jdbc一样使用hibernate了。

0 0