批量往mysql里面插入1000万条数据_[MyBatis]再次向MySql一张表插入一千万条数据 批量插入 用时5m24s...

packagecom.hy.action;importjava.io.Reader;importjava.text.SimpleDateFormat;importjava.util.ArrayList;importjava.util.Calendar;importjava.util.Date;importjava.util.List;importorg.apache.ibatis.io.Resources;importorg.apache.ibatis.session.SqlSession;importorg.apache.ibatis.session.SqlSessionFactory;importorg.apache.ibatis.session.SqlSessionFactoryBuilder;importorg.apache.log4j.Logger;importcom.hy.entity.Employee;importcom.hy.mapper.EmpMapper;public classBatchInsert1001 {private static Logger logger = Logger.getLogger(SelectById.class);public static void main(String[] args) throwsException{long startTime =System.currentTimeMillis();

Reader reader=Resources.getResourceAsReader("mybatis-config.xml");

SqlSessionFactory ssf=newSqlSessionFactoryBuilder().build(reader);

reader.close();

SqlSession session=ssf.openSession();try{

EmpMapper mapper=session.getMapper(EmpMapper.class);

String ctime="2017-11-01 00:00:01";int index=0;for(int i=0;i<10000;i++) {

List emps=new ArrayList();for(int j=0;j<1000;j++) {

index++;

Employee emp=new Employee("E"+String.valueOf(index),index % 100,ctime);

emps.add(emp);

ctime=timePastOneSecond(ctime);

}int changed=mapper.batchInsert(emps);

session.commit();

System.out.println("#"+i+" changed="+changed);

}

}catch(Exception ex) {

session.rollback();

logger.error(ex);

}finally{

session.close();long endTime =System.currentTimeMillis();

logger.info("Time elapsed:" + toDhmsStyle((endTime - startTime)/1000) + ".");

}

}public staticString timePastOneSecond(String otime) {try{

SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

Date dt=sdf.parse(otime);

Calendar newTime=Calendar.getInstance();

newTime.setTime(dt);

newTime.add(Calendar.SECOND,1);

Date dt1=newTime.getTime();

String retval=sdf.format(dt1);returnretval;

}catch(Exception ex) {

ex.printStackTrace();return null;

}

}//format seconds to day hour minute seconds style//Example 5000s will be formatted to 1h23m20s

public static String toDhmsStyle(longallSeconds) {

String DateTimes= null;long days = allSeconds / (60 * 60 * 24);long hours = (allSeconds % (60 * 60 * 24)) / (60 * 60);long minutes = (allSeconds % (60 * 60)) / 60;long seconds = allSeconds % 60;if (days > 0) {

DateTimes= days + "d" + hours + "h" + minutes + "m" + seconds + "s";

}else if (hours > 0) {

DateTimes= hours + "h" + minutes + "m" + seconds + "s";

}else if (minutes > 0) {

DateTimes= minutes + "m" + seconds + "s";

}else{

DateTimes= seconds + "s";

}returnDateTimes;

}

}