根据表字段,类型,注释,自动生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;