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.SQLException;
21: import java.sql.ResultSet;
22: import java.sql.Connection;
23:
24: /**
25: * @author <a href="mailto:tcurdt@apache.org">Torsten Curdt</a>
26: * @version CVS $Id: PostgresOldEsqlQuery.java 433543 2006-08-22 06:22:54Z crossley $
27: */
28: final public class PostgresOldEsqlQuery extends AbstractEsqlQuery {
29:
30: public PostgresOldEsqlQuery(Connection connection, String query) {
31: super (connection, query);
32: }
33:
34: /**
35: * Only newInstance may use this contructor
36: * @param resultSet
37: */
38: private PostgresOldEsqlQuery(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 PostgresOldEsqlQuery(resultSet));
48: }
49:
50: public String getQueryString() throws SQLException {
51: if (getSkipRows() > 0) {
52: if (getMaxRows() > -1) {
53: return (new StringBuffer(super .getQueryString())
54: .append(" LIMIT ").append(getMaxRows() + 1)
55: .append(",").append(getSkipRows()).toString());
56: } else {
57: return (new StringBuffer(super .getQueryString())
58: .append(" OFFSET ").append(getSkipRows())
59: .toString());
60: }
61: } else {
62: if (getMaxRows() > -1) {
63: return (new StringBuffer(super .getQueryString())
64: .append(" LIMIT ").append(getMaxRows() + 1)
65: .toString());
66: } else {
67: return (super .getQueryString());
68: }
69: }
70: }
71:
72: public void getResultRows() throws SQLException {
73: setPosition(getSkipRows());
74: }
75: }
|