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:haul@apache.org">Christian Haul</a>
26: * @author <a href="mailto:tcurdt@apache.org">Torsten Curdt</a>
27: * @version CVS $Id: PostgresEsqlQuery.java 433543 2006-08-22 06:22:54Z crossley $
28: */
29: final public class PostgresEsqlQuery extends AbstractEsqlQuery {
30:
31: public PostgresEsqlQuery(Connection connection, String query) {
32: super (connection, query);
33: }
34:
35: /**
36: * Only newInstance may use this contructor
37: * @param resultSet
38: */
39: private PostgresEsqlQuery(ResultSet resultSet) {
40: super (resultSet);
41: }
42:
43: /**
44: * Create a EsqlQuery of the same type
45: * @param resultSet
46: */
47: public AbstractEsqlQuery newInstance(final ResultSet resultSet) {
48: return (new PostgresEsqlQuery(resultSet));
49: }
50:
51: public String getQueryString() throws SQLException {
52: StringBuffer sb = new StringBuffer(super .getQueryString());
53: if (getMaxRows() > -1)
54: sb.append(" LIMIT ").append(getMaxRows() + 1);
55: if (getSkipRows() > 0)
56: sb.append(" OFFSET ").append(getSkipRows());
57: return (sb.toString());
58: }
59:
60: public void getResultRows() throws SQLException {
61: setPosition(getSkipRows());
62: }
63: }
|