01: /*
02: * Licensed to the Apache Software Foundation (ASF) under one or more
03: * contributor license agreements. See the NOTICE file distributed with
04: * this work for additional information regarding copyright ownership.
05: * The ASF licenses this file to You under the Apache License, Version 2.0
06: * (the "License"); you may not use this file except in compliance with
07: * the License. You may obtain a copy of the License at
08: *
09: * http://www.apache.org/licenses/LICENSE-2.0
10: *
11: * Unless required by applicable law or agreed to in writing, software
12: * distributed under the License is distributed on an "AS IS" BASIS,
13: * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14: * See the License for the specific language governing permissions and
15: * limitations under the License.
16: */
17:
18: package org.apache.cocoon.components.language.markup.xsp;
19:
20: import java.sql.ResultSet;
21: import java.sql.SQLException;
22: import java.sql.Connection;
23:
24: /**
25: * @author <a href="mailto:tcurdt@apache.org">Torsten Curdt</a>
26: * @version CVS $Id: OracleEsqlQuery.java 433543 2006-08-22 06:22:54Z crossley $
27: */
28: final public class OracleEsqlQuery extends AbstractEsqlQuery {
29:
30: public OracleEsqlQuery(Connection connection, String query) {
31: super (connection, query);
32: }
33:
34: /**
35: * Only newInstance may use this contructor
36: * @param resultSet
37: */
38: private OracleEsqlQuery(ResultSet resultSet) {
39: super (resultSet);
40: }
41:
42: /**
43: * Create a EsqlQuery of the same type
44: * @param resultSet
45: */
46: public AbstractEsqlQuery newInstance(final ResultSet resultSet) {
47: return (new OracleEsqlQuery(resultSet));
48: }
49:
50: public String getQueryString() throws SQLException {
51: if (getSkipRows() > 0) {
52: if (getMaxRows() > -1) {
53: return (new StringBuffer(
54: "select * from (select a.*, rownum rnum from (")
55: .append(super .getQueryString()).append(
56: ") a where rownum <= ").append(
57: getSkipRows() + getMaxRows() + 1)
58: .append(") where rnum > ")
59: .append(getSkipRows()).toString());
60: } else {
61: return (new StringBuffer(
62: "select * from (select a.*, rownum rnum from (")
63: .append(super .getQueryString()).append(") a ")
64: .append(") where rnum > ")
65: .append(getSkipRows()).toString());
66: }
67: } else {
68: if (getMaxRows() > -1) {
69: return (new StringBuffer(
70: "select * from (select a.*, rownum from (")
71: .append(super .getQueryString()).append(
72: ") a where rownum <= ").append(
73: getMaxRows() + 1).append(")")
74: .toString());
75: } else {
76: return (super .getQueryString());
77: }
78: }
79: }
80:
81: public void getResultRows() throws SQLException {
82: setPosition(getSkipRows());
83: }
84:
85: }
|