|
1 package com.teamkonzept.db;
2
3 import java.sql.*;
4
5
10
11 public class TKSybaseSQLTypeConverter extends TKSQLTypeConverter {
12
13
14 private final static int VARCHAR_PRECISION = 255;
15 private final static int VARCHAR_MINIMUM_SCALE = 0;
16 private final static int VARCHAR_MAXIMUM_SCALE = 0;
17 private final static boolean VARCHAR_UNSIGNED_ATTRIBUTE = false;
18 private final static int VARCHAR_UNSIGNED_NUM_PREC_RADIX = 0;
19
20 private final static int LONGVARCHAR_PRECISION = 2147483647;
21 private final static int LONGVARCHAR_MINIMUM_SCALE = 0;
22 private final static int LONGVARCHAR_MAXIMUM_SCALE = 0;
23 private final static boolean LONGVARCHAR_UNSIGNED_ATTRIBUTE = false;
24 private final static int LONGVARCHAR_UNSIGNED_NUM_PREC_RADIX = 0;
25
26 private final static int BINARY_PRECISION = 255;
27 private final static int BINARY_MINIMUM_SCALE = 0;
28 private final static int BINARY_MAXIMUM_SCALE = 0;
29 private final static boolean BINARY_UNSIGNED_ATTRIBUTE = false;
30 private final static int BINARY_UNSIGNED_NUM_PREC_RADIX = 0;
31
32 private final static int VARBINARY_PRECISION = 255;
33 private final static int VARBINARY_MINIMUM_SCALE = 0;
34 private final static int VARBINARY_MAXIMUM_SCALE = 0;
35 private final static boolean VARBINARY_UNSIGNED_ATTRIBUTE = false;
36 private final static int VARBINARY_UNSIGNED_NUM_PREC_RADIX = 0;
37
38 private final static int REAL_PRECISION = 7;
39 private final static int REAL_MINIMUM_SCALE = 0;
40 private final static int REAL_MAXIMUM_SCALE = 0;
41 private final static boolean REAL_UNSIGNED_ATTRIBUTE = false;
42 private final static int REAL_UNSIGNED_NUM_PREC_RADIX = 10;
43
44 private final static int LONGVARBINARY_PRECISION = 2147483647;
45 private final static int LONGVARBINARY_MINIMUM_SCALE = 0;
46 private final static int LONGVARBINARY_MAXIMUM_SCALE = 0;
47 private final static boolean LONGVARBINARY_UNSIGNED_ATTRIBUTE = false;
48 private final static int LONGVARBINARY_UNSIGNED_NUM_PREC_RADIX = 0;
49
50 private final static int FLOAT_PRECISION = 15;
51 private final static int FLOAT_MINIMUM_SCALE = 0;
52 private final static int FLOAT_MAXIMUM_SCALE = 0;
53 private final static boolean FLOAT_UNSIGNED_ATTRIBUTE = false;
54 private final static int FLOAT_UNSIGNED_NUM_PREC_RADIX = 10;
55
56 private final static int SMALLINT_PRECISION = 5;
57 private final static int SMALLINT_MINIMUM_SCALE = 0;
58 private final static int SMALLINT_MAXIMUM_SCALE = 0;
59 private final static boolean SMALLINT_UNSIGNED_ATTRIBUTE = false;
60 private final static int SMALLINT_UNSIGNED_NUM_PREC_RADIX = 10;
61
62 private final static int TINYINT_PRECISION = 3;
63 private final static int TINYINT_MINIMUM_SCALE = 0;
64 private final static int TINYINT_MAXIMUM_SCALE = 0;
65 private final static boolean TINYINT_UNSIGNED_ATTRIBUTE = false;
66 private final static int TINYINT_UNSIGNED_NUM_PREC_RADIX = 10;
67
68 private final static int INTEGER_PRECISION = 10;
69 private final static int INTEGER_MINIMUM_SCALE = 0;
70 private final static int INTEGER_MAXIMUM_SCALE = 0;
71 private final static boolean INTEGER_UNSIGNED_ATTRIBUTE = false;
72 private final static int INTEGER_UNSIGNED_NUM_PREC_RADIX = 10;
73
74 private final static int BIT_PRECISION = 1;
75 private final static int BIT_MINIMUM_SCALE = 0;
76 private final static int BIT_MAXIMUM_SCALE = 0;
77 private final static boolean BIT_UNSIGNED_ATTRIBUTE = false;
78 private final static int BIT_UNSIGNED_NUM_PREC_RADIX = 2;
79
80 private final static int DECIMAL_PRECISION = 28;
81 private final static int DECIMAL_MINIMUM_SCALE = 0;
82 private final static int DECIMAL_MAXIMUM_SCALE = 28;
83 private final static boolean DECIMAL_UNSIGNED_ATTRIBUTE = false;
84 private final static int DECIMAL_UNSIGNED_NUM_PREC_RADIX = 10;
85
86 private final static int NUMERIC_PRECISION = 28;
87 private final static int NUMERIC_MINIMUM_SCALE = 0;
88 private final static int NUMERIC_MAXIMUM_SCALE = 28;
89 private final static boolean NUMERIC_UNSIGNED_ATTRIBUTE = false;
90 private final static int NUMERIC_UNSIGNED_NUM_PREC_RADIX = 10;
91
92 private final static int CHAR_PRECISION = 255;
93 private final static int CHAR_MINIMUM_SCALE = 0;
94 private final static int CHAR_MAXIMUM_SCALE = 0;
95 private final static boolean CHAR_UNSIGNED_ATTRIBUTE = false;
96 private final static int CHAR_UNSIGNED_NUM_PREC_RADIX = 0;
97
98 static TypeInfo[] meta_data = {
99 new TypeInfo( Types.VARCHAR, "'", "'", VARCHAR_PRECISION, VARCHAR_MINIMUM_SCALE,VARCHAR_MAXIMUM_SCALE, VARCHAR_UNSIGNED_ATTRIBUTE, VARCHAR_UNSIGNED_NUM_PREC_RADIX ),
100 new TypeInfo( Types.LONGVARCHAR, "'", "'", LONGVARCHAR_PRECISION, LONGVARCHAR_MINIMUM_SCALE, LONGVARCHAR_MAXIMUM_SCALE, LONGVARCHAR_UNSIGNED_ATTRIBUTE, LONGVARCHAR_UNSIGNED_NUM_PREC_RADIX),
101 new TypeInfo( Types.BINARY, null, null, BINARY_PRECISION, BINARY_MINIMUM_SCALE, BINARY_MAXIMUM_SCALE, BINARY_UNSIGNED_ATTRIBUTE, BINARY_UNSIGNED_NUM_PREC_RADIX),
102 new TypeInfo( Types.VARBINARY, null, null, VARBINARY_PRECISION, VARBINARY_MINIMUM_SCALE, VARBINARY_MAXIMUM_SCALE, VARBINARY_UNSIGNED_ATTRIBUTE, VARBINARY_UNSIGNED_NUM_PREC_RADIX),
103 new TypeInfo( Types.REAL, null, null, REAL_PRECISION, REAL_MINIMUM_SCALE, REAL_MAXIMUM_SCALE, REAL_UNSIGNED_ATTRIBUTE, REAL_UNSIGNED_NUM_PREC_RADIX),
104 new TypeInfo( Types.LONGVARBINARY, null, null, LONGVARBINARY_PRECISION, LONGVARBINARY_MINIMUM_SCALE, LONGVARBINARY_MAXIMUM_SCALE, LONGVARBINARY_UNSIGNED_ATTRIBUTE, LONGVARBINARY_UNSIGNED_NUM_PREC_RADIX),
105 new TypeInfo( Types.FLOAT, null, null, FLOAT_PRECISION, FLOAT_MINIMUM_SCALE, FLOAT_MAXIMUM_SCALE, FLOAT_UNSIGNED_ATTRIBUTE, FLOAT_UNSIGNED_NUM_PREC_RADIX),
106 new TypeInfo( Types.SMALLINT, null, null, SMALLINT_PRECISION, SMALLINT_MINIMUM_SCALE, SMALLINT_MAXIMUM_SCALE, SMALLINT_UNSIGNED_ATTRIBUTE, SMALLINT_UNSIGNED_NUM_PREC_RADIX),
107 new TypeInfo( Types.TINYINT, null, null, TINYINT_PRECISION, TINYINT_MINIMUM_SCALE, TINYINT_MAXIMUM_SCALE, TINYINT_UNSIGNED_ATTRIBUTE, TINYINT_UNSIGNED_NUM_PREC_RADIX),
108 new TypeInfo( Types.INTEGER, null, null, INTEGER_PRECISION, INTEGER_MINIMUM_SCALE, INTEGER_MAXIMUM_SCALE, INTEGER_UNSIGNED_ATTRIBUTE, INTEGER_UNSIGNED_NUM_PREC_RADIX),
109 new TypeInfo( Types.BIT, null, null, BIT_PRECISION, BIT_MINIMUM_SCALE, BIT_MAXIMUM_SCALE, BIT_UNSIGNED_ATTRIBUTE, BIT_UNSIGNED_NUM_PREC_RADIX),
110 new TypeInfo( Types.DECIMAL, null, null, DECIMAL_PRECISION, DECIMAL_MINIMUM_SCALE, DECIMAL_MAXIMUM_SCALE, DECIMAL_UNSIGNED_ATTRIBUTE, DECIMAL_UNSIGNED_NUM_PREC_RADIX),
111 new TypeInfo( Types.NUMERIC, null, null, NUMERIC_PRECISION, NUMERIC_MINIMUM_SCALE, NUMERIC_MAXIMUM_SCALE, NUMERIC_UNSIGNED_ATTRIBUTE, NUMERIC_UNSIGNED_NUM_PREC_RADIX),
112 new TypeInfo( Types.CHAR, "'", "'", CHAR_PRECISION, CHAR_MINIMUM_SCALE, CHAR_MAXIMUM_SCALE, CHAR_UNSIGNED_ATTRIBUTE, CHAR_UNSIGNED_NUM_PREC_RADIX)
113 };
114 public TKSybaseSQLTypeConverter( final Connection conn )
115 {
116 this();
117 }
118 public TKSybaseSQLTypeConverter()
119 {
120 super( meta_data );
121 }
122 public boolean supportsConvert( final int from_type, final int to_type )
123 {
124 return false;
125 }
126 }
127
|
Popular Tags
|
Java API By Example, From Geeks To Geeks.