SQLSERVER表查询字段自动生成JavaBean类

根据表字段，类型，注释，自动生JavaBean，简化开发；

注意以下几点:

1.sqlserver中生成的结果用文本显示：

2.最后粘贴到代码中，Ctrl+Shift+F进行格式化；

3.java中可通过代码生成get，set方法：代码中右键》Source=>Generate Getter and Setter

4.C#通过菜单中的操作，好像是“提取”，生成getset方法；

select '/**'+char(13)+char(10)  
+'*'+isnull(CONVERT(VARCHAR(100),g.value),'') + char(13)+char(10)  
+'*/'+char(13)+char(10)  
+'private '+  
case b.name when   
'int' then 'int'  
when 'varchar' then 'String'  
when 'nvarchar' then 'String'  
when 'text' then 'String'  
when 'float' then 'Double'  
when 'datetime' then 'Date' end  
+' '+lower(substring(a.name,1,1))+SUBSTRING(a.name,2,len(a.name)-1)--保持字段名称的原始大小写则直接用a.name  
+';'+char(13)+char(10)+char(13)+char(10)  
--,b.name,a.max_length ,g.value,b.name,a.name  
from sys.columns a left join sys.types b on a.user_type_id=b.user_type_id   
left join sys.extended_properties g on a.object_id=g.major_id and a.column_id=g.minor_id  
where object_id=object_id('t_info_content') ;--其中t_party_study为表名 

生成C#的Model类则将注释改下即可：

/****/改成///summary

select '/// <summary>'+char(13)+char(10)
+'/// '+isnull(CONVERT(VARCHAR(100),g.value),'') + char(13)+char(10)
+'/// <summary>'+char(13)+char(10)
+'private '+
case b.name when 
'int' then 'int'
when 'varchar' then 'String'
when 'float' then 'Double'
when 'datetime' then 'Date' end
+' '+lower(substring(a.name,1,1))+SUBSTRING(a.name,2,len(a.name)-1)--保持字段名称则直接用a.name
+';'+char(13)+char(10)+char(13)+char(10)
--,b.name,a.max_length ,g.value,b.name,a.name
from sys.columns a left join sys.types b on a.user_type_id=b.user_type_id 
left join sys.extended_properties g on a.object_id=g.major_id and a.column_id=g.minor_id
where object_id=object_id('t_party_study') ;

生成效果如下：

///<summary>
///唯一主键
///<summary>
private int Id;
///<summary>
///学员编号
///<summary>
private int UserId;
///<summary>
///课程编号
///<summary>
private int CourseId;
///<summary>
///课程状态1.选课;2.学习中;3.完成;
///<summary>
private int Status;
///<summary>
///学习进度
///<summary>
private int Progress;
///<summary>
///选课时间
///<summary>
private date AddTime;
///<summary>
///学习时长
///<summary>
private Double StudyTime;
///<summary>
///考试时间
///<summary>
private Date ExamTime;
///<summary>
///考试成绩
///<summary>
private Double ExamScore;
///<summary>
///删除时间
///<summary>
private date DeleteTime;