5.14. Codelist¶

Caution

This version is already obsolete. Please check the latest guideline.

Table of Contents

Overview
How to use
How to extend
Appendix
- Setting SimpleI18nCodeList
  - Set java.util.Map (key = code value, value = label) for each locale by rows
  - Set java.util.Map(key = locale, value = label) for each code value by columns
- Variations of NumberRangeCodeList
  - Create the Descending NumberRangeCodeList
  - Change interval of NumberRangeCodeList

5.14.1. Overview ¶

A codelist is a pair comprising of “Code values (Value) and their display names (Label)”.

It is used for mapping code values with the labels to be displayed on screen such as selectbox.

Common library provides the following functionalities:

Functionality to read and cache the codelist defined in xml file or DB at the time of launching the application.
Functionality to refer to the codelist from JSP or Java class
Functionality to perform input validation using codelist

Moreover, it also supports

internationalization of codelist
reloading of cached codelist

Note

As per standard specifications, only the codelist defined in DB is reloadable.

Following four types of codelists are implemented in common library.

**Types of codelist**¶
Types	Contents	Reloadable
`org.terasoluna.gfw.common.codelist.SimpleMapCodeList`	Use the hard-coded contents from xml file.	NO
`org.terasoluna.gfw.common.codelist.NumberRangeCodeList`	Use when creating number range list.	NO
`org.terasoluna.gfw.common.codelist.JdbcCodeList`	Use the codelist by fetching the code from DB using SQL.	YES
`org.terasoluna.gfw.common.codelist.EnumCodeList`	Use when creating the codelist from constant defined in `Enum` class.	NO
`org.terasoluna.gfw.common.codelist.i18n.SimpleI18nCodeList`	Use the codelist corresponding to java.util.Locale.	NO

Common library provides org.terasoluna.gfw.common.codelist.CodeList for the interface of above codelists.

Codelist class diagram provided in common library is as follows:

Picture - Image of codelist class diagram

5.14.2. How to use ¶

This section describes settings for various codelists and their implementation methods.

Using SimpleMapCodeList
Using NumberRangeCodeList
Using JdbcCodeList
How to use EnumCodeList
How to use SimpleI18nCodeList
Display code name corresponding to code value
Input validation of code value using codelist

5.14.2.1. Using SimpleMapCodeList ¶

org.terasoluna.gfw.common.codelist.SimpleMapCodeList reads the code values defined in xml file at the time of launching the application and uses them as is.

SimpleMapCodeList image

5.14.2.1.1. Example of codelist settings ¶

Definition of Bean definition file(xxx-codelist.xml)

It is recommended to create a bean definition file for codelist.

 <bean id="CL_ORDERSTATUS" class="org.terasoluna.gfw.common.codelist.SimpleMapCodeList"> <!-- (1) -->
     <property name="map">
         <util:map>
             <entry key="1" value="Received" /> <!-- (2) -->
             <entry key="2" value="Sent" />
             <entry key="3" value="Cancelled" />
         </util:map>
     </property>
 </bean>

Sr. No.	Description
(1)	Define a bean of SimpleMapCodeList class. beanID should have the name matching with the ID pattern of `org.terasoluna.gfw.web.codelist.CodeListInterceptor` described later.
(2)	Define Key, Value pairs of Map. When map-class attribute is omitted, it is registered in `java.util.LinkedHashMap`; hence in the above example, “Name and value” are stored in Map in the order of registration.

Definition of Bean definition file(xxx-domain.xml)

Once the bean definition file for codelist is created, it should be imported to already existing bean definition file.

 <import resource="classpath:META-INF/spring/projectName-codelist.xml" /> <!-- (3) -->
 <context:component-scan base-package="com.example.domain" />

 <!-- omitted -->

Sr. No.	Description
(3)	Import bean definition file for codelist. Resource information of import is necessary during component-scan; hence import should be set above `<context:component-scan base-package="com.example.domain" />`.

5.14.2.1.2. Using codelist in JSP ¶

By using the interceptor of common library, codelist can be set automatically in request scope and can be easily referred from JSP.

Definition of Bean definition file(spring-mvc.xml)

 <mvc:interceptors>
   <mvc:interceptor>
     <mvc:mapping path="/**" /> <!-- (1) -->
     <bean
       class="org.terasoluna.gfw.web.codelist.CodeListInterceptor"> <!-- (2) -->
       <property name="codeListIdPattern" value="CL_.+" /> <!-- (3) -->
     </bean>
   </mvc:interceptor>

   <!-- omitted -->

 </mvc:interceptors>

Sr. No.	Description
(1)	Set the applicable path.
(2)	Define a bean of CodeListInterceptor class.
(3)	Set the beanID pattern of codelist which is automatically set in the request scope. In pattern, regular expression used in `java.util.regex.Pattern` should be set. In the above example, only the data in which id is defined in “CL_XXX” format is targeted. In that case, bean definition wherein id does not start with “CL_” should not be imported. beanID defined in “CL_” can be used in JSP since it is set in the request scope. `codeListIdPattern` property can be omitted. If omitting `codeListIdPattern` property, all of `CodeList`s (all beans which implements `org.terasoluna.gfw.common.codelist.CodeList`) are available in JSP.

Example of implementing the codelist in jsp

<form:select path="orderStatus">
  <form:option value="" label="--Select--" /> <!-- (4) -->
  <form:options items="${CL_ORDERSTATUS}" /> <!-- (5) -->
</form:select>

Sr. No.	Description
(4)	When setting dummy value at the top of the selectbox, null characters should be specified in the value.
(5)	Specify the beanID for which codelist is defined.

Output HTML

<select id="orderStatus" name="orderStatus">
   <option value="">"--Select--</option>
   <option value="1">Received</option>
   <option value="2">Sent</option>
   <option value="3">Cancelled</option>
</select>

Output screen

5.14.2.1.3. Using codelist in Java class ¶

When using the codelist in Java class, inject the codelist by setting javax.inject.Inject annotation and javax.inject.Named annotation. Specify the codelist name in @Named annotation.

import javax.inject.Named;

import org.terasoluna.gfw.common.codelist.CodeList;

public class OrderServiceImpl implements OrderService {

    @Inject
    @Named("CL_ORDERSTATUS")
    CodeList orderStatusCodeList; // (1)

    public boolean existOrderStatus(String target) {
        return orderStatusCodeList.asMap().containsKey(target); // (2)
    }
}

Sr. No.	Description
(1)	Inject the codelist with beanID “CL_ORDERSTATUS”.
(2)	Fetch the codelist in `java.util.Map` format using CodeList#asMap method.

5.14.2.2. Using NumberRangeCodeList ¶

org.terasoluna.gfw.common.codelist.NumberRangeCodeList is a codelist that creates the list of numeric values of specified range at the time of launching the application. It is assumed that this codelist will mainly be used in the selectboxes having only numbers i.e. selectbox for month, date etc.

Image of NumberRangeCodeList

Tip

NumberRangeCodeList supports only Arabic numbers and does not support Chinese and Roman numbers. Chinese and Roman numbers can be supported by using JdbcCodeList and SimpleMapCodeList.

NumberRangeCodeList has the following features:

In order to set From value < To value, the values increased in accordance with the interval are set in From-To range in ascending order.
In order to set To value < From value, the values decreased in accordance with the interval are set in To-From range in descending order.
Increment (decrement) can be changed by setting intervals.

The information here describes how to configure the ascending NumberRangeCodeList. For how to create the descending NumberRangeCodeList or change interval, refer to “Variations of NumberRangeCodeList”. |

5.14.2.2.1. Example of codelist settings ¶

Example of setting From value < To value is shown below.

Definition of Bean definition file(xxx-codelist.xml)

<bean id="CL_MONTH"
    class="org.terasoluna.gfw.common.codelist.NumberRangeCodeList"> <!-- (1) -->
    <property name="from" value="1" /> <!-- (2) -->
    <property name="to" value="12" /> <!-- (3) -->
    <property name="valueFormat" value="%d" /> <!-- (4) -->
    <property name="labelFormat" value="%02d" /> <!-- (5) -->
    <property name="interval" value="1" /> <!-- (6) -->
</bean>

Sr. No.	Description
(1)	Define a bean of NumberRangeCodeList.
(2)	Specify the range start value. When omitted, “0” is set as range start value.
(3)	Specify the range end value. It cannot be blank.
(4)	Specify the format of the code value. Format used should be `java.lang.String.format`. When omitted, “%s” is set.
(5)	Specify the format of the code name. Format used should be `java.lang.String.format`. When omitted, “%s” is set.
(6)	Set the increment value. When omitted, “1” is set.

5.14.2.2.2. Using codelist in JSP ¶

For details on settings shown below, refer to Using codelist in JSP described earlier.

Example of jsp implementation

<form:select path="depMonth" items="${CL_MONTH}" />

Output HTML

<select id="depMonth" name="depMonth">
  <option value="1">01</option>
  <option value="2">02</option>
  <option value="3">03</option>
  <option value="4">04</option>
  <option value="5">05</option>
  <option value="6">06</option>
  <option value="7">07</option>
  <option value="8">08</option>
  <option value="9">09</option>
  <option value="10">10</option>
  <option value="11">11</option>
  <option value="12">12</option>
</select>

Output screen

5.14.2.2.3. Using codelist in Java class ¶

For details on settings shown below, refer to Using codelist in Java class described earlier.

5.14.2.3. Using JdbcCodeList ¶

org.terasoluna.gfw.common.codelist.JdbcCodeList is a class for creating codelist by fetching values from DB at the time of launching the application. This list is cached.

The fetched values can be changed dynamically by reloading. For details, refer to When reloading the codelist.

JdbcCodeList image

5.14.2.3.1. Example of codelist settings ¶

Definition of Table(authority)

authority_id	authority_name
01	STAFF_MANAGEMENT
02	MASTER_MANAGEMENT
03	STOCK_MANAGEMENT
04	ORDER_MANAGEMENT
05	SHOW_SHOPPING_CENTER

Definition of Bean definition file(xxx-codelist.xml)

<bean id="CL_AUTHORITIES" class="org.terasoluna.gfw.common.codelist.JdbcCodeList"> <!-- (1) -->
    <property name="dataSource" ref="dataSource" />
    <property name="querySql"
        value="SELECT authority_id, authority_name FROM authority ORDER BY authority_id" /> <!-- (2) -->
    <property name="valueColumn" value="authority_id" /> <!-- (3) -->
    <property name="labelColumn" value="authority_name" /> <!-- (4) -->
</bean>

Sr. No.	Description
(1)	Define a bean of JdbcCodeList class.
(2)	Write an SQL for fetching the codelist in querySql property. At that time, make sure to specify ORDER BY clause to define the order. If ORDER BY is not specified, the order gets changed every time when records are fetched using SQL.
(3)	Set the value corresponding to the Key of Map in valueColumn property. In this example, authority_id is set.
(4)	Set the value corresponding to the Value of Map in labelColumn property. In this example, authority_name is set.

5.14.2.3.2. Using codelist in JSP ¶

For details on settings shown below, refer to Using codelist in JSP described earlier.

Example of jsp implementation

<form:checkboxes items="${CL_AUTHORITIES}"/>

Output HTML

<span>
  <input id="authorities1" name="authorities" type="checkbox" value="01"/>
  <label for="authorities1">STAFF_MANAGEMENT</label>
</span>
<span>
  <input id="authorities2" name="authorities" type="checkbox" value="02"/>
  <label for="authorities2">MASTER_MANAGEMENT</label>
</span>
<span>
  <input id="authorities3" name="authorities" type="checkbox" value="03"/>
  <label for="authorities3">STOCK_MANAGEMENT</label>
</span>
<span>
  <input id="authorities4" name="authorities" type="checkbox" value="04"/>
  <label for="authorities4">ORDER_MANAGEMENT</label>
</span>
<span>
  <input id="authorities5" name="authorities" type="checkbox" value="05"/>
  <label for="authorities5">SHOW_SHOPPING_CENTER</label>
</span>

Output screen

5.14.2.3.3. Using codelist in Java class ¶

For details on settings shown below, refer to Using codelist in Java class described earlier.

5.14.2.4. How to use EnumCodeList ¶

org.terasoluna.gfw.common.codelist.EnumCodeList is a class for creating codelist from constant defined in Enum class.

Note

In case of handling codelist in applications that match with the following conditions, it should be analyzed if the codelist label can be stored in Enum class using EnumCodeList . By storing codelist label in Enum class, the information and operations linked with code values can be aggregated in Enum class.

It is necessary to store the code values in Enum class (i.e. the process needs to be performed considering code values in Java logic)
Internationalization (multilingualization) of UI is not required

Image of using EnumCodeList is shown below.

Note

In EnumCodeList, org.terasoluna.gfw.common.codelist.EnumCodeList.CodeListItem interface is provided to fetch the information (code values and labels) required for creating codelist from Enum class.

In case of using EnumCodeList, EnumCodeList.CodeListItem interface should be implemented in Enum class to be created.

5.14.2.4.1. Example of codelist settings ¶

Creating Enum class

In case of using EnumCodeList, create Enum class that implements EnumCodeList.CodeListItem interface. Example is shown below.

package com.example.domain.model;

import org.terasoluna.gfw.common.codelist.EnumCodeList;

public enum OrderStatus
    // (1)
    implements EnumCodeList.CodeListItem {

    // (2)
    RECEIVED  ("1", "Received"),
    SENT      ("2", "Sent"),
    CANCELLED ("3","Cancelled");

    // (3)
    private final String value;
    private final String label;

    // (4)
    private OrderStatus(String codeValue, String codeLabel) {
        this.value = codeValue;
        this.label = codeLabel;
    }

    // (5)
    @Override
    public String getCodeValue() {
        return value;
    }

    // (6)
    @Override
    public String getCodeLabel() {
        return label;
    }

}

Sr. No.	Description
(1)	In `Enum` class to be used as codelist, implement the `org.terasoluna.gfw.common.codelist.EnumCodeList.CodeListItem` interface provided by common library. In `EnumCodeList.CodeListItem` interface, following methods are defined to fetch the information (code values and labels) required for creating a codelist. `getCodeValue()` method to fetch code values `getCodeLabel()` method to fetch labels
(2)	Define constants. When creating constants, specify the information (code values and labels) required for creating a codelist. In above example, following 3 constants are defined. `RECEIVED` (code value=`"1"`, label=`"Received"`) `SENT` (code value=`"2"`, label=`"Sent"`) `CANCELLED` (code value=`"3"`, label=`"Cancelled"`) Note Sorting order of codelist when using `EnumCodeList` will be the order of defining constants.
(3)	Create a property to store the information (code values and labels) required for creating a codelist.
(4)	Create a constructor to receive the information (code values and labels) required for creating a codelist.
(5)	Return the code values storing constants. This method is defined in `EnumCodeList.CodeListItem` interface, and it is called when `EnumCodeList` fetches code value from a constant.
(6)	Return the label storing constants. This method is defined in `EnumCodeList.CodeListItem` interface, and it is called when `EnumCodeList` fetches label from a constant.

Definition of bean definition file (xxx-codelist.xml)

EnumCodeList is defined in bean definition file for codelist. Example of definition is shown below.

<bean id="CL_ORDERSTATUS"
      class="org.terasoluna.gfw.common.codelist.EnumCodeList"> <!-- (7) -->
    <constructor-arg value="com.example.domain.model.OrderStatus" /> <!-- (8) -->
</bean>

Sr. No.	Description
(7)	Specify `EnumCodeList` class as codelist implementation class.
(8)	Specify FQCN of `Enum` class that implements `EnumCodeList.CodeListItem` interface in constructor of `EnumCodeList` class.

5.14.2.4.2. Using codelist in JSP ¶

For details on how to use codelist in JSP, refer to Using codelist in JSP described earlier.

5.14.2.4.3. Using codelist in Java class ¶

For details on how to use codelist in Java class, refer to Using codelist in Java class described earlier.

5.14.2.5. How to use SimpleI18nCodeList ¶

org.terasoluna.gfw.common.codelist.i18n.SimpleI18nCodeList is a codelist supporting internationalization. By setting the codelist for each locale, the codelist corresponding to locale can be returned.

SimpleI18nCodeList image

5.14.2.5.1. Example of codelist settings ¶

It is easier to understand if you consider SimpleI18nCodeList as two dimensional table wherein row is Locale, column contains code values and cell details are labels.

The table would be as follows in case of a selectbox for selecting charges.

row=Locale,column=Code	0	10000	20000	30000	40000	50000
en	unlimited	Less than \10,000	Less than \20,000	Less than \30,000	Less than \40,000	Less than \50,000
ja	上限なし	10,000円以下	20,000円以下	30,000円以下	40,000円以下	50,000円以下

For creating a codelist table that supports internationalization, SimpleI18nCodeList has been set in following 3 ways.

Set CodeList for each locale by rows.
Set java.util.Map(key = code value, value = label) for each locale by rows.
Set java.util.Map(key = locale, value = label) for each code value by columns.

It is recommended that you set the codelist using “Set CodeList for each locale by rows.” method.

The way of setting the CodeList for each locale by rows considering the above example of selectbox for selecting charges, is mentioned below. For other setting methods, refer to Setting SimpleI18nCodeList.

Definition of Bean definition file (xxx-codelist.xml)

<bean id="CL_I18N_PRICE"
    class="org.terasoluna.gfw.common.codelist.i18n.SimpleI18nCodeList">
    <property name="rowsByCodeList"> <!-- (1) -->
        <util:map>
            <entry key="en" value-ref="CL_PRICE_EN" />
            <entry key="ja" value-ref="CL_PRICE_JA" />
        </util:map>
    </property>
</bean>

Sr. No.	Description
(1)	Set Map wherein key is `java.lang.Locale`, in rowsByCodeList properties. In Map, specify locale in key and a reference link to codelist class corresponding to locale in value-ref. For Map values, refer to codelist class corresponding to each locale.

Definition of Bean definition file(xxx-codelist.xml) when creating SimpleMapCodeList for each locale

<bean id="CL_I18N_PRICE"
    class="org.terasoluna.gfw.common.codelist.i18n.SimpleI18nCodeList">
    <property name="rowsByCodeList">
        <util:map>
            <entry key="en" value-ref="CL_PRICE_EN" />
            <entry key="ja" value-ref="CL_PRICE_JA" />
        </util:map>
    </property>
</bean>

<bean id="CL_PRICE_EN" class="org.terasoluna.gfw.common.codelist.SimpleMapCodeList">  <!-- (2) -->
    <property name="map">
        <util:map>
            <entry key="0" value="unlimited" />
            <entry key="10000" value="Less than \\10,000" />
            <entry key="20000" value="Less than \\20,000" />
            <entry key="30000" value="Less than \\30,000" />
            <entry key="40000" value="Less than \\40,000" />
            <entry key="50000" value="Less than \\50,000" />
        </util:map>
    </property>
</bean>

<bean id="CL_PRICE_JA" class="org.terasoluna.gfw.common.codelist.SimpleMapCodeList">  <!-- (3) -->
    <property name="map">
        <util:map>
            <entry key="0" value="上限なし" />
            <entry key="10000" value="10,000円以下" />
            <entry key="20000" value="20,000円以下" />
            <entry key="30000" value="30,000円以下" />
            <entry key="40000" value="40,000円以下" />
            <entry key="50000" value="50,000円以下" />
        </util:map>
    </property>
</bean>

Sr. No.	Description
(2)	For bean definition `CL_PRICE_EN` where locale is “en”, codelist class is set in `SimpleMapCodeList`.
(3)	For bean definition `CL_PRICE_JA` where locale is “ja”, codelist class is set in `SimpleMapCodeList`.

Definition of Bean definition file(xxx-codelist.xml) when creating JdbcCodeList for each locale

<bean id="CL_I18N_PRICE"
    class="org.terasoluna.gfw.common.codelist.i18n.SimpleI18nCodeList">
    <property name="rowsByCodeList">
        <util:map>
            <entry key="en" value-ref="CL_PRICE_EN" />
            <entry key="ja" value-ref="CL_PRICE_JA" />
        </util:map>
    </property>
</bean>

<bean id="CL_PRICE_EN" class="org.terasoluna.gfw.common.codelist.JdbcCodeList">  <!-- (4) -->
    <property name="dataSource" ref="dataSource" />
    <property name="querySql"
        value="SELECT code, label FROM price WHERE locale = 'en' ORDER BY code" />
    <property name="valueColumn" value="code" />
    <property name="labelColumn" value="label" />
</bean>

<bean id="CL_PRICE_JA" class="org.terasoluna.gfw.common.codelist.JdbcCodeList">  <!-- (5) -->
    <property name="dataSource" ref="dataSource" />
    <property name="querySql"
        value="SELECT code, label FROM price WHERE locale = 'ja' ORDER BY code" />
    <property name="valueColumn" value="code" />
    <property name="labelColumn" value="label" />
</bean>

Sr. No.	Description
(4)	For bean definition `CL_PRICE_EN` where locale is “en”, codelist class is set in `JdbcCodeList`.
(5)	For bean definition `CL_PRICE_JA` where locale is “ja”, codelist class is set in `JdbcCodeList`.

Insert the following data in Table Definition (price table).

locale	code	label
en	0	unlimited
en	10000	Less than \10,000
en	20000	Less than \20,000
en	30000	Less than \30,000
en	40000	Less than \40,000
en	50000	Less than \50,000
ja	0	上限なし
ja	10000	10,000円以下
ja	20000	20,000円以下
ja	30000	30,000円以下
ja	40000	40,000円以下
ja	50000	50,000円以下

Warning

Currently SimpleI18nCodeList does not support reloadable functionality. It should be noted that even if JdbcCodeList (reloadable CodeList) referred by SimpleI18nCodeList is reloaded, it does not get reflected in SimpleI18nCodeList. In order to make it reloadable, it should be implemented independently. For implementation method, refer to Customizing the codelist independently.

5.14.2.5.2. Using codelist in JSP ¶

Description of basic settings is omitted since it is same as Using codelist in JSP described earlier.

Definition of Bean definition file(spring-mvc.xml)

<mvc:interceptors>
  <mvc:interceptor>
    <mvc:mapping path="/**" />
    <bean
      class="org.terasoluna.gfw.web.codelist.CodeListInterceptor">
      <property name="codeListIdPattern" value="CL_.+" />
      <property name="fallbackTo" value="en" />  <!-- (1) -->
    </bean>
  </mvc:interceptor>

  <!-- omitted -->

</mvc:interceptors>

Sr. No.	Description
(1)	When request locale is not defined in codelist, codelist is fetched using the locale set in fallbackTo property. When fallbackTo property is not set, default JVM locale is used as fallbackTo property. When codelist cannot be fetched even after using the locale set in fallbackTo property, WARN log is output and empty Map is returned.

Example of jsp implementation

<form:select path="basePrice" items="${CL_I18N_PRICE}" />

Output HTML lang=en

<select id="basePrice" name="basePrice">
  <option value="0">unlimited</option>
  <option value="1">Less than \\10,000</option>
  <option value="2">Less than \\20,000</option>
  <option value="3">Less than \\30,000</option>
  <option value="4">Less than \\40,000</option>
  <option value="5">Less than \\50,000</option>
</select>

Output HTML lang=ja

<select id="basePrice" name="basePrice">
  <option value="0">上限なし</option>
  <option value="1">10,000円以下</option>
  <option value="2">20,000円以下</option>
  <option value="3">30,000円以下</option>
  <option value="4">40,000円以下</option>
  <option value="5">50,000円以下</option>
</select>

Output screen lang=en

Output screen lang=ja

5.14.2.5.3. Using codelist in Java class ¶

Description of basic settings is omitted since it is same as Using codelist in Java class described earlier.

@RequestMapping("orders")
@Controller
public class OrderController {

    @Inject
    @Named("CL_I18N_PRICE")
    I18nCodeList priceCodeList;

    // ...

    @RequestMapping(method = RequestMethod.POST, params = "confirm")
    public String confirm(OrderForm form, Locale locale) {
        // ...
        String priceMassage = getPriceMessage(form.getPriceCode(), locale);
        // ...
    }

    private String getPriceMessage(String targetPrice, Locale locale) {
         return priceCodeList.asMap(locale).get(targetPrice);  // (1)
    }

}

Sr. No.	Description
(1)	Map of locale corresponding to I18nCodeList#asMap(Locale) can be fetched.

5.14.2.6. Display code name corresponding to code value ¶

When it is necessary to refer the codelist in JSP, it can be referred same as java.util.Map interface.

For details, see the below example.

Example of jsp implementation

Order Status : ${f:h(CL_ORDERSTATUS[orderForm.orderStatus])}

Sr. No.	Description
(1)	Get a codelist that has been converted to the `java.util.Map` from the request scope (In this example, `"CL_ORDERSTATUS"` used as codelist ). The codelist has been referred with the beanID of codelist. Then specify a code value as a key of the `Map` interface which displays a corresponding code name (In this example, `orderStatus` value is used as a key).

5.14.2.7. Input validation of code value using codelist ¶

When checking whether the input value is the code value defined in codelist, org.terasoluna.gfw.common.codelist.ExistInCodeList annotation for BeanValidation is provided in common library.

For details on BeanValidation and message output method, refer to Input Validation.

For input validation using @ExistInCodeList annotation, it is necessary to carry out “Definition of error messages” for @ExistInCodeList .

When project is created by Blank project , the following message is defined in ValidationMessages.properties file directly under xxx-web/src/main/resources. Please change the message to fit the application requirements.

org.terasoluna.gfw.common.codelist.ExistInCodeList.message = Does not exist in {codeListId}

Note

In the terasoluna-gfw-common 5.0.0.RELEASE or later, the format of message property key has been changed to standard format of Bean Validation (FQCN of annotation + .message).

Version Property key of message

version 5.0.0.RELEASE or later

org.terasoluna.gfw.common.codelist.ExistInCodeList.message

version 1.0.x.RELEASE

org.terasoluna.gfw.common.codelist.ExistInCodeList

For migrating to the version 5.0.0.RELEASE or later from the version 1.0.x.RELEASE, when message is changed to fit the application requirements, the property key should be changed.

Note

From terasoluna-gfw-common 1.0.2.RELEASE, ValidationMessages.propertieswherein @ExistInCodeListmessage is defined, is not included in jar file. This is to fix the “Bug in which message is not displayed if multiple ValidationMessages.properties exist”.

For migrating to version 1.0.2.RELEASE or later from version 1.0.1.RELEASE or prior, if the message defined in ValidationMessages.propertiesincluded in jar of terasoluna-gfw-common, is used, it is necessary to define the message by creating ValidationMessages.properties.

5.14.2.7.1. Example of @ExistInCodeList settings ¶

See below the example of input validation method using codelist.

Definition of Bean definition file(xxx-codelist.xml)

<bean id="CL_GENDER" class="org.terasoluna.gfw.common.codelist.SimpleMapCodeList">
    <property name="map">
        <map>
            <entry key="M" value="Male" />
            <entry key="F" value="Female" />
        </map>
    </property>
</bean>

Form object

public class Person {
    @ExistInCodeList(codeListId = "CL_GENDER")  // (1)
    private String gender;

    // getter and setter omitted
}

Sr. No.	Description
(1)	Set `@ExistInCodeList` annotation for the field for which input is to be validated, and specify the target codelist in codeListId.

As a result of above settings, when characters other than M, F are stored in gender, the system throws an error.

Tip

@ExistInCodeList input validation supports only String or Character data types. Therefore, even if the fields with @ExistInCodeList may contain integer values, they should be defined as String data type. (such as Year/Month/Day)

5.14.3. How to extend ¶

5.14.3.1. When large number of records need to be read from JdbcCodeList ¶

When large number of records (in hundreds) need to be read from JdbcCodeList, Web application takes time to start.

This is because all records may be fetched at the same time during DB inquiry and it may take time to fetch the list from DB. (fetchSize may be set to Fetch All by default.)

This problem can be resolved by specifying appropriate value for fetchSize. In order to change the fetchSize, it is necessary to set the fetchSize of org.springframework.jdbc.core.JdbcTemplate.

See the example below.

Definition of Bean definition file(xxx-infra.xml)

<bean id="jdbcTemplateForCodeList" class="org.springframework.jdbc.core.JdbcTemplate" > <!-- (1) -->
    <property name="dataSource" ref="dataSource" />
    <property name="fetchSize" value="1000" /> <!-- (2) -->
</bean>

<bean id="AbstractJdbcCodeList"
    class="org.terasoluna.gfw.common.codelist.JdbcCodeList" abstract="true"> <!-- (3) -->
    <property name="jdbcTemplate" ref="jdbcTemplateForCodeList" /> <!-- (4) -->
</bean>

<bean id="CL_AUTHORITIES" parent="AbstractJdbcCodeList" ><!-- (5) -->
    <property name="querySql"
        value="SELECT authority_id, authority_name FROM authority ORDER BY authority_id" />
    <property name="valueColumn" value="authority_id" />
    <property name="labelColumn" value="authority_name" />
</bean>

Sr. No.	Description
(1)	Define a bean of `org.springframework.jdbc.core.JdbcTemplate` class. It is necessary for setting the fetchSize independently.
(2)	Set an appropriate value for the fetchSize.
(3)	Define a common bean of JdbcCodeList. Common parts of other JdbcCodeList are set. Therefore, for bean definition of basic JdbcCodeList, set this bean definition in parent class. This bean class cannot be instantiated by setting `abstract` attribute to true.
(4)	Set the jdbcTemplate referring to (1). JdbcTemplate for which fetchSize value is set is stored in JdbcCodeList.
(5)	Bean definition of JdbcCodeList By setting Bean defined in (3) as parent class in parent attribute, JdbcCodeList is set with fetchSize. In this bean definition, only the query related settings are carried out and the required CodeList is created.

5.14.3.2. When reloading the codelist ¶

Codelist provided in common library is read at the time of launching the application and it is never updated subsequently. However, in some cases, when the master data of the codelist is updated, the codelist also needs to be updated.

Example: Updating the codelist when DB master is updated using JdbcCodeList.

Common library provides org.terasoluna.gfw.common.codelist.ReloadableCodeList interface. The class implementing the above interface, implements refresh method. Codelist can be updated by calling this refresh method. JdbcCodeList implements ReloadableCodeList interface; hence it is possible to update the codelist.

Codelist can be updated in following two ways.

By using Task Scheduler
By calling refresh method in Controller (Service) class

This guideline recommends the method to reload the codelist periodically using Spring Task Scheduler.

However, when it is necessary to arbitrarily refresh the codelist, it is appropriate to call refresh method in Controller class.

Note

For the codelist having ReloadableCodeList interface, refer to List of codelist types.

5.14.3.2.1. Using Task Scheduler ¶

Example for setting the Task Scheduler is shown below.

Definition of Bean definition file(xxx-codelist.xml)

<task:scheduler id="taskScheduler" pool-size="10"/>  <!-- (1) -->

<task:scheduled-tasks scheduler="taskScheduler">  <!-- (2) -->
    <task:scheduled ref="CL_AUTHORITIES" method="refresh" cron="${cron.codelist.refreshTime}"/>  <!-- (3) -->
</task:scheduled-tasks>

<bean id="CL_AUTHORITIES" class="org.terasoluna.gfw.common.codelist.JdbcCodeList">
    <property name="dataSource" ref="dataSource" />
    <property name="querySql"
        value="SELECT authority_id, authority_name FROM authority ORDER BY authority_id" />
    <property name="valueColumn" value="authority_id" />
    <property name="labelColumn" value="authority_name" />
</bean>

Sr. No.	Description
(1)	Specify the thread pool size in pool-size attribute of `<task:scheduler>` element. When pool-size attribute is not specified, the value is set to “1”.
(2)	Define `<task:scheduled-tasks>` element and set `<task:scheduler>` ID in scheduler attribute.
(3)	Define `<task:scheduled>` element. Specify refresh method in method attribute. In cron attribute, the value should be mentioned in `org.springframework.scheduling.support.CronSequenceGenerator` supported format. Reload timing for cron attribute may change with development environment and commercial environment; hence it is recommended to fetch the codelist from property file or environment variable. Example of setting cron attribute Specify in “Seconds Minutes Hours Month Year Day”. execution every second “* * * * * ” execution every hour “0 0 * * ” execution every hour 9:00-17:00 on weekdays “0 0 9-17 * MON-FRI” For details, refer to JavaDoc. http://docs.spring.io/spring/docs/4.1.7.RELEASE/javadoc-api/org/springframework/scheduling/support/CronSequenceGenerator.html

5.14.3.2.2. Calling refresh method in Controller (Service) class ¶

See the example below for directly calling refresh method of JdbcCodeList in Service class.

Definition of Bean definition file(xxx-codelist.xml)

<bean id="CL_AUTHORITIES" class="org.terasoluna.gfw.common.codelist.JdbcCodeList">
    <property name="dataSource" ref="dataSource" />
    <property name="querySql"
        value="SELECT authority_id, authority_name FROM authority ORDER BY authority_id" />
    <property name="valueColumn" value="authority_id" />
    <property name="labelColumn" value="authority_name" />
</bean>

Controller class

@Controller
@RequestMapping(value = "codelist")
public class CodeListContoller {

    @Inject
    CodeListService codeListService; // (1)

    @RequestMapping(method = RequestMethod.GET, params = "refresh")
    public String refreshJdbcCodeList() {
        codeListService.refresh(); // (2)
        return "codelist/jdbcCodeList";
    }
}

Sr. No.	Description
(1)	Inject the Service class that executes refresh method of ReloadableCodeList class.
(2)	Execute the refresh method of Service class that executes refresh method of ReloadableCodeList class.

Service class

The description below is given only for the implementation class. Description for interface class has been omitted.

@Service
public class CodeListServiceImpl implements CodeListService { // (3)

    @Inject
    @Named(value = "CL_AUTHORITIES") // (4)
    ReloadableCodeList codeListItem; // (5)

    @Override
    public void refresh() { // (6)
        codeListItem.refresh(); // (7)
    }
}

Sr. No.	Description
(3)	Implement `CodeListService` interface for `CodeListServiceImpl` class.
(4)	Specify the corresponding codelist using `@Named` annotation at the time of injecting the codelist. ID of the bean to be fetched should be specified in `value` attribute. Codelist of ID attribute “CL_AUTHORITIES” of bean tag defined in Bean definition file is injected.
(5)	ReloadableCodeList interface should be defined in field type. ReloadableCodeList interface should be implemented for Bean specified in (4).
(6)	refresh method defined in Service class is called from Controller class.
(7)	refresh method of codelist wherein ReloadableCodeList interface is implemented. Codelist is updated by executing refresh method.

5.14.3.3. Customizing the codelist independently ¶

In order to create a codelist which does not fall under the 4 types provided by the common library, the existing codelist can be customized independently. Refer to the table below for the implementation method and type of codelist that can be created.

Sr. No.	Reloadable	Class to be inherited	Implementation location
(1)	Not required	`org.terasoluna.gfw.common.codelist.AbstractCodeList`	Override `asMap`
(2)	Required	`org.terasoluna.gfw.common.codelist.AbstractReloadableCodeList`	Override `retrieveMap`

The codelist can be customized by directly implementing org.terasoluna.gfw.common.codelist.CodeList and org.terasoluna.gfw.common.codelist.ReloadableCodeList interfaces; however extending the abstract class provided in common library minimizes the implementation efforts.

Actual example of independent customization is shown below. It illustrates a codelist for creating a list of current year and the next year. (Example: If current year is 2013, it is stored in codelist in the order of “2013, 2014”.)

Codelist class

@Component("CL_YEAR") // (1)
public class DepYearCodeList extends AbstractCodeList { // (2)

    @Inject
    JodaTimeDateFactory dateFactory; // (3)

    @Override
    public Map<String, String> asMap() {  // (4)
        DateTime dateTime = dateFactory.newDateTime();
        DateTime nextYearDateTime = dateTime.plusYears(1);

        Map<String, String> depYearMap = new LinkedHashMap<String, String>();

        String thisYear = dateTime.toString("Y");
        String nextYear = nextYearDateTime.toString("Y");
        depYearMap.put(thisYear, thisYear);
        depYearMap.put(nextYear, nextYear);

        return Collections.unmodifiableMap(depYearMap);
    }
}

Sr. No.	Description
(1)	Register the codelist as a component using `@Component` annotation. By specifying `"CL_YEAR"` in Value, register the codelist as a component using the codelist intercept set in bean definition.
(2)	Inherit `org.terasoluna.gfw.common.codelist.AbstractCodeList`. When creating the list of current year and next year, reloading is not necessary since it is created dynamically by calculating from system date.
(3)	`org.terasoluna.gfw.common.date.jodatime.JodaTimeDateFactory` creating the Date class of system date is injected. Current year and next year can be fetched using `JodaTimeDateFactory`. Class that implements `JodaTimeDateFactory` interface should be set in advance in bean definition file.
(4)	Override `asMap()` method and create the list of current year and next year. Implementation differs with every created codelist.

Example of jsp implementation

<form:select path="mostRecentYear" items="${CL_YEAR}" /> <!-- (5) -->

Sr. No.	Description
(5)	`"CL_YEAR"` registered as component in items attribute should be specified in `${}` placeholder to fetch the corresponding codelist.

Output HTML

<select id="mostRecentYear" name="mostRecentYear">
   <option value="2013">2013</option>
   <option value="2014">2014</option>
</select>

Output screen

Note

Implementation should be made thread-safe at the time of customizing the reloadable CodeList independently.

5.14.4. Appendix ¶

5.14.4.1. Setting SimpleI18nCodeList ¶

Apart from the settings mentioned in How to use SimpleI18nCodeList, SimpleI18nCodeList can be set in following 2 ways. The respective setting methods are explained using the example of selectbox for selecting charges.

5.14.4.1.1. Set `java.util.Map` (key = code value, value = label) for each locale by rows ¶

Definition of Bean definition file(xxx-codelist.xml)

<bean id="CL_I18N_PRICE"
    class="org.terasoluna.gfw.common.codelist.i18n.SimpleI18nCodeList">
    <property name="rows"> <!-- (1) -->
        <util:map>
            <entry key="en">
                <util:map>
                    <entry key="0" value="unlimited" />
                    <entry key="10000" value="Less than \\10,000" />
                    <entry key="20000" value="Less than \\20,000" />
                    <entry key="30000" value="Less than \\30,000" />
                    <entry key="40000" value="Less than \\40,000" />
                    <entry key="50000" value="Less than \\50,000" />
                </util:map>
            </entry>
            <entry key="ja">
                <util:map>
                    <entry key="0" value="unlimited" />
                    <entry key="10000" value="10,000円以下" />
                    <entry key="20000" value="20,000円以下" />
                    <entry key="30000" value="30,000円以下" />
                    <entry key="40000" value="40,000円以下" />
                    <entry key="50000" value="50,000円以下" />
                </util:map>
            </entry>
        </util:map>
    </property>
</bean>

Sr. No.	Description
(1)	Set “Map of Map” for rows property. External Map key is `java.lang.Locale`. Internal Map key is a code value and value is a label corresponding to locale.

5.14.4.1.2. Set `java.util.Map`(key = locale, value = label) for each code value by columns ¶

Definition of Bean definition file(xxx-codelist.xml)

<bean id="CL_I18N_PRICE"
    class="org.terasoluna.gfw.common.codelist.i18n.SimpleI18nCodeList">
    <property name="columns"> <!-- (1) -->
        <util:map>
            <entry key="0">
                <util:map>
                    <entry key="en" value="unlimited" />
                    <entry key="ja" value="上限なし" />
                </util:map>
            </entry>
            <entry key="10000">
                <util:map>
                    <entry key="en" value="Less than \\10,000" />
                    <entry key="ja" value="10,000円以下" />
                </util:map>
            </entry>
            <entry key="20000">
                <util:map>
                    <entry key="en" value="Less than \\20,000" />
                    <entry key="ja" value="20,000円以下" />
                </util:map>
            </entry>
            <entry key="30000">
                <util:map>
                    <entry key="en" value="Less than \\30,000" />
                    <entry key="ja" value="30,000円以下" />
                </util:map>
            </entry>
            <entry key="40000">
                <util:map>
                    <entry key="en" value="Less than \\40,000" />
                    <entry key="ja" value="40,000円以下" />
                </util:map>
            </entry>
            <entry key="50000">
                <util:map>
                    <entry key="en" value="Less than \\50,000" />
                    <entry key="ja" value="50,000円以下" />
                </util:map>
            </entry>
        </util:map>
    </property>
</bean>

Sr. No.	Description
(1)	Set “Map of Map” for columns property. External Map key is a code value. Internal Map key is `java.lang.Locale` and value is a label corresponding to locale.

5.14.4.2. Variations of NumberRangeCodeList ¶

5.14.4.2.1. Create the Descending NumberRangeCodeList ¶

Example of setting To value < From value is shown below.

Definition of Bean definition file(xxx-codelist.xml)

<bean id="CL_BIRTH_YEAR"
    class="org.terasoluna.gfw.common.codelist.NumberRangeCodeList">
    <property name="from" value="2013" /> <!-- (1) -->
    <property name="to" value="2000" /> <!-- (2) -->
</bean>

Sr. No.	Description
(1)	Specify the range start value. Specify a value greater than the one specified in “value” attribute of “to” property. As per this specification, display the values decreased in accordance with the interval in To-From range in descending order. Since interval is not set, default value 1 is applied.
(2)	Specify the range end value. In this example, since 2000 is specified as range end value; the value is reduced by 1 and stored in descending order from 2013 to 2000.

Example of jsp implementation

<form:select path="birthYear" items="${CL_BIRTH_YEAR}" />

Output HTML

<select id="birthYear" name="birthYear">
  <option value="2013">2013</option>
  <option value="2012">2012</option>
  <option value="2011">2011</option>
  <option value="2010">2010</option>
  <option value="2009">2009</option>
  <option value="2008">2008</option>
  <option value="2007">2007</option>
  <option value="2006">2006</option>
  <option value="2005">2005</option>
  <option value="2004">2004</option>
  <option value="2003">2003</option>
  <option value="2002">2002</option>
  <option value="2001">2001</option>
  <option value="2000">2000</option>
</select>

Output screen

5.14.4.2.2. Change interval of NumberRangeCodeList ¶

Example of setting interval value is shown below.

Definition of Bean definition file(xxx-codelist.xml)

<bean id="CL_BULK_ORDER_QUANTITY_UNIT"
    class="org.terasoluna.gfw.common.codelist.NumberRangeCodeList">
    <property name="from" value="10" />
    <property name="to" value="50" />
    <property name="interval" value="10" /> <!-- (1) -->
</bean>

Sr. No.	Description
(1)	Specify increment (decrement) value. Then, store the values obtained upon increasing (decreasing) the interval value within From-To range as codelist. In the above example, the values are stored in the order of `10`,`20`,`30`,`40`,`50` in the codelist.

Example of jsp implementation

<form:select path="quantity" items="${CL_BULK_ORDER_QUANTITY_UNIT}" />

Output HTML

<select id="quantity" name="quantity">
    <option value="10">10</option>
    <option value="20">20</option>
    <option value="30">30</option>
    <option value="40">40</option>
    <option value="50">50</option>
</select>

Output screen

Note

If From-To value exceeds the specified range, then the value increased (decreased) in accordance with interval is not stored in the codelist.

i.e. in case of following definition,

<bean id="CL_BULK_ORDER_QUANTITY_UNIT"
    class="org.terasoluna.gfw.common.codelist.NumberRangeCodeList">
    <property name="from" value="10" />
    <property name="to" value="55" />
    <property name="interval" value="10" />
</bean>

5 values of 10,20,30,40,50 are stored in the codelist. The value of subsequent interval 60 and the range threshold value 55 are not stored in the codelist.

Version	Property key of message
version 5.0.0.RELEASE or later	`org.terasoluna.gfw.common.codelist.ExistInCodeList.message`
version 1.0.x.RELEASE	`org.terasoluna.gfw.common.codelist.ExistInCodeList`