SQL Server 通过SQL生成Java代码 （为了省事写的生成实体类中属性）

SELECT 
  --字段名=a.name,
  --类型=b.name,
  --字段说明=isnull(g.[value],''),
  CONVERT(VARCHAR(100),a.name) AS colname,
 CONVERT(VARCHAR(100),b.name) AS typedoc,
  CONCAT('	private ',	
	CASE CONVERT(VARCHAR(100),b.name)
	    WHEN 'varchar' THEN 'String'
        WHEN 'nvarchar' THEN 'String'
		WHEN 'int' THEN 'int'
		WHEN 'bigint' THEN 'Long'
		WHEN 'datetime' THEN 'Date'
	ELSE 'String' END,' ',
	 CONVERT(VARCHAR(100),a.name),';  //',	
	CONVERT(VARCHAR(100),isnull(g.[value],''))) AS  java
  FROM   syscolumns   a   
  left   join   systypes   b   on   a.xtype=b.xusertype   
  inner   join   sysobjects   d   on   a.id=d.id     and   d.xtype='U'   and     d.name<>'dtproperties'   
  left   join   syscomments   e   on   a.cdefault=e.id   
  left   join   sys.extended_properties g   on   a.id=g.major_id   and   a.colid=g.minor_id          
  left   join   sys.extended_properties f   on   d.id=f.major_id   and   f.minor_id   =0   
  --where   d.name='tContractCompany' --如果只查询指定表,加上此条件   
  order   by   a.id,a.colorder    

 

转载于:https://my.oschina.net/niaoge/blog/1942344