001/* 002 * (C) Copyright 2006-2012 Nuxeo SA (http://nuxeo.com/) and others. 003 * 004 * Licensed under the Apache License, Version 2.0 (the "License"); 005 * you may not use this file except in compliance with the License. 006 * You may obtain a copy of the License at 007 * 008 * http://www.apache.org/licenses/LICENSE-2.0 009 * 010 * Unless required by applicable law or agreed to in writing, software 011 * distributed under the License is distributed on an "AS IS" BASIS, 012 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 013 * See the License for the specific language governing permissions and 014 * limitations under the License. 015 * 016 * Contributors: 017 * Arnaud Kervern <akervern@nuxeo.com> 018 */ 019 020package org.nuxeo.ecm.directory.sql.filter; 021 022import org.nuxeo.ecm.core.storage.sql.jdbc.db.Column; 023import org.nuxeo.ecm.directory.DirectoryException; 024 025import java.sql.PreparedStatement; 026import java.sql.SQLException; 027import java.util.Calendar; 028 029/** 030 * Make a BETWEEN SQL predicate 031 * 032 * @since 5.7 033 */ 034public class SQLBetweenFilter extends SQLComplexFilter { 035 036 private Calendar from; 037 038 private Calendar to; 039 040 public SQLBetweenFilter(Calendar from, Calendar to) { 041 super("BETWEEN"); 042 this.from = from; 043 this.to = to; 044 } 045 046 @Override 047 public int doSetFieldValue(PreparedStatement ps, int index, Column column) throws SQLException { 048 column.setToPreparedStatement(ps, index, from); 049 column.setToPreparedStatement(ps, index + 1, to); 050 return index + 2; 051 } 052 053 @Override 054 public String getRightSide() { 055 return "? AND ?"; 056 } 057}