利用Hibernate读取oracle的sequence

Question

好像DAO跟读sequence没多少关系吧。
关于sequence主要是在.hbm.xml中配置。示例：
<id name="levelId" column="LEVEL_ID" type="long">
      <generator class="sequence">
         <param name="sequence">leve_id_seq</param>
      </generator>
</id>

Answer 1

Connection connection = session.connection ();
                PreparedStatement preparedStatement = null;
                ResultSet resultSet = null;
                try {
                    preparedStatement = connection.prepareStatement ("select platform_sequence.nextval from dual");
                    resultSet = preparedStatement.executeQuery ();
                    BigDecimal value = null;
                    while (resultSet.next ()) {
                        value = resultSet.getBigDecimal (1);
                    }
                    return value.longValueExact ();
                }
                finally {
                    if (preparedStatement != null) {
                        preparedStatement.close ();
                    }
                    if (resultSet != null) {
                        resultSet.close ();
                    }
                }