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