KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > smallsql > database > ExpressionFunctionSign


1 /* =============================================================
2  * SmallSQL : a free Java DBMS library for the Java(tm) platform
3  * =============================================================
4  *
5  * (C) Copyright 2004-2006, by Volker Berlin.
6  *
7  * Project Info: http://www.smallsql.de/
8  *
9  * This library is free software; you can redistribute it and/or modify it
10  * under the terms of the GNU Lesser General Public License as published by
11  * the Free Software Foundation; either version 2.1 of the License, or
12  * (at your option) any later version.
13  *
14  * This library is distributed in the hope that it will be useful, but
15  * WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
16  * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public
17  * License for more details.
18  *
19  * You should have received a copy of the GNU Lesser General Public
20  * License along with this library; if not, write to the Free Software
21  * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301,
22  * USA.
23  *
24  * [Java is a trademark or registered trademark of Sun Microsystems, Inc.
25  * in the United States and other countries.]
26  *
27  * ---------------
28  * ExpressionFunctionSign.java
29  * ---------------
30  * Author: Volker Berlin
31  *
32  * Created on 21.06.2004
33  */
34 package smallsql.database;
35
36
37 /**
38  * @author Volker Berlin
39  */
40 final class ExpressionFunctionSign extends ExpressionFunctionReturnInt {
41
42
43     final int getFunction() {
44         return SQLTokenizer.SIGN;
45     }
46
47
48     final int getInt() throws Exception JavaDoc {
49         if(param1.isNull()) return 0;
50         switch(ExpressionArithmetic.getBestNumberDataType(param1.getDataType())){
51             case SQLTokenizer.INT:
52                 int intValue = param1.getInt();
53                 if(intValue < 0)
54                     return -1;
55                 if(intValue > 0)
56                     return 1;
57                 return 0;
58             case SQLTokenizer.BIGINT:
59                 long longValue = param1.getLong();
60                 if(longValue < 0)
61                     return -1;
62                 if(longValue > 0)
63                     return 1;
64                 return 0;
65             case SQLTokenizer.MONEY:
66                 longValue = param1.getMoney();
67                 if(longValue < 0)
68                     return -1;
69                 if(longValue > 0)
70                     return 1;
71                 return 0;
72             case SQLTokenizer.DECIMAL:
73                 return param1.getNumeric().getSignum();
74             case SQLTokenizer.DOUBLE:
75                 double doubleValue = param1.getDouble();
76                 if(doubleValue < 0)
77                     return -1;
78                 if(doubleValue > 0)
79                     return 1;
80                 return 0;
81             default:
82                 throw new Error JavaDoc();
83         }
84     }
85 }
86
Popular Tags