GBase数据库对应JAVA字段类型

SELECT t.tabname,c.colno,
    c.colname AS name,
    (
        CASE
            WHEN c.coltype <256
            THEN ‘1’
            ELSE ‘0’
        END)       AS ISNULL,
    trim(substr(d.default,instr(d.default,’ '))) AS defaults,
    (
        CASE c.coltype
            WHEN ‘0’
            THEN ‘CHAR(’ || TRIM(CAST (c.collength AS CHAR(5))) || ‘)’
            WHEN ‘1’
            THEN ‘SMALLINT’
            WHEN ‘2’
            THEN ‘INTEGER’
            WHEN ‘3’
            THEN ‘FLOAT’
            WHEN ‘4’
            THEN ‘SMALLFLOAT’
            WHEN ‘5’
            THEN (
                    CASE
                        WHEN (c.collength - TRUNC(c.collength/256)*256 = 255)
                        THEN ‘decimal(’ || TRIM(CAST(TRUNC(c.collength/256) AS VARCHAR(8))) || ‘)’
                        ELSE ‘decimal(’ || TRIM(CAST(TRUNC(c.collength/256) AS VARCHAR(8)) || ‘,’
                            || CAST(c.collength - TRUNC(c.collength/256)*256 AS VARCHAR(8))) || ‘)’
                    END)
            WHEN ‘6’
            THEN ‘SERIAL’
            WHEN ‘7’
            THEN ‘DATE’
            WHEN ‘8’
            THEN (
                    CASE
                        WHEN (c.collength - TRUNC(c.collength/256)*256 = 255)
                        THEN ‘money(’ || TRIM(CAST(TRUNC(c.collength/256) AS VARCHAR(8))) || ‘)’
                        ELSE ‘money(’ || TRIM(CAST(TRUNC(c.collength/256) AS VARCHAR(8)) || ‘,’ ||
                            CAST(c.collength - TRUNC(c.collength/256)*256 AS VARCHAR(8))) || ‘)’
                    END)
            WHEN ‘9’
            THEN ‘NULL’
            WHEN ‘10’
            THEN ‘DATETIME’
            WHEN ‘11’
            THEN ‘BYTE’
            WHEN ‘12’
            THEN ‘TEXT’
            WHEN ‘13’
            THEN ‘VARCHAR(’ || TRIM(CAST(c.collength AS CHAR(5))) || ‘)’
            WHEN ‘14’
            THEN ‘INTERVAL’
            WHEN ‘15’
            THEN ‘NCHAR(’ || TRIM(CAST(c.collength AS CHAR(5))) || ‘)’
            WHEN ‘16’
            THEN ‘NVARCHAR(’ || TRIM(CAST(c.collength AS CHAR(5))) || ‘)’
            WHEN ‘17’
            THEN ‘INT8’
            WHEN ‘18’
            THEN ‘SERIAL8’
            WHEN ‘19’
            THEN ‘SET’
            WHEN ‘20’
            THEN ‘MULTISET’
            WHEN ‘21’
            THEN ‘LIST’
            WHEN ‘22’
            THEN ‘Unnamed ROW’
            WHEN ‘40’
            THEN ‘LVARCHAR(’ || TRIM(CAST(c.collength AS CHAR(5))) || ‘)’
            WHEN ‘41’
            THEN (
                case extended_id when ‘10’ then ‘BLOB’ when ‘11’ then ‘CLOB’ when ‘5’ then ‘BOOLEAN’  end
            )
            WHEN ‘44’
            THEN ‘BOOLEAN’
            WHEN ‘52’
            THEN ‘BIGINT’
            WHEN ‘256’
            THEN ‘CHAR(’ || TRIM(CAST(c.collength AS CHAR(5))) || ‘)’
            WHEN ‘257’
            THEN ‘SMALLINT’
            WHEN ‘258’
            THEN ‘INTEGER’
            WHEN ‘259’
            THEN ‘FLOAT’
            WHEN ‘260’
            THEN ‘REAL’
            WHEN ‘261’
            THEN (
                    CASE
                        WHEN (c.collength - TRUNC(c.collength/256)*256 = 255)
                        THEN ‘decimal(’ || TRIM(CAST(TRUNC(c.collength/256) AS VARCHAR(8))) || ‘)’
                        ELSE ‘decimal(’ || TRIM(CAST(TRUNC(c.collength/256) AS VARCHAR(8)) || ‘,’
                            || CAST(c.collength - TRUNC(c.collength/256)*256 AS VARCHAR(8))) || ‘)’
                    END)
            WHEN ‘262’
            THEN ‘SERIAL’
            WHEN ‘263’
            THEN ‘DATE’
            WHEN ‘264’
            THEN (
                    CASE
                        WHEN (c.collength - TRUNC(c.collength/256)*256 = 255)
                        THEN ‘money(’ || TRIM(CAST(TRUNC(c.collength/256) AS VARCHAR(8))) || ‘)’
                        ELSE ‘money(’ || TRIM(CAST(TRUNC(c.collength/256) AS VARCHAR(8)) || ‘,’ ||
                            CAST(c.collength - TRUNC(c.collength/256)*256 AS VARCHAR(8))) || ‘)’
                    END)
            WHEN ‘266’
            THEN ‘DATETIME’
            WHEN ‘267’
            THEN ‘BYTE’
            WHEN ‘268’
            THEN ‘TEXT’
            WHEN ‘269’
            THEN ‘VARCHAR(’ || TRIM(CAST(c.collength AS CHAR(5))) || ‘)’
            WHEN ‘270’
            THEN ‘INTERVAL’
            WHEN ‘271’
            THEN ‘NCHAR(’ || TRIM(CAST(c.collength AS CHAR(5))) || ‘)’
            WHEN ‘272’
            THEN ‘NVARCHAR(’ || TRIM(CAST(c.collength AS CHAR(5))) || ‘)’
            WHEN ‘273’
            THEN ‘INT8’
            WHEN ‘274’
            THEN ‘SERIAL8’
            WHEN ‘275’
            THEN ‘SET’
            WHEN ‘276’
            THEN ‘MULTISET’
            WHEN ‘277’
            THEN ‘LIST’
            WHEN ‘278’
            THEN ‘Unnamed ROW’
            WHEN ‘296’
            THEN ‘LVARCHAR(’ || TRIM(CAST(c.collength AS CHAR(5))) || ‘)’
            WHEN ‘298’
            THEN ‘BLOB’
            WHEN ‘299’
            THEN ‘BOOLEAN’
            WHEN ‘308’
            THEN ‘BIGINT’
            WHEN ‘309’
            THEN ‘BIGSERIAL’
            WHEN ‘4118’
            THEN ‘Named ROW’
            ELSE ‘UNKOWNTYPE’
        END)    AS jdbctype,
        c.collength as clength
FROM
    syscolumns c inner join systables t on c.tabid=t.tabid
    left join sysdefaults d on c.tabid=d.tabid  and c.colno = d.colno
WHERE
      t.tabname=<表名>;