package com;
import com.DBhelper;
import com.PartyEntity;
import com.PartyService;
import com.Logger;
import java.util.List;
public class TestExcelToDb2 {
public static void main(String[] args){
// List listExcel=PartyService.getAllByExcel(“C:\wz//Testing File 1 - Copy.xls”);
List listExcel=PartyService.readAllByExcel(“C:\wz//Testing File 1 - Copy.xls”);
// System.out.println(“C:\wz//Testing File 1.xls”);
DBhelper db=new DBhelper();
System.out.println(“调用数据库连接”);
int a = 0;
int b = 0;
int c =listExcel.size();
System.out.println(“size:”+c);
// Logger.Log(" Testing File 1.xls count:"+c);
for (PartyEntity partyEntity : listExcel) {
String PARTY_KEY=partyEntity.getPARTY_KEY();
System.out.println(PARTY_KEY);
//不存在就插入
if (!PartyService.isExist(PARTY_KEY)) {
//System.out.println(“不存在插入”);
//Pre_Party_T
//PRE_SCREENING_YPART
String sql = “insert into Pre_Party_T” +
“(PARTY_KEY, PARTY_TYPE, PARTY_GIVEN_NAME, PARTY_SURNAME,PARTY_DOB,PARTY_COUNTRY,PARTY_GENDER,PARTY_ID_NO,ORGANIZATION_UNIT,Business_Unit) " +
“values(?,?,?,?,?,?,?,?,?,?)”;
String[] str=new String[]{String.valueOf(partyEntity.getPARTY_KEY()),partyEntity.getPARTY_TYPE(),partyEntity.getPARTY_GIVEN_NAME(),partyEntity.getPARTY_SURNAME(), String.valueOf(partyEntity.getPARTY_DOB())
,partyEntity.getPARTY_COUNTRY(),partyEntity.getPARTY_GENDER(),partyEntity.getPARTY_ID_NO(),partyEntity.getORGANIZATION_UNIT(),partyEntity.getBusiness_Unit()+”"};
int exestatus = db.AddU(sql, str);
a = a + 1;
if(String.valueOf(exestatus).equals(“0”)){
System.out.println(“Failed to execute record:”+(a+b+1));
Logger.Log(“Failed to execute record:”+(a+b+1));
System.exit(1);
}
}
}
}
}