SQL转为java的代码

select t.column_description,concat(’/**’,convert(nvarchar(max),t.column_description),’*/’,'private ‘,CASE t.column_type
WHEN ‘varchar’ THEN ‘String’
WHEN ‘nvarchar ’ THEN ‘String’
WHEN ‘bit’ THEN ‘boolean’
WHEN ‘int’ THEN ‘Integer’
WHEN ‘tinyint’ THEN ‘Integer’
WHEN ‘bigint’ THEN ‘Long’
WHEN ‘datetime’ THEN ‘long’
WHEN ‘date’ THEN ‘Date’
ELSE t.column_type
END
,’ ‘,t.column_name,’;’) from (
SELECT A.name AS table_name,
B.name AS column_name, C.value AS column_description ,D.name as column_type
FROM sys.tables A
INNER JOIN sys.columns B ON B.object_id = A.object_id
LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_id
LEFT JOIN systypes D on B.user_type_id = D.xusertype
WHERE A.name = ‘表名’) t;

将表名改为 你所要转化的 表名