pairrange.java

数据库的加密以及密态查询

import java.sql.*;
import java.math.BigDecimal;

public class PairRange {
        private Pair lowBound;
        private Pair upBound;

        public PairRange(Pair p1, Pair p2) {
                lowBound = p1;
                upBound = p2;
        }

        public boolean contains(int no, Date ob) {
                if (lowBound.compareTo(ob) <= 0 && upBound.compareTo(ob) > 0)
                        return true;
                else if (upBound.compareTo(ob) == 0 && upBound.rownum > no)
                        return true;
                else
                        return false;
        }

        public boolean contains(int no, BigDecimal ob) {
                if (lowBound.compareTo(ob) <= 0 && upBound.compareTo(ob) > 0)
                        return true;
                else if (upBound.compareTo(ob) == 0 && upBound.rownum > no)
                        return true;
                else
                        return false;
        }

        public boolean contains(int no, int value) {
                if (lowBound.compareTo(value) <= 0 && upBound.compareTo(value) > 0)
                        return true;
                else if (upBound.compareTo(value) == 0 && upBound.rownum > no)
                        return true;
                else
                        return false;
        }

        public boolean contains(Date date) {
                if (lowBound.compareTo(date) <= 0 && upBound.compareTo(date) > 0)
                        return true;
                else
                        return false;
        }

        public boolean contains(BigDecimal bg) {
                if (lowBound.compareTo(bg) <= 0 && upBound.compareTo(bg) > 0)
                        return true;
                else
                        return false;
        }

        public boolean contains(Integer xx) {
                if (lowBound.compareTo(xx) <= 0 && upBound.compareTo(xx) > 0)
                        return true;
                else
                        return false;
        }

        public void print() {
                System.out.println(lowBound.toString());
                System.out.println(upBound.toString());
        }

        /*public boolean contains(Range range) {
        	if (lowBound <= range.lowBound && upBound >= range.upBound)
        		return true;
        	return false;
        }

        public boolean lower(Date date) {
        	return date < lowBound;
        }

        public boolean lower(Range range) {
        }

        public boolean greater(Date date) {
        	return date >= upBound;
        }*/
}