生成REF_CODE的代码

在内容期间，把开发过程中常用的一些内容记录起来，下面内容是关于生成REF_CODE的内容，希望对小伙伴有较大用途。
public static void refCode() {
List t = new ArrayList();
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, R