生成REF_CODE的代码

在内容期间，把开发过程中常用的一些内容记录起来，下面内容是关于生成REF_CODE的内容，希望对小伙伴有较大用途。 

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++;
		}
	}