java线程池例子

java线程池例子,多线程

场景描述:
在工作中一个秒杀的业务场景中,在后台系统秒杀活动管理中有一个名单录入功能,需要录入一个excel表格,当excel表格中数据达到三万时出现了sql的异常 ORA-01745;

批量插入数据的DAO代码:

int insertBatch(List<FsoActivityUserList> itemList);

批量插入数据的xml代码:

<insert id="insertBatch"  parameterType="java.util.List">      insert into FSO_ACTIVITY_USER_LIST (ID, PRODUCT_CODE, U_ID,  IS_WHITE_BLACK)      select <include refid="TABLE_SEQUENCE" />,A.* from(    <foreach collection="list" item="item" index="index" separator="union all" >      select           #{item.productCode},#{item.uId},#{item.isWhiteBlack}         from dual    </foreach>      ) A</insert> 

import java.util.ArrayList;import java.util.List;import java.util.Map;import org.apache.log4j.Logger;import cn.creditease.zeus.server.model.normandy.fso.FsoActivityUserList;import cn.creditease.zeus.server.service.normandy.ActivityUserListService;/** * 鐢ㄤ簬娣诲姞涓囨潯浠ヤ笂鐨別xcel鏁版嵁 * @author charlotte * */public class ActivityExcelDataSaveRunnable implements Runnable {    private static final Logger log = Logger            .getLogger(ActivityController.class);    private ActivityUserListService activityUserListService;    private List<FsoActivityUserList> excelDataList = new ArrayList<FsoActivityUserList>();//excel瑙ｆ瀽鍚庣殑鏁版嵁闆嗗悎    public ActivityExcelDataSaveRunnable(ActivityUserListService activityUserListService, List<FsoActivityUserList> excelDataList) {        this.activityUserListService = activityUserListService ;        this.excelDataList = excelDataList;    }        public void run() {                try {                Map<String, Object> addUserListBatchResult = activityUserListService.addUserListBatch(excelDataList);//鎵归噺鎻掑叆娲诲姩鍚嶅崟鏁版嵁                if ("1".equals(addUserListBatchResult.get("code"))) {//寮傚父澶勭悊                    log.info("ActivityController#addActivity()----[zeus erro]...");                    throw new Exception("zeus鎻掑叆鏁版嵁澶辫触,璇锋鏌eus鏃ュ織!");                }            } catch (Exception e) {                    e.printStackTrace();                }            }}

使用:

private static ExecutorService pool=Executors.newCachedThreadPool();private ActivityUserListService activityUserListService;public staitc void main(String[] args){List<FsoActivityUserList> saveList = new ArrayList<FsoActivityUserList>();ActivityExcelDataSaveRunnable run = new ActivityExcelDataSaveRunnable(activityUserListService,saveList);pool.execute(run);}