아래는 addbatch를 썻는데요..아래 구문을 실행하면 성공했다고 1을리턴하는데 테이블에 데이터가 들어가지는않고
엄청 느려집니다..이유가 먼지 도저히 모르겠어요.그럼 조언부탁드립니다.
public int[] inputhuman(String recom_no,String []check,String[] recommend_dt,String[] interview_dt,String[] work_start_dt,String[] remark,String proc_name){
int [] updateCounts =null;
java.sql.Statement stmt=null;
try{
con = dbcp.getConnection();
con.setAutoCommit(false);
stmt = con.createStatement();
StringTokenizer st,st1,st2;
for(int i=0; i<check.length; i++){
st= new StringTokenizer(recommend_dt[i],".");
String temp_dt="";
while(st.hasMoreElements()){
temp_dt+=st.nextToken();
}
st1= new StringTokenizer(interview_dt[i],".");
String temp_dt1="";
while(st1.hasMoreElements()){
temp_dt1+=st1.nextToken();
}
st2= new StringTokenizer(interview_dt[i],".");
String temp_dt2="";
while(st2.hasMoreElements()){
temp_dt2+=st2.nextToken();
}
String text="INSERT INTO m_recommend_human (recom_no,member_no, office_gb, recommend_dt, interview_dt,work_start_dt,remark,ins_member_no,ins_dt,upd_member_no,upd_dt) VALUES ('"+recom_no+"','"+check[i]+"','1','"+temp_dt+"','"+temp_dt1+"','"+temp_dt2 +"','"+remark[i]+"','"+proc_name+"',getdate(),'"+proc_name+"',getdate() )";
System.out.println("text : "+text); //시험삼아 찍어봄.
stmt.addBatch("INSERT INTO m_recommend_human (recom_no,member_no, office_gb, recommend_dt, interview_dt,work_start_dt,remark,ins_member_no,ins_dt,upd_member_no,upd_dt) VALUES ('"+recom_no+"','"+check[i]+"','1','"+temp_dt+"','"+temp_dt1+"','"+temp_dt2 +"','"+remark[i]+"','"+proc_name+"',getdate(),'"+proc_name+"',getdate() )");
}
updateCounts = stmt.executeBatch();
con.setAutoCommit(true);
for(int i=0; i<updateCounts.length; i++){
System.out.println("success : : "+updateCounts[i]);
}
System.out.println("updateCounts : "+updateCounts);
}catch(Exception e){
System.out.println(e);
}finally{
dbcp.freeConnection(con, pstmt, rs);
}
return updateCounts;
} |