初めてのプロジェクトはバッチ処理です、ＣＳＶファイルのデータをＤＢに書き込みします、ＤＢのデータをＣＳＶファイルに書き込みします。学到的一个重要东西是DAOGenerator,这是IBM自己的一个插件，对DAO的操作非常方便，最终能产生两种类型的数据集，List或Map型数据集。这样对数据库的操作就很容易。这次的项目最复杂的是把多个CSV文件中的数据写入一个表中。
import java.util.ArrayList;import java.util.Iterator;import java.util.List;import java.util.Map;
/* * 作成日: 2006/12/13 * * * ウィンドウ - 設定 - Java - コード・スタイル - コード・テンプレート */
/** * @author bsolZhang * * * ウィンドウ - 設定 - Java - コード・スタイル - コード・テンプレート */public class Test {
/** * <code>NUM_SRJKN_FRM_TXNKG</code> のコメント */ private static final int NUM_SRJKN_FRM_TXNKG = 0; /** * <code>NUM_SRJKN_TO_TXNKG</code> のコメント */ private static final int NUM_SRJKN_TO_TXNKG = 1; /** * <code>NUM_SRY</code> のコメント */ private static final int NUM_SRY = 2; /** * <code>TM2030Map</code> のコメント */ private static final TestBean TM2030Map = null;
/** * @param args */ public static void main(String[] args){ int lCnt = 0; int count = 0; int flag = 0; int lErrCntWrk = 0; String[][] iiSry = new String[5][3]; String strKtrhcd = ""; String strDokbn = ""; TestBean tempMap = null; TestBean testBean1 = new TestBean("13","u","1","1","1"); TestBean testBean2 = new TestBean("13","u","2","2","2"); TestBean testBean3 = new TestBean("13","u","3","3","3"); TestBean testBean4 = new TestBean("14","u","4","4","4"); TestBean testBean5 = new TestBean("13","u","5","5","5"); TestBean testBean6 = new TestBean("13","u","6","6","6"); TestBean testBean7 = new TestBean("13","u","7","7","7"); TestBean testBean11 = new TestBean("13","u","11","11","11"); TestBean testBean12 = new TestBean("13","u","12","12","12"); TestBean testBean13 = new TestBean("13","u","13","13","13"); TestBean testBean14 = new TestBean("13","u","14","14","14"); TestBean testBean15 = new TestBean("13","u","15","15","15"); TestBean testBean16 = new TestBean("12","u","16","16","16"); TestBean testBean17 = new TestBean("13","u","17","17","17"); List beforelist = new ArrayList(); beforelist.add(testBean1); beforelist.add(testBean2); beforelist.add(testBean3); beforelist.add(testBean4); beforelist.add(testBean5); beforelist.add(testBean6); beforelist.add(testBean7); beforelist.add(testBean11); beforelist.add(testBean12); beforelist.add(testBean13); beforelist.add(testBean14); beforelist.add(testBean15); beforelist.add(testBean16); beforelist.add(testBean17); for (Iterator ite = beforelist.iterator(); ite.hasNext(); lCnt = lCnt + 1) { // データ取得 TestBean TM2030Map = (TestBean) ite.next(); //2.4.1. 前レコードとＰＫ、処理区分を比較 if ( lCnt == 0 || (strKtrhcd.equals(TM2030Map.getA()) && strDokbn.equals(TM2030Map.getB()))) { if(count == 5 || flag == 1){ lErrCntWrk = lErrCntWrk + 1; System.out.println("エラー件数：" + lErrCntWrk); flag = 1; continue; } //---------------------------------------------------------- //② 送料セット //---------------------------------------------------------- // 送料条件FROM税抜金額 iiSry[count][NUM_SRJKN_FRM_TXNKG]=(String)TM2030Map.getC(); // 送料条件TO税抜金額 iiSry[count][NUM_SRJKN_TO_TXNKG]=(String)TM2030Map.getD(); // 送料S iiSry[count][NUM_SRY]=(String)TM2030Map.getE(); count = count + 1; }else{ if (flag == 0){ for (int i = count; i < 5; i++) { // 送料条件FROM税抜金額 iiSry[i][NUM_SRJKN_FRM_TXNKG]=","; // 送料条件TO税抜金額 iiSry[i][NUM_SRJKN_TO_TXNKG]=","; // 送料 iiSry[i][NUM_SRY]=","; } System.out.print((String) ((TestBean) tempMap).getA()); System.out.print((String) ((TestBean) tempMap).getB()); for (int i = 0; i < 5; i++) { // 送料条件FROM税抜金額 System.out.print(iiSry[i][NUM_SRJKN_FRM_TXNKG]); // 送料条件TO税抜金額 System.out.print(iiSry[i][NUM_SRJKN_TO_TXNKG]); // 送料 System.out.print(iiSry[i][NUM_SRY]); } System.out.println(); } // 送料条件FROM税抜金額 iiSry[0][NUM_SRJKN_FRM_TXNKG]=(String)TM2030Map.getC(); // 送料条件TO税抜金額 iiSry[0][NUM_SRJKN_TO_TXNKG]=(String)TM2030Map.getD(); // 送料S iiSry[0][NUM_SRY]=(String)TM2030Map.getE(); count = 1; flag = 0; } tempMap =(TestBean) TM2030Map; strKtrhcd = (String) ((TestBean) tempMap).getA(); strDokbn = (String) ((TestBean) tempMap).getB();
} if (flag == 0){ for (int i = count; i < 5; i++) { // 送料条件FROM税抜金額 iiSry[i][NUM_SRJKN_FRM_TXNKG]=","; // 送料条件TO税抜金額 iiSry[i][NUM_SRJKN_TO_TXNKG]=","; // 送料 iiSry[i][NUM_SRY]=","; } System.out.print((String) ((TestBean) tempMap).getA()); System.out.print((String) ((TestBean) tempMap).getB()); for (int i = 0; i < 5; i++) { // 送料条件FROM税抜金額 System.out.print(iiSry[i][NUM_SRJKN_FRM_TXNKG]); // 送料条件TO税抜金額 System.out.print(iiSry[i][NUM_SRJKN_TO_TXNKG]); // 送料 System.out.print(iiSry[i][NUM_SRY]); } System.out.println(); }}}
