albert's blog

2011/06/04

how to Set JavaBean DataSource in iReport

Setup Classpath

1. iReport --> Preferences

2. Click Classpath tab --> Click "Add Folder"

3. Choose class folder --> Click "Choose"

4. Check "Reloadable" checkbox --> Click OK

Create a new report template

1. File --> New

2. Choose "Blank A4" --> Click "Open This Template"

3. Assign report name and location, Click "Next"

4. Click Finish

5. Right Click -->Edit Query

6. Choose "JavaBean DataSource"-->Assign "class name"-->Click Read Attriutes

7. Choose "selected attributes" --> Click "add selected attributes"

8. Click OK

9. Unfold "Fields", then you can see the attributes we added before will show under Fields

10. Drag "Department" field into template. Then DONE.

2011/06/02

利用enumeration type來做下拉選單

我們在開發的時候，會遇到某些下拉選單不是從資料庫抓出來的，寫死在jsp好像不太恰當，寫在property file再抓出來又有點麻煩，如下圖所示，輸出格式、法務科別、下授類別等，下拉單內容很固定、又不需要放在資料庫：

這邊我建議用Java的enumeration type來建立下拉選單。步驟如下(以法務科別為例)：

1. 建立enumeration class (若下選選單有增減，只要修改enumeration即可）

   package gov.fdc.nig.enumeration;
   
   /**
    * 法務科別 enumeration
    *
    * @author albert
    *
    */
   public enum LegalSectionEnum {
   
       SECTION1("1.法務一科", "1"), SECTION2("2.法務二科", "2"), ALL("3.全部", "3");
   
       private final String label;
       private final String value;
   
       public String getLabel() {
           return label;
       }
   
       public String getValue() {
           return value;
       }
   
       private LegalSectionEnum(String label, String value) {
           this.label = label;
           this.value = value;
       }
   
       public static void main(String args[]) {
           LegalSectionEnum[] enumArr = LegalSectionEnum.values();
           for (LegalSectionEnum enumeration: enumArr) {
               System.out.println("label=" + enumeration.getLabel() + ", value=" +
                   enumeration.getValue());
           }
       }
   }

2. 在NIGUtilsConroller增加一個method來抓取enumeration中所定義的values

   /**
    * 取得法務科別下拉單
    * 
    * @param res loadDelegationUnitList
    * @param session HttpSession
    * @throws IOException if exception happens
    */
   @RequestMapping(value = "/loadLegalSectionList", method = RequestMethod.POST)
   public @ResponseBody
   void loadLegalSectionList(final HttpServletResponse res, final HttpSession session)
   throws IOException {
       final JSONArray jsonArray = new JSONArray();
   
       try {
           final LegalSectionEnum[] enumArr = LegalSectionEnum.values();
   
           for (LegalSectionEnum enumeration: enumArr) {
               Map map = new HashMap();
               map.put("value", enumeration.getValue());
               map.put("name", enumeration.getLabel());
   
               jsonArray.add(map);
           }
       } catch (FDCDataAccessException e) {
           LoggerFactory.getLogger(this.getClass()).debug(
               "loadExportFormatList exception: " + e.getMessage());
       }
   
       res.setContentType(NigAccessKey.JKEY_CONTENT_TYPE);
       res.getWriter().write(jsonArray.toString());
   }