KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > caucho > db > sql > IntOrder


1 /*
2  * Copyright (c) 1998-2006 Caucho Technology -- all rights reserved
3  *
4  * This file is part of Resin(R) Open Source
5  *
6  * Each copy or derived work must preserve the copyright notice and this
7  * notice unmodified.
8  *
9  * 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 JavaDoc;
32
33 /**
34  * Ordering an int-valued field.
35  */
36 class IntOrder extends Order {
37   private int _column;
38   
39   IntOrder(int column)
40   {
41     _column = column;
42   }
43
44   /**
45    * Returns the result of comparing the two results.
46    */
47   public int compare(SelectResult result, int indexA, int indexB)
48     throws SQLException JavaDoc
49   {
50     result.setRow(indexA);
51
52     int valueA = result.getInt(_column);
53     if (result.wasNull())
54       valueA = Integer.MIN_VALUE;
55     
56     result.setRow(indexB);
57
58     int valueB = result.getInt(_column);
59     if (result.wasNull())
60       valueB = Integer.MIN_VALUE;
61
62     if (valueA < valueB)
63       return isAscending() ? -1 : 1;
64     else if (valueA == valueB)
65       return 0;
66     else
67       return isAscending() ? 1 : -1;
68   }
69 }
70
Popular Tags