01: /*
02: * Copyright (c) 1998-2008 Caucho Technology -- all rights reserved
03: *
04: * This file is part of Resin(R) Open Source
05: *
06: * Each copy or derived work must preserve the copyright notice and this
07: * notice unmodified.
08: *
09: * Resin Open Source is free software; you can redistribute it and/or modify
10: * it under the terms of the GNU General Public License as published by
11: * the Free Software Foundation; either version 2 of the License, or
12: * (at your option) any later version.
13: *
14: * Resin Open Source is distributed in the hope that it will be useful,
15: * but WITHOUT ANY WARRANTY; without even the implied warranty of
16: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE, or any warranty
17: * of NON-INFRINGEMENT. See the GNU General Public License for more
18: * details.
19: *
20: * You should have received a copy of the GNU General Public License
21: * along with Resin Open Source; if not, write to the
22: * Free SoftwareFoundation, Inc.
23: * 59 Temple Place, Suite 330
24: * Boston, MA 02111-1307 USA
25: *
26: * @author Scott Ferguson
27: */
28:
29: package com.caucho.db.sql;
30:
31: import java.sql.SQLException;
32:
33: /**
34: * Ordering a string-valued field.
35: */
36: class StringOrder extends Order {
37: private int _column;
38:
39: StringOrder(int column) {
40: _column = column;
41: }
42:
43: public int compare(SelectResult result, int indexA, int indexB)
44: throws SQLException {
45: result.setRow(indexA);
46:
47: String valueA = result.getString(_column);
48:
49: result.setRow(indexB);
50: String valueB = result.getString(_column);
51:
52: int sign = isAscending() ? 1 : -1;
53:
54: if (valueA == valueB)
55: return _next == null ? 0 : _next.compare(result, indexA,
56: indexB);
57: else if (valueA == null)
58: return sign;
59: else if (valueB == null)
60: return -sign;
61:
62: int cmp = valueA.compareTo(valueB);
63: if (cmp == 0)
64: return _next == null ? 0 : _next.compare(result, indexA,
65: indexB);
66: else
67: return cmp;
68: }
69: }
|