oracle sql查询记录,从SQL查询Oracle中检索一系列记录

我有这个用于JSF分页的Java代码：

public List list(int firstRow, int rowCount, String sortField, boolean sortAscending) throws Exception {

String SQL_LIST_BY_ORDER_AND_LIMIT = "SELECT * FROM ACTIVESESSIONSLOG ORDER BY ? ? LIMIT ?, ?";

if (ds == null) {

throw new SQLException();

}

String sortDirection = sortAscending ? "ASC" : "DESC";

String sql = String.format(SQL_LIST_BY_ORDER_AND_LIMIT, sortField, sortDirection);

Connection conn = ds.getConnection();

PreparedStatement preparedStatement = null;

ResultSet resultSet = null;

List dataList = new ArrayList();

try {

conn.setAutoCommit(false);

boolean committed = false;

preparedStatement = conn.prepareStatement(sql);

preparedStatement.setString(1, sortField);

preparedStatement.setString(2, sortDirection);

preparedStatement.setInt(3, firstRow);

preparedStatement.setInt(4, rowCount);

resultSet = preparedStatement.executeQuery();

/* take the result from the SQL query and insert it into Array List collection */

dataList = ActiveSessionsArrayList(resultSet);

} catch (SQLException e) {

throw new Exception(e);

} finally {

conn.close();

}

return dataList;

}我使用这个SQL语句来生成ArrayList：

SELECT * FROM ACTIVESESSIONSLOG ORDER BY ? ? LIMIT ?, ?这个SQL查询可以用于Oracle吗？或者这是MySQL的具体？

最好的祝愿