生成REF_CODE，, public s

生成REF_CODE，, public s

    public static void refCode() {        List<String> t = new ArrayList<String>();        t.add("Dummy");        t.add("Enrich");        t.add("GST Waiver");        t.add("Annual Fee Waiver");        t.add("DB Cash Back Waiver ");        t.add("General");        t.add("Fast Track");        t.add("Special");        String[] langs = { "00", "en", "zh" };        int id = 2960;        String CONS = "FAMCOURT";        int i = 1;        for (String a : t) {            for (String lang : langs) {                StringBuffer sb = new StringBuffer(                        "insert into lsr_ref_code (REFC_CODE_SEQ, REFC_ORG_NO, REFC_ORG_BRANCH_NO, REFC_BUSINESS_NO, REFC_PGM_COD, REFC_TYP_COD, REFC_LANG_COD, REFC_INFO_NUM, REFC_INFO_CHAR, REFC_INFO_LIB, REFC_CREATE_DTE, REFC_UPDATE_DTE, REFC_USR_CREATE, REFC_USR_UPDATE, REFC_BUSINESS_DATE, REFC_LIB_ALP1, REFC_LIB_ALP2, REFC_LIB_ALP3, REFC_NUM_NUM1, REFC_NUM_NUM2, REFC_NUM_NUM3, REFC_DTE_DTE1, REFC_DTE_DTE2, REFC_DTE_DTE3) values (");                sb.append(id++).append(", ");                sb.append("'GDB0100000', 'GDB01CA000', 'GDB01CAAP0', '000', ");                sb.append("'").append(CONS).append("', ");                sb.append("'").append(lang).append("', ");                sb.append(i).append(", ");                sb.append("null,");                sb.append("'").append(a).append("', ");                sb.append("to_date('24-03-2012', 'dd-mm-yyyy'), to_date('24-03-2012', 'dd-mm-yyyy'), 'weiming', 'weiming', '20120324', '', '', '', null, null, null, null, null, null);");                System.out.println(sb.toString());            }            i++;        }    }