KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > quadcap > sql > types > TypeDecimal


1 package com.quadcap.sql.types;
2
3 /* Copyright 1999 - 2003 Quadcap Software. All rights reserved.
4  *
5  * This software is distributed under the Quadcap Free Software License.
6  * This software may be used or modified for any purpose, personal or
7  * commercial. Open Source redistributions are permitted. Commercial
8  * redistribution of larger works derived from, or works which bundle
9  * this software requires a "Commercial Redistribution License"; see
10  * http://www.quadcap.com/purchase.
11  *
12  * Redistributions qualify as "Open Source" under one of the following terms:
13  *
14  * Redistributions are made at no charge beyond the reasonable cost of
15  * materials and delivery.
16  *
17  * Redistributions are accompanied by a copy of the Source Code or by an
18  * irrevocable offer to provide a copy of the Source Code for up to three
19  * years at the cost of materials and delivery. Such redistributions
20  * must allow further use, modification, and redistribution of the Source
21  * Code under substantially the same terms as this license.
22  *
23  * Redistributions of source code must retain the copyright notices as they
24  * appear in each source code file, these license terms, and the
25  * disclaimer/limitation of liability set forth as paragraph 6 below.
26  *
27  * Redistributions in binary form must reproduce this Copyright Notice,
28  * these license terms, and the disclaimer/limitation of liability set
29  * forth as paragraph 6 below, in the documentation and/or other materials
30  * provided with the distribution.
31  *
32  * The Software is provided on an "AS IS" basis. No warranty is
33  * provided that the Software is free of defects, or fit for a
34  * particular purpose.
35  *
36  * Limitation of Liability. Quadcap Software shall not be liable
37  * for any damages suffered by the Licensee or any third party resulting
38  * from use of the Software.
39  */
40
41 import java.io.Externalizable JavaDoc;
42 import java.io.IOException JavaDoc;
43 import java.io.ObjectInput JavaDoc;
44 import java.io.ObjectOutput JavaDoc;
45
46 import java.sql.ResultSet JavaDoc;
47 import java.sql.SQLException JavaDoc;
48 import java.sql.Types JavaDoc;
49
50 import java.math.BigDecimal JavaDoc;
51
52 import com.quadcap.util.Debug;
53
54 /**
55  * The SQL <b>DECIMAL</b> type.
56  *
57  * @author Stan Bailes
58  */
59 public class TypeDecimal implements Type, Externalizable JavaDoc {
60     public static final TypeDecimal typeDecimal = new TypeDecimal();
61
62     int precision = -1;
63     int scale = -1;
64
65     public TypeDecimal() {}
66
67     public TypeDecimal(int precision, int scale) {
68     this.precision = precision;
69     this.scale = scale;
70     }
71     
72     public String JavaDoc getTypeName() {
73     return "DECIMAL";
74     }
75
76     public int getJDBCType() { return Types.DECIMAL; }
77
78     public String JavaDoc getJDBCClassName() { return "java.math.BigDecimal"; }
79
80     public int getPrecision() { return precision; }
81
82     public int getScale() { return scale; }
83
84     public int getMaxPrecision() { return -1; }
85
86     public int getMinScale() { return -1; }
87
88     public int getMaxScale() { return -1; }
89
90     public boolean isCharType() { return false; }
91
92     public boolean isCaseSensitive() { return false; }
93
94     public boolean isCurrency() { return false; }
95
96     public boolean isSigned() { return true; }
97
98     public int getDisplayWidth() { return precision + 1; }
99     
100     public String JavaDoc toString() {
101         if (precision > 0) {
102             return "DECIMAL(" + precision + ", " + scale + ")";
103         } else {
104             return "DECIMAL";
105         }
106     }
107     
108     public void readExternal(ObjectInput JavaDoc in) throws IOException JavaDoc {
109     precision = in.readInt();
110     scale = in.readInt();
111     }
112     
113     public void writeExternal(ObjectOutput JavaDoc out) throws IOException JavaDoc {
114     out.writeInt(precision);
115     out.writeInt(scale);
116     }
117
118     public Value convert(Value v) throws ValueException {
119     return v.convert(this);
120     }
121
122     /**
123      * Utility method to help convert numbers to DECIMALs
124      */
125     public Value convertNumber(long n) throws ValueException {
126         if (precision > 0 && scale >= 0) {
127             long lim = (long)(Math.pow(10, precision-scale)) - 1;
128             if (n > lim || n < (0-lim)) {
129                 throw new ValueException("Can't convert to type: " + this);
130             }
131         }
132         BigDecimal JavaDoc d =
133             BigDecimal.valueOf(n).setScale((scale < 0 ? 0 : scale),
134                                            BigDecimal.ROUND_HALF_DOWN);
135         return new ValueScaledInteger(d);
136     }
137
138     public String JavaDoc getCreateParams() {
139         return "precision, scale";
140     }
141 }
142
Popular Tags