Hibernate框架中，使用JDBC语法

/**
	 * 调用存储过程
	 * 
	 * @param PRONAME
	 * @return
	 */
	public CallableStatement citePro(final String PRONAME){
		Session session = getCurrentSession();
		CallableStatement pro = session.doReturningWork(new ReturningWork<CallableStatement>() {

			@Override
			public 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>() {
				@Override
				public 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"));
	}
}

Hibernate框架中，使用JDBC语法

原文：http://blog.csdn.net/u013474104/article/details/44513243