/**
 * Copyright (c) 2003-2004 System Integrator Corporation.
 *                 All Rights Reserved.
 */
package jp.co.sint.basic;

import java.sql.Connection;
import java.util.ArrayList;
import java.util.Collection;

import jp.co.sint.config.SIConfig;
import jp.co.sint.database.SIDBAccessException;
import jp.co.sint.database.SIDBUtil;
import jp.co.sint.tools.SIUtil;

import org.apache.log4j.Category;

/**
 * @version $Id: SIPrefecture.java,v 1.0 2004/02/16 Exp $
 * @author  Jinwang Chen
* <br>Description:
 * <p>History</p>
 * <p>Author&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Reason</p>
 *  ============&nbsp;&nbsp;&nbsp;==========&nbsp;&nbsp;===========================<br>
 * Jinwang Chen   2004/02/16 17:04:59  Original
 */
public class SIPrefecture extends SIBasic {
  //ログ用のインスタンスの生成
  private static Category log=Category.getInstance(SIConfig.SILOG4J_WEBSHOP_CATEGORY_NAME);

  private String prefectureCode="";

  private String prefectureName="";

  public SIPrefecture(){
  }

  public String getPrefectureCode(){
    return this.prefectureCode;
  }

  public String getPrefectureName(){
    return this.prefectureName;
  }

  /**
   * setPrefectureCode
   * @param lPrefectureCode
   */
  public void setPrefectureCode(String lPrefectureCode) {
    if (SIUtil.isNull(lPrefectureCode)) lPrefectureCode="";
    this.prefectureCode=SIUtil.changeTo(lPrefectureCode.trim(),this.encode);
  }

  /**
   * setPrefectureName
   * @param lPrefectureName
   */
  public void setPrefectureName(String lPrefectureName) {
    if (SIUtil.isNull(lPrefectureName)) lPrefectureName="";
    this.prefectureName=SIUtil.changeTo(lPrefectureName.trim(),this.encode);
  }

//7.2.0 ST1030 修正 ここまで
  public static Collection getNameCollection(Connection lConnection) {
    return getNameCollection(lConnection, true);
  }

  public static Collection getNameCollection(Connection lConnection, boolean addBlankFlg){
//7.2.0 ST1030 修正 ここまで
    StringBuffer lSqlBuf=new StringBuffer("SELECT PrefectureName,PrefectureName FROM PrefectureMTbl ORDER BY PrefectureCode");

    Collection lResultColl=new ArrayList();
    try {
      //7.2.0 ST1030 修正 ここから
      lResultColl=SIDBUtil.getCollection(lConnection, lSqlBuf.toString(), addBlankFlg);
      //lResultColl=SIDBUtil.getCollection(lConnection,lSqlBuf.toString(),true);
      //7.2.0 ST1030 修正 ここまで
    } catch (SIDBAccessException e) {
      e.printStackTrace();
    }

    return lResultColl;

  }
}