JAVA项目中枚举和字典表,枚举与字典表的选择

package com.raise.vo.enums;

/**

* @description： 审批提现状态枚举

* @author： jialiuyang

* @update： 2015-8

* @version： 1.0

*/

public enum AppCashType  {

NO((short)0, "未审批"),

/**可提现*/

YES((short)1, "终审通过"),

/**提现中*/

IN((short)2, "已拒绝"),

/**提现中*/

FIRST((short)3, "初审通过");

/** code */

private Short code;

/** 显示标签 */

private String label;

/**

* 构造器，必须私有

* @param code

*/

AppCashType(Short code, String label){

this.code = code;

this.label = label;

}

/**

* 获取code的文本

* @param code

* @return

*/

public static String getLabelByCode (Short code){

for (AppCashType enuma : AppCashType.values()){

if (enuma.getCode().compareTo(code) == 0){

return enuma.getLabel();

}

}

return "未知枚举项";

}

/**

* 根据文本获取code

*/

public static Short getCodeByLabel(String label){

for(AppCashType enuma : AppCashType.values()){

if(enuma.getLabel().equals(label)){

return enuma.getCode();

}

}

return null;

}

public String toString(){

return label;

}

public String getLabel() {

return label;

}

public Short getShort(){

return this.code;

}

public Short getCode(){

return this.code;

}

}

字典表

drop table datadic_groups; create table datadic_groups( group_code varchar2(20) primary key, group_name varchar2(50)  ); drop table datadic_items; create table datadic_items( dataitem_code varchar2(20) primary key, dataitem_name varchar2(50), group_code varchar2(20) );foreign key (group_code)

//查询数据库，根据组名称查询组编号，根据组编号获取该组内数据字典项信息

String strSql = "select items.dataitem_code, items.dataitem_name, items.group_code, dgroups.group_name from datadic_items items, datadic_groups dgroups where items.group_code = dgroups.group_code and dgroups.group_name='"+gName+"'";

枚举适合简单、固定字段。字典表适合大型、需维护字段