KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > internetcds > jdbc > tds > TdsUtil


1 //
2 // Copyright 2000 Craig Spannring, Bozeman Montana
3 //
4 // All rights reserved.
5 //
6 // Redistribution and use in source and binary forms, with or without
7 // modification, are permitted provided that the following conditions are met:
8 // 1. Redistributions of source code must retain the above copyright
9 // notice, this list of conditions and the following disclaimer.
10 // 2. Redistributions in binary form must reproduce the above copyright
11 // notice, this list of conditions and the following disclaimer in the
12 // documentation and/or other materials provided with the distribution.
13 // 3. All advertising materials mentioning features or use of this software
14 // must display the following acknowledgement:
15 // This product includes software developed by Craig Spannring
16 // 4. The name of Craig Spannring may not be used to endorse or promote
17 // products derived from this software without specific prior
18 // written permission.
19 //
20 // THIS SOFTWARE IS PROVIDED BY CRAIG SPANNRING ``AS IS'' AND
21 // ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
22 // IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
23 // ARE DISCLAIMED. IN NO EVENT SHALL CRAIG SPANNRING BE LIABLE
24 // FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
25 // DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
26 // OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
27 // HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
28 // LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
29 // OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
30 // SUCH DAMAGE.
31 //
32
33
34 package com.internetcds.jdbc.tds;
35
36 import java.sql.*;
37
38 public class TdsUtil
39 {
40    public static final String JavaDoc cvsVersion = "$Id: TdsUtil.java,v 1.1 2006/06/23 10:39:30 sinisa Exp $";
41
42
43    static public String JavaDoc javaSqlTypeToString(int type)
44    {
45       switch(type)
46       {
47          case java.sql.Types.BIT: return "BIT";
48          case java.sql.Types.TINYINT: return "TINYINT";
49          case java.sql.Types.SMALLINT: return "SMALLINT";
50          case java.sql.Types.INTEGER: return "INTEGER";
51          case java.sql.Types.BIGINT: return "BIGINT";
52          case java.sql.Types.FLOAT: return "FLOAT";
53          case java.sql.Types.REAL: return "REAL";
54          case java.sql.Types.DOUBLE: return "DOUBLE";
55          case java.sql.Types.NUMERIC: return "NUMERIC";
56          case java.sql.Types.DECIMAL: return "DECIMAL";
57          case java.sql.Types.CHAR: return "CHAR";
58          case java.sql.Types.VARCHAR: return "VARCHAR";
59          case java.sql.Types.LONGVARCHAR: return "LONGVARCHAR";
60          case java.sql.Types.DATE: return "DATE";
61          case java.sql.Types.TIME: return "TIME";
62          case java.sql.Types.TIMESTAMP: return "TIMESTAMP";
63          case java.sql.Types.BINARY: return "BINARY";
64          case java.sql.Types.VARBINARY: return "VARBINARY";
65          case java.sql.Types.LONGVARBINARY: return "LONGVARBINARY";
66          case java.sql.Types.NULL: return "NULL";
67          case java.sql.Types.OTHER: return "OTHER";
68          default: return "UNKNOWN" + type;
69       }
70    } /* javaSqlTypeToString() */
71 }
72
73
Popular Tags