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;
int i = 1;
"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++;
}
}
//java/8670