Extjs5开发学习-34-单个模块的设计[2建立表单表及bean].docx

Extjs5开发学习-34-单个模块的设计2建立表单表及bean建立表单方案表：sqlview plaincopy1. CREATETABLEdbo._ModuleFormScheme(2. tf_formSchemeIdintNOTNULL,3. tf_moduleIdnvarchar(10)COLLATEChinese_PRC_CI_ASNOTNULL,4. tf_schemeOrderintNOTNULL,5. tf_schemeNamenvarchar(50)COLLATEChinese_PRC_CI_ASNOTNULL,6. tf_isSystemSchemebitNULL,7. tf_windowHeightintNULL,8. tf_windowWidthintNULL,9. tf_numColsintNULL,10. tf_displayModenvarchar(20)COLLATEChinese_PRC_CI_ASNULL,11. tf_otherSettingnvarchar(max)COLLATEChinese_PRC_CI_ASNULL,12. CONSTRAINTPK_ModuleFormSchem_30F848EDPRIMARYKEYCLUSTERED13. (14. tf_formSchemeIdASC15. )WITH(IGNORE_DUP_KEY=OFF)ONPRIMARY,16. CONSTRAINT_ModuleFormScheme_ix1UNIQUENONCLUSTERED17. (18. tf_moduleIdASC,19. tf_schemeOrderASC20. )WITH(IGNORE_DUP_KEY=OFF)ONPRIMARY21. )ONPRIMARY22. 23. GO24. ALTERTABLEdbo._ModuleFormSchemeWITHCHECKADDCONSTRAINT_ModuleFormScheme_fk1FOREIGNKEY(tf_moduleId)25. REFERENCESdbo._Module(tf_moduleId)26. ONUPDATECASCADE27. ONDELETECASCADE 表单方案表的java bean:javaview plaincopy1. packagecom.jfok.server.hibernate.system;2. 3. importjava.io.Serializable;4. importjava.util.List;5. importjavax.persistence.CascadeType;6. importjavax.persistence.Column;7. importjavax.persistence.Entity;8. importjavax.persistence.FetchType;9. importjavax.persistence.GeneratedValue;10. importjavax.persistence.Id;11. importjavax.persistence.JoinColumn;12. importjavax.persistence.ManyToOne;13. importjavax.persistence.OneToMany;14. importjavax.persistence.OrderBy;15. 16. importorg.codehaus.jackson.annotate.JsonIgnore;17. importorg.hibernate.annotations.GenericGenerator;18. mon.annotation.FieldDefine;19. mon.annotation.TableDefine;20. 21. SuppressWarnings(serial)22. Entity23. org.hibernate.annotations.Entity(dynamicUpdate=true)24. TableDefine(group=系统模块,id=9907,title=模块Form方案,shortname=Form方案)25. publicclass_ModuleFormSchemeimplements_IModuleControlInterface,Serializable26. 27. Id28. GeneratedValue(generator=increment)29. GenericGenerator(name=increment,strategy=increment)30. FieldDefine(title=ID号,number=10)31. privateIntegertf_formSchemeId;32. 33. JsonIgnore34. ManyToOne(cascade=CascadeType.REFRESH,fetch=FetchType.EAGER)35. JoinColumn(name=tf_moduleId,nullable=false)36. FieldDefine(title=模块,number=20)37. private_Moduletf_Module;38. 39. FieldDefine(title=顺序号,number=30)40. Column(nullable=false)41. privateIntegertf_schemeOrder;42. 43. FieldDefine(title=方案名称,nameField=true,number=40)44. Column(nullable=false,length=50)45. privateStringtf_schemeName;46. 47. FieldDefine(title=系统方案,number=50)48. privateBooleantf_isSystemScheme;49. 50. FieldDefine(title=窗口高,number=60)51. privateIntegertf_windowHeight;52. 53. FieldDefine(title=窗口宽,number=70)54. privateIntegertf_windowWidth;55. 56. FieldDefine(title=分栏数,number=80)57. privateIntegertf_numCols;58. 59. FieldDefine(title=Form类型,number=90)60. privateStringtf_displayMode;61. 62. FieldDefine(title=附加设置,number=100)63. privateStringtf_otherSetting;64. 65. OneToMany(targetEntity=_ModuleFormSchemeGroup.class,fetch=FetchType.LAZY,cascade=CascadeType.ALL)66. JoinColumn(name=tf_formSchemeId)67. OrderBy(tf_formGroupOrder)68. privateListmoduleFormSchemeGroups;69. 70. public_ModuleFormScheme()71. 72. 73. /getterandsetter74. 表单分组的表的定义及bean:sqlview plaincopy1. CREATETABLEdbo._ModuleFormSchemeGroup(2. tf_formGroupIdintNOTNULL,3. tf_formSchemeIdintNOTNULL,4. tf_formGroupOrderintNOTNULL,5. tf_formGroupNamenvarchar(50)COLLATEChinese_PRC_CI_ASNOTNULL,6. tf_displayModenvarchar(50)COLLATEChinese_PRC_CI_ASNULL,7. tf_collapsiblebitNULL,8. tf_collapsedbitNULL,9. tf_numColsintNULL,10. tf_auditingGroupbitNULL,11. tf_approveGroupbitNULL,12. tf_subModuleNamenvarchar(50)COLLATEChinese_PRC_CI_ASNULL,13. tf_otherSettingnvarchar(max)COLLATEChinese_PRC_CI_ASNULL,14. CONSTRAINTPK_ModuleFormSchem_5070F446PRIMARYKEYCLUSTERED15. (16. tf_formGroupIdASC17. )WITH(IGNORE_DUP_KEY=OFF)ONPRIMARY18. )ONPRIMARY19. 20. GO21. ALTERTABLEdbo._ModuleFormSchemeGroupWITHCHECKADDCONSTRAINT_ModuleFormSchemeGroup_fk1FOREIGNKEY(tf_formSchemeId)22. REFERENCESdbo._ModuleFormScheme(tf_formSchemeId)23. ONDELETECASCADEjavaview plaincopy1. packagecom.jfok.server.hibernate.system;2. 3. importjava.io.Serializable;4. importjava.util.List;5. importjavax.persistence.CascadeType;6. importjavax.persistence.Column;7. importjavax.persistence.Entity;8. importjavax.persistence.FetchType;9. importjavax.persistence.GeneratedValue;10. importjavax.persistence.Id;11. importjavax.persistence.JoinColumn;12. importjavax.persistence.ManyToOne;13. importjavax.persistence.OneToMany;14. importjavax.persistence.OrderBy;15. 16. importorg.codehaus.jackson.annotate.JsonIgnore;17. importorg.hibernate.annotations.GenericGenerator;18. mon.annotation.FieldDefine;19. mon.annotation.TableDefine;20. 21. SuppressWarnings(serial)22. Entity23. org.hibernate.annotations.Entity(dynamicUpdate=true)24. TableDefine(group=系统模块,id=9908,title=模块Form字段分组,shortname=Form字段分组)25. publicclass_ModuleFormSchemeGroupimplements_IModuleControlInterface,Serializable26. 27. publicstaticfinalStringFORMGROUPID=tf_formGroupId;28. 29. Id30. GeneratedValue(generator=increment)31. GenericGenerator(name=increment,strategy=increment)32. FieldDefine(title=ID号,number=10)33. privateIntegertf_formGroupId;34. 35. JsonIgnore36. ManyToOne(cascade=CascadeType.REFRESH,fetch=FetchType.EAGER)37. JoinColumn(name=tf_formSchemeId,nullable=false)38. FieldDefine(title=模块Form方案,number=20)39. private_ModuleFormSchemetf_ModuleFormScheme;40. 41. FieldDefine(title=顺序号,number=30)42. Column(nullable=false)43. privateIntegertf_formGroupOrder;44. 45. FieldDefine(title=分组名称,nameField=true,number=40)46. Column(nullable=false,length=50)47. privateStringtf_formGroupName;48. 49. FieldDefine(title=显示方式,number=50)50. Column(length=50)51. privateStringtf_displayMode;52. 53. FieldDefine(title=分栏数,number=60)54. privateIntegertf_numCols;55. 56. FieldDefine(title=审核组,number=70)57. privateBooleantf_auditingGroup;58. 59. FieldDefine(title=审批组,number=80)60. privateBooleantf_approveGroup;61. 62. FieldDefine(title=可折叠,number=90)63. privateBooleantf_collapsible;64. 65. FieldDefine(title=默认折叠,number=100)66. privateBooleantf_collapsed;67. 68. FieldDefine(title=子模块名称,remark=设置此项，则在此组中显示该子模块,number=110)69. Column(length=50)70. privateStringtf_subModuleName;71. 72. FieldDefine(title=其他设置,number=120)73. privateStringtf_otherSetting;74. 75. OneToMany(targetEntity=_ModuleFormSchemeGroupField.class,fetch=FetchType.LAZY,cascade=CascadeType.ALL)76. JoinColumn(name=tf_formGroupId)77. OrderBy(tf_formFieldOrder)78. privateListmoduleFormSchemeGroupFields;79. 80. public_ModuleFormSchemeGroup()81. 82. 83. 84. /getterandsetter85. 表单字段定义和bean:sqlview plaincopy1. CREATETABLEdbo._ModuleFormSchemeGroupField(2. tf_formFieldIdintNOTNULL,3. tf_formGroupIdintNOTNULL,4. tf_formFieldOrderintNOTNULL,5. tf_fieldIdintNOTNULL,6. tf_widthintNULL,7. tf_heightintNULL,8. tf_colspanintNULL,9. tf_isAllowApprovebitNULL,10. tf_isStartRowbitNULL,11. tf_isEndrowbitNULL,12. tf_otherSettingnvarchar(max)COLLATEChinese_PRC_CI_ASNULL,13. CONSTRAINTPK_ModuleFormSchem_6FE99F9FPRIMARYKEYCLUSTERED14. (15. tf_formFieldIdASC16. )WITH(IGNORE_DUP_KEY=OFF)ONPRIMARY,17. CONSTRAINT_ModuleFormSchemeGroupField_ix1UNIQUENONCLUSTERED18. (19. tf_formGroupIdASC,20. tf_fieldIdASC21. )WITH(IGNORE_DUP_KEY=OFF)ONPRIMARY22. )ONPRIMARY23. 24. GO25. ALTERTABLEdbo._ModuleFormSchemeGroupFieldWITHCHECKADDCONSTRAINT_ModuleFormSchemeGroupField_fk1FOREIGNKEY(tf_formGroupId)26. REFERENCESdbo._ModuleFormSchemeGroup(tf_formGroupId)27. ONUPDATECASCADE28. ONDELETECASCADE29. GO30. ALTERTABLEdbo._ModuleFormSchemeGroupFieldWITHCHECKADDCONSTRAINT_ModuleFormSchemeGroupField_fk2FOREIGNKEY(tf_fieldId)31. REFERENCESdbo._ModuleField(tf_fieldId)32. ONUPDATECASCADE33. ONDELETECASCADEjavaview plaincopy1. packagecom.jfok.server.hibernate.system;2. 3. importjava.io.Serializable;4. 5. importjavax.persistence.CascadeType;6. importjavax.persistence.Column;7. importjavax.persistence.Entity;8. importjavax.persistence.FetchType;9. importjavax.persistence.GeneratedValue;10. importjavax.persistence.Id;11. importjavax.persistence.JoinColumn;12. importjavax.persistence.ManyToOne;13. importorg.codehaus.jackson.annotate.JsonIgnore;14. importorg.hibernate.annotations.GenericGenerator;15. mon.annotation.FieldDefine;16. mon.annotation.TableDefine;17. 18. SuppressWarnings(serial)19. Entity20. org.hibernate.annotations.Entity(dynamicUpdate=true)21. TableDefine(group=系统模块,id=9909,title=模块Form字段,shortname=Form字段)22. publicclass_ModuleFormSchemeGroupFieldimplements_IModuleControlInterface,Serializable23. Id24. GeneratedValue(generator=increment)25. GenericGenerator(name=increment,strategy=increment)26. FieldDefine(title=ID号,hidden=true,number=10)27. privateIntegertf_formFieldId;28. 29. JsonIgnore30. ManyToOne(cascade=CascadeType.REFRESH,fetch=FetchType.LAZY)31. JoinColumn(name=tf_formGroupId,nullable=false)32. FieldDefine(title=模块Form字段分组,number=20)33. private_ModuleFormSchemeGrouptf_ModuleFormSchemeGroup;34. 35. FieldDefine(title=顺序号,number=30)36. Column(nullable=false)37. privateIntegertf_formFieldOrder;38. 39. JsonIgnore40. ManyToOne(cascade=CascadeType.REFRESH,fetch=FetchType.EAGER)41. JoinColumn(name=tf_fieldId,nullable=false)42. FieldDefine(title=模块字段,nameField=true,number=40)43. private_ModuleFieldtf_ModuleField;44. 45. /这个字段用于将数据转成json传到前台时候，加入moduleField的id46. Column(insertable=false,updatable=false)47. privateIntegertf_fieldId;48. 49. Fi