MailBackupSystem权益赠送管理工具

MailBackupSystem流程：

入口：web.xml     拦截所有jsp页面,跳转到/views/admin/login.jsp登陆
 ①新建工单：
（1）quanyi_list.js

function newOrder() {
    $('#dlg').dialog('open').dialog('setTitle', 'New User');
    $('#fm').form('clear');
    $('#up').form('clear');
    $('#fm-select').combobox('setValue', '+MAILMF');
    url = 'quanyi/insert.htmls';
}

（2）BatchDiffconfigController控制器

@Controller
@RequestMapping(value = "/quanyi")
public class BatchDiffconfigController {
@RequestMapping(value = "/insert")
@ResponseBody
public String insert(HttpServletRequest request, HttpServletResponse response, BatchDiffconfigPO batchDiffconfigPO) {
        int result = 0;
        try {
            result = batchDiffconfigService.insert(batchDiffconfigPO);
        } catch (DuplicateKeyException e) {
            return ResultTemplate.fail("已存在相同的工单代码");
        } catch (Exception e) {
            return ResultTemplate.fail("保存失败,请联系管理员");
        }
        if (result > 0) {
            return ResultTemplate.success();
        } else {
            return ResultTemplate.fail();
        }

    }
}

（3）业务代码

@Service
public class BatchDiffconfigServiceImpl implements BatchDiffconfigService {
    @Override
    public int insert(BatchDiffconfigPO batchDiffconfigPO) throws Exception {
        Long batchid = batchDiffconfigPOExtMapper.createPrimaryKey();
        batchDiffconfigPO.setBatchid(batchid);
        batchDiffconfigPO.setCreatetime(new Date());
        if (StringUtils.isEmpty(batchDiffconfigPO.getFileiuploadpath())) {
            batchDiffconfigPO.setProcessstatus(Constants.BATCH_ORDER_NEED_UPLOAD_FILE);
        } else {
            batchDiffconfigPO.setProcessstatus(Constants.BATCH_ORDER_READIY);
        }
        return batchDiffconfigPOMapper.insert(batchDiffconfigPO);

    }
}

（3）BatchDiffconfigPOMapper.xml对应查询sql

<insert id="insert" parameterType="com.richinfo.quanyi.model.BatchDiffconfigPO" >
    insert into BATCH_DIFFCONFIG (BATCHID, BATCHCODE, PROVCODE, 
      AREACODE, BEGINDATE, ENDDATE, 
      MEMO, FILEIUPLOADPATH, PROCESSSTATUS, 
      CREATENAME, MODIFYNAME, CREATETIME, 
      MODIFYTIME, SERVICECODE, UPLOADNUM, 
      STATUS, INCSUCCESS, INCFAILNUM, 
      REDUCESUCCESS, REDUCEFAILNUM)
    values (#{batchid,jdbcType=DECIMAL}, #{batchcode,jdbcType=VARCHAR}, #{provcode,jdbcType=DECIMAL}, 
      #{areacode,jdbcType=DECIMAL}, #{begindate,jdbcType=TIMESTAMP}, #{enddate,jdbcType=TIMESTAMP}, 
      #{memo,jdbcType=VARCHAR}, #{fileiuploadpath,jdbcType=VARCHAR}, #{processstatus,jdbcType=DECIMAL}, 
      #{createname,jdbcType=VARCHAR}, #{modifyname,jdbcType=VARCHAR}, #{createtime,jdbcType=TIMESTAMP}, 
      #{modifytime,jdbcType=TIMESTAMP}, #{servicecode,jdbcType=VARCHAR}, #{uploadnum,jdbcType=DECIMAL}, 
      #{status,jdbcType=DECIMAL}, #{incsuccess,jdbcType=DECIMAL}, #{incfailnum,jdbcType=DECIMAL}, 
      #{reducesuccess,jdbcType=DECIMAL}, #{reducefailnum,jdbcType=DECIMAL})
</insert>

（4）最终涉及的表BATCH_DIFFCONFIG

②执行工单：

（1）quanyi_list.js

function excuteOrder() {
    $('#excute-fm').form('submit', {
        url: 'quanyi/excute.htmls',
        onSubmit: function () {
                return $(this).form('validate');
            },
            success: function (result) {
                var result = eval('(' + result + ')');
                console.log(result);
                if (result.code == "S_OK") {
                    $('#excute-div').dialog('close'); // close the dialog
                    $('#dg').datagrid('reload');
                    $.messager.show({
                        title: 'Success',
                        msg: result.msg
                    });
                } else if(result.code =="S_TIMEOUT"){
                    redirectToLogin(result.msg);
                }else {
                    $.messager.show({
                        title: 'Error',
                        msg: result.msg
                    });
                }
            }
    });
}

（2）BatchDiffconfigController控制器

@Controller
@RequestMapping(value = "/quanyi")
public class BatchDiffconfigController {
    @RequestMapping(value = "/excute")
    @ResponseBody
    public String excute(HttpServletRequest request, HttpServletResponse response, UserDiffConfigPO userDiffConfigPO,
            @RequestParam("batchid") long batchid) {
        LOG.info(userDiffConfigPO.toString());
        return batchDiffconfigService.excute(userDiffConfigPO, batchid);
    }
}

（3）业务代码

@Service
public class BatchDiffconfigServiceImpl implements BatchDiffconfigService {
    @Override
    public String excute(UserDiffConfigPO userDiffConfigPO, long batchid) {
        BatchDiffconfigPO batchDiffconfigPO = findByPrimaryKey(batchid);
        if (batchDiffconfigPO == null) {
            return ResultTemplate.fail("工单不存在");
        }

        String uploadpath = batchDiffconfigPO.getFileiuploadpath();
        if (StringUtils.isEmpty(uploadpath)) {
            return ResultTemplate.fail("未上传文件.");
        }
        StringBuilder sb = new StringBuilder();
        String filePath = sb.append(Constants.FILE_UPLOAD_ROOT_PATH).append("/")
                .append(batchDiffconfigPO.getFileiuploadpath()).toString();
        File zipFile = new File(filePath);
        if (!zipFile.exists()) {
            LOG.error("[BatchDiffconfigServiceImpl] zipFile not exist. zipFileName:{}", filePath);
            return ResultTemplate.fail("上传文件不存在，请重新上传.");
        }

        String fullFilePath = Constants.FILE_UPLOAD_ROOT_PATH + "/" + batchDiffconfigPO.getFileiuploadpath();
        if (batchDiffconfigPO.getProcessstatus() != Constants.BATCH_ORDER_READIY
                && batchDiffconfigPO.getProcessstatus() != Constants.BATCH_ORDER_FAILED) {
            LOG.error("[BatchDiffconfigServiceImpl].excute fail .status error.status:{}",
                    batchDiffconfigPO.getProcessstatus());
            return ResultTemplate.fail("该状态下不能执行任务");
        }
        BatchDiffconfigPO newBatchDiffconfigPO = new BatchDiffconfigPO();
        newBatchDiffconfigPO.setBatchid(batchid);
        newBatchDiffconfigPO.setModifytime(new Date());
        newBatchDiffconfigPO.setProcessstatus(Constants.BATCH_ORDER_DEALING);
        int resultCode = batchDiffconfigPOMapper.updateByPrimaryKeySelective(newBatchDiffconfigPO);
        if (resultCode == 0) {
            LOG.error("[MailNotifyServiceImpl].excuteUpdateMailNotify update fail.batchid: {},batchcode :{}", batchid,
                    batchDiffconfigPO.getBatchcode());
            return ResultTemplate.fail("更新工单状态失败");
        }
        BatchDiffconfigOrderMainThread batchDiffconfigOrderMainThread = new BatchDiffconfigOrderMainThread(this,
                batchDiffconfigPO, userDiffConfigPO);
        Thread thread = new Thread(batchDiffconfigOrderMainThread);
        thread.setName("UpdateMailNotifyMainThread");
        thread.start();
        return ResultTemplate.success();

    }
}

（4）多线程处理

1、BatchDiffconfigOrderMainThread的run()方法执行

/*
 * 
 * @ClassName: BatchDiffconfigOrderMainThread
 * @Description: 任务工单主线程
 * @author JaceJiang
 * @date 2018-1-18 下午2:15:46
 */
public class BatchDiffconfigOrderMainThread implements Runnable {
    private static final Logger LOG = LoggerFactory.getLogger(BatchDiffconfigOrderMainThread.class);

    private BatchDiffconfigService batchDiffconfigService;
    private BatchDiffconfigPO batchDiffconfigPO;
    private UserDiffConfigPO userDiffConfigPO;

    public BatchDiffconfigOrderMainThread(BatchDiffconfigService batchDiffconfigService,
            BatchDiffconfigPO batchDiffconfigPO, UserDiffConfigPO userDiffConfigPO) {
        this.batchDiffconfigService = batchDiffconfigService;
        this.batchDiffconfigPO = batchDiffconfigPO;
        this.userDiffConfigPO = userDiffConfigPO;
    }

    @Override
    public void run() {
        ExecutorService executor = Executors.newFixedThreadPool(1);
        Callable<Boolean> batchDiffconfigOrderTask = new BatchDiffconfigOrderTask(batchDiffconfigService,
                batchDiffconfigPO, userDiffConfigPO);
        BatchDiffconfigOrderFutureTask ft = new BatchDiffconfigOrderFutureTask(batchDiffconfigOrderTask,
                batchDiffconfigService, batchDiffconfigPO);
        executor.submit(ft);
        executor.shutdown();
        LOG.info("[BatchDiffconfigOrderMainThread] run()");
    }
}

2、BatchDiffconfigOrderTask：处理工单主任务，消费和生产线程在此创建，最终等待结果并且更新相应记录

/*
 * 
 * @ClassName: BatchDiffconfigOrderTask
 * @Description: 处理工单主任务，消费和生产线程在此创建，最终等待结果并且更新相应记录
 * @author JaceJiang
 * @date 2018-1-18 下午2:17:02
 */
public class BatchDiffconfigOrderTask implements Callable<Boolean> {

    private static final Logger LOG = LoggerFactory.getLogger(BatchDiffconfigOrderTask.class);

    private static final int THREAD_NUMS = Integer.valueOf(SysConfig.getProperty("UPDATE_MAIL_NOTIFY_THREAD", "1"));

    private BatchDiffconfigService batchDiffconfigService;
    private BatchDiffconfigPO batchDiffconfigPO;
    private UserDiffConfigPO userDiffConfigPO;

    public BatchDiffconfigOrderTask(BatchDiffconfigService batchDiffconfigService, BatchDiffconfigPO batchDiffconfigPO,
            UserDiffConfigPO userDiffConfigPO) {
        this.batchDiffconfigService = batchDiffconfigService;
        this.batchDiffconfigPO = batchDiffconfigPO;
        this.userDiffConfigPO = userDiffConfigPO;
    }

    @Override
    public Boolean call() throws Exception {
        CountDownLatch countDownLatch = new CountDownLatch(THREAD_NUMS);
        BlockingQueue<String> taskQueues = new LinkedBlockingQueue<String>(1000);//阻塞队列
        AtomicInteger successCounter = new AtomicInteger(0);
        AtomicInteger failCounter = new AtomicInteger(0);
        StringBuffer sb = new StringBuffer();
        String fileUrl = batchDiffconfigPO.getFileiuploadpath();
        String filePath = sb.append(Constants.FILE_UPLOAD_ROOT_PATH).append("/").append(fileUrl).toString();

        long begin = System.currentTimeMillis();
        LOG.info("[BatchDiffconfigOrderTask] run batchid:{}.batchcode:{}.filePath:{}", batchDiffconfigPO.getBatchid(),
                batchDiffconfigPO.getBatchcode(), filePath);
        File zipFile = new File(filePath);
        if (!zipFile.exists()) {
            LOG.error("[BatchDiffconfigOrderTask] zipFile not exist. zipFileName:{}", filePath);
            return false;
        }

        LOG.info("[BatchDiffconfigOrderTask] UpdateMailNotifyConsumeThread open thread.");
        for (int i = 0; i < THREAD_NUMS; i++) {
            Thread thread = new Thread(new BatchDiffconfigOrderConsumeThread(taskQueues, successCounter, failCounter,
                    countDownLatch, userDiffConfigPO, batchDiffconfigService));//消费者
            thread.setName("BatchDiffconfigOrderTask " + i);
            thread.start();
        }

        LOG.info("[BatchDiffconfigOrderTask] UpdateMailNotifyProduceThread open thread.");
        Thread thread = new Thread(new BatchDiffconfigOrderProduceThread(taskQueues, filePath));
        thread.setName("UpdateMailNotifyProduceThread ");//生产者
        thread.start();
        try {
            countDownLatch.await(6, TimeUnit.HOURS);
        } catch (InterruptedException e1) {
            LOG.error("[BatchDiffconfigOrderTask]InterruptedException excuteUpdateTask open thread.");
            e1.printStackTrace();
        }
        LOG.info("[BatchDiffconfigOrderTask] excuteUpdateTask update BatchDiffconfigPO.");
        BatchDiffconfigPO newBatchDiffconfigPO = new BatchDiffconfigPO();
        newBatchDiffconfigPO.setBatchid(batchDiffconfigPO.getBatchid());
        newBatchDiffconfigPO.setModifytime(new Date());
        newBatchDiffconfigPO.setProcessstatus(Constants.BATCH_ORDER_FINISHED);
        newBatchDiffconfigPO.setIncsuccess(Long.valueOf(successCounter.get()));
        newBatchDiffconfigPO.setIncfailnum(Long.valueOf(failCounter.get()));
        newBatchDiffconfigPO.setUploadnum(newBatchDiffconfigPO.getIncfailnum() + newBatchDiffconfigPO.getIncsuccess());
        int resultCode = batchDiffconfigService.update(newBatchDiffconfigPO);
        LOG.info(
                "[BatchDiffconfigOrderTask] ======================================= excuteUpdateTask. batchid{},batchcode{}, Total cost {} s.",
                newBatchDiffconfigPO.getBatchid(), newBatchDiffconfigPO.getBatchcode(),
                (System.currentTimeMillis() - begin) * 0.001f);
        if (resultCode == 0) {
            LOG.error("[BatchDiffconfigOrderTask] updateByPrimaryKey fail.{}", newBatchDiffconfigPO);
            return false;
        }
        return true;
    }

}

3、消费者线程（读取队列中的号码请求ps，获取uin，存入数据库）

package com.richinfo.quanyi.thread;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import java.util.Map.Entry;
import java.util.concurrent.BlockingQueue;
import java.util.concurrent.CountDownLatch;
import java.util.concurrent.TimeUnit;
import java.util.concurrent.atomic.AtomicInteger;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.util.StringUtils;

import com.richinfo.common.PsfServer;
import com.richinfo.common.SysConfig;
import com.richinfo.pfsc.bean.GPFSBean.MsgType;
import com.richinfo.quanyi.model.UserDiffConfigPO;
import com.richinfo.quanyi.service.BatchDiffconfigService;

/*
 * 
 * @ClassName: BatchDiffconfigOrderConsumeThread
 * @Description: 消耗线程，读取队列中的号码请求ps，获取uin，存入数据库
 * @author JaceJiang
 * @date 2018-1-18 下午2:13:46
 */
public class BatchDiffconfigOrderConsumeThread implements Runnable {

    private static final Logger LOG = LoggerFactory.getLogger(BatchDiffconfigOrderConsumeThread.class);
    private BlockingQueue<String> taskQueues;
    private AtomicInteger successCounter;
    private AtomicInteger failCounter;
    private CountDownLatch countDownLatch;
    private UserDiffConfigPO userDiffConfigPO;
    private BatchDiffconfigService batchDiffconfigService;

    public BatchDiffconfigOrderConsumeThread(BlockingQueue<String> taskQueues, AtomicInteger successCounter,
            AtomicInteger failCounter, CountDownLatch countDownLatch, UserDiffConfigPO userDiffConfigPO,
            BatchDiffconfigService batchDiffconfigService) {
        this.taskQueues = taskQueues;
        this.successCounter = successCounter;
        this.failCounter = failCounter;
        this.countDownLatch = countDownLatch;
        this.userDiffConfigPO = userDiffConfigPO;
        this.batchDiffconfigService = batchDiffconfigService;
    }

    @Override
    public void run() {
        boolean tag = true;
        String usernumber = null;
        LOG.info("[BatchDiffconfigOrderConsumeThread]run() {} is running.", Thread.currentThread().getName());
        String url = SysConfig.getProperty("jdbc.url");
        String user = SysConfig.getProperty("jdbc.username");
        String password = SysConfig.getProperty("jdbc.password");
        Connection con = null;
        PreparedStatement pst = null;
        // ///////////
        String url2 = SysConfig.getProperty("hd.jdbc.url");
        String user2 = SysConfig.getProperty("hd.jdbc.username");
        String password2 = SysConfig.getProperty("hd.jdbc.password");
        Connection con2 = null;
        PreparedStatement pst2 = null;
        // ///////////

        java.sql.Date nowDate = new java.sql.Date(System.currentTimeMillis());
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            con = DriverManager.getConnection(url, user, password);
            con2 = DriverManager.getConnection(url2, user2, password2);
            // 关闭事务自动提交
            con.setAutoCommit(false);
            con2.setAutoCommit(false);
            String excuteSql = createDynSql(userDiffConfigPO);
            pst = con.prepareStatement(excuteSql);
            pst2 = con2.prepareStatement(excuteSql);
        } catch (ClassNotFoundException e1) {
            e1.printStackTrace();
            LOG.error("[BatchDiffconfigOrderConsumeThread]run()ClassNotFoundException.", e1);
            return;
        } catch (SQLException e1) {
            e1.printStackTrace();
            LOG.error("[BatchDiffconfigOrderConsumeThread]run()SQLException.", e1);
            return;
        }
        int counter = 0;
        int counter2 = 0;
        Map<String, String> cacheMaps = new HashMap<String, String>(512);
        Map<String, String> cacheMaps2 = new HashMap<String, String>(512);// 灰度
        while (tag) {
            try {
                usernumber = taskQueues.poll(10, TimeUnit.SECONDS);
            } catch (InterruptedException e) {
                e.printStackTrace();
                break;
            }
            if (usernumber == null) {
                LOG.info("[BatchDiffconfigOrderConsumeThread]run() {} is finish.", Thread.currentThread().getName());
                break;
            }
            if (usernumber.length() != 11) {
                LOG.info(Thread.currentThread().getName() + "wrong number" + usernumber);
                failCounter.incrementAndGet();
                LOG.error("[BatchDiffconfigOrderConsumeThread]run() number wrong.number:{}", usernumber);
            } else { // 调用远程接口
                String uin = PsfServer.reqPsServiceByMsgType(MsgType.MT_MAIL_NOTIFY_QUERY_VALUE, usernumber);
                if (StringUtils.isEmpty(uin)) {
                    LOG.error("[BatchDiffconfigOrderConsumeThread]run() uin null.usernumber:{}", usernumber);
                    failCounter.incrementAndGet();
                    continue;
                }

                String part = PsfServer.reqPsServiceByMsgType(MsgType.MT_GET_PARTID_VALUE, usernumber);
                LOG.info("[BatchDiffconfigOrderConsumeThread]run() part:{}.usernumber:{}", part, usernumber);
                if (StringUtils.isEmpty(part)) {
                    LOG.error("[BatchDiffconfigOrderConsumeThread]run() part null.usernumber:{}", usernumber);
                    failCounter.incrementAndGet();
                    continue;
                } else if ("1".equals(part)) {// 灰度分区
                    cacheMaps2.put(usernumber, uin);
                    boolean excuteOneByOneTag = false;
                    try {
                        pst2.setString(1, usernumber);
                        pst2.setLong(2, Long.valueOf(uin));
                        pst2.setDate(3, nowDate);
                        pst2.addBatch();
                        counter2++;
                        if (counter2 % 500 == 0) {
                            LOG.info("[BatchDiffconfigOrderConsumeThread]run() batch insert . now counter {}", counter2);
                            // 执行批量更新
                            try {
                                pst2.executeBatch();
                                // 语句执行完毕，提交本事务
                                con2.commit();
                            } catch (Exception e) {
                                e.printStackTrace();
                                LOG.error("[BatchDiffconfigOrderConsumeThread]run() executeBatch error.", e);
                                excuteOneByOneTag = true;
                            }
                            if (excuteOneByOneTag) {
                                excuteOneByOneGrey(cacheMaps2, pst2, con2, nowDate, successCounter, failCounter);
                            } else {
                                successCounter.addAndGet(counter2);
                                counter2 = 0;
                            }
                            excuteOneByOneTag = false;
                            cacheMaps2.clear();
                        }
                        /*
                         * if (StringUtils.isEmpty(uin) || "0".equals(uin)) {
                         * failCounter.incrementAndGet(); } else {
                         * successCounter.incrementAndGet(); }
                         */
                    } catch (SQLException e) {
                        cacheMaps2.clear();
                        e.printStackTrace();
                        LOG.error("[BatchDiffconfigOrderConsumeThread]run() batch insert . now counter {}", counter2, e);
                    }
                } else {// ("12".equals(part)) { 全网分区
                    cacheMaps.put(usernumber, uin);
                    boolean excuteOneByOneTag = false;
                    try {
                        pst.setString(1, usernumber);
                        pst.setLong(2, Long.valueOf(uin));
                        pst.setDate(3, nowDate);
                        pst.addBatch();
                        counter++;
                        if (counter % 500 == 0) {
                            LOG.info("[BatchDiffconfigOrderConsumeThread]run() batch insert . now counter {}", counter);
                            // 执行批量更新
                            try {
                                pst.executeBatch();
                                // 语句执行完毕，提交本事务
                                con.commit();
                            } catch (Exception e) {
                                e.printStackTrace();
                                LOG.error("[BatchDiffconfigOrderConsumeThread]run() executeBatch error.", e);
                                excuteOneByOneTag = true;
                            }
                            if (excuteOneByOneTag) {
                                excuteOneByOne(cacheMaps, pst, con, nowDate, successCounter, failCounter);
                            } else {
                                successCounter.addAndGet(counter);
                                counter = 0;
                            }
                            excuteOneByOneTag = false;
                            cacheMaps.clear();
                        }
                        /*
                         * if (StringUtils.isEmpty(uin) || "0".equals(uin)) {
                         * failCounter.incrementAndGet(); } else {
                         * successCounter.incrementAndGet(); }
                         */
                    } catch (SQLException e) {
                        cacheMaps.clear();
                        e.printStackTrace();
                        LOG.error("[BatchDiffconfigOrderConsumeThread]run() batch insert . now counter {}", counter, e);
                    }
                }
            }
            usernumber = null;
        }
//////////////////////
        if (counter > 0) {
            boolean excuteOneByOneTag = false;
            try {
                pst.executeBatch();
                con.commit();
            } catch (SQLException e) {
                e.printStackTrace();
                LOG.error("[BatchDiffconfigOrderConsumeThread]run() batch insert . now counter {}", counter, e);
                excuteOneByOneTag = true;
            }
            if (excuteOneByOneTag) {
                excuteOneByOne(cacheMaps, pst, con, nowDate, successCounter, failCounter);
            } else {
                successCounter.addAndGet(counter);
                counter = 0;
            }
        }
        if (counter2 > 0) {
            boolean excuteOneByOneTag = false;
            try {
                pst2.executeBatch();
                con2.commit();
            } catch (SQLException e) {
                e.printStackTrace();
                LOG.error("[BatchDiffconfigOrderConsumeThread]run() batch insert . now counter {}", counter2, e);
                excuteOneByOneTag = true;
            }
            if (excuteOneByOneTag) {
                excuteOneByOneGrey(cacheMaps2, pst2, con2, nowDate, successCounter, failCounter);
            } else {
                successCounter.addAndGet(counter2);
                counter2 = 0;
            }
        }
        try {
            pst.close();
            con.close();
            pst2.close();
            con2.close();
        } catch (SQLException e) {
            LOG.error("[BatchDiffconfigOrderConsumeThread]run() close error.", e);
        }
        cacheMaps.clear();
        cacheMaps2.clear();
        countDownLatch.countDown();
    }

    private String createDynSql(UserDiffConfigPO userDiffConfigPO) {
        StringBuilder sbFront = new StringBuilder();
        StringBuilder sbBehind = new StringBuilder();
        sbFront.append("insert into OS_USERDIFFCONFIG_INFO (SEQ,USERNUMBER,UIN,CREATETIME,");
        sbBehind.append("values (get_seq('SEQ_OS_USERDIFFCONFIG_INFO'),?,?,?,");
        if (userDiffConfigPO.getAttmailboxcapacity() != null) {
            sbFront.append("ATTMAILBOXCAPACITY,");
            sbBehind.append(userDiffConfigPO.getAttmailboxcapacity() + ",");
        }
        if (userDiffConfigPO.getMaxannexsize() != null) {
            sbFront.append("MAXANNEXSIZE,");
            sbBehind.append(userDiffConfigPO.getMaxannexsize() + ",");
        }
        if (userDiffConfigPO.getDiskcapacity() != null) {
            sbFront.append("DISKCAPACITY,");
            sbBehind.append(userDiffConfigPO.getDiskcapacity() + ",");
        }
        if (userDiffConfigPO.getStorecabinetcapacity() != null) {
            sbFront.append("STORECABINETCAPACITY,");
            sbBehind.append(userDiffConfigPO.getStorecabinetcapacity() + ",");
        }
        if (userDiffConfigPO.getDiskfilesize() != null) {
            sbFront.append("DISKFILESIZE,");
            sbBehind.append(userDiffConfigPO.getDiskfilesize() + ",");
        }
        if (userDiffConfigPO.getMailgsendlimit() != null) {
            sbFront.append("MAILGSENDLIMIT,");
            sbBehind.append(userDiffConfigPO.getMailgsendlimit() + ",");
        }
        if (userDiffConfigPO.getSmsgsendlimit() != null) {
            sbFront.append("SMSGSENDLIMIT,");
            sbBehind.append(userDiffConfigPO.getSmsgsendlimit() + ",");
        }
        if (userDiffConfigPO.getMmsgsendlimit() != null) {
            sbFront.append("MMSGSENDLIMIT,");
            sbBehind.append(userDiffConfigPO.getMmsgsendlimit() + ",");
        }
        if (userDiffConfigPO.getAddrstorenum() != null) {
            sbFront.append("ADDRSTORENUM,");
            sbBehind.append(userDiffConfigPO.getAddrstorenum() + ",");
        }
        if (userDiffConfigPO.getDisksharenum() != null) {
            sbFront.append("DISKSHARENUM,");
            sbBehind.append(userDiffConfigPO.getDisksharenum() + ",");
        }
        if (userDiffConfigPO.getTranscribetimelen() != null) {
            sbFront.append("TRANSCRIBETIMELEN,");
            sbBehind.append(userDiffConfigPO.getTranscribetimelen() + ",");
        }
        if (userDiffConfigPO.getFilesharenum() != null) {
            sbFront.append("FILESHARENUM,");
            sbBehind.append(userDiffConfigPO.getFilesharenum() + ",");
        }
        if (userDiffConfigPO.getIntegralmultiple() != null) {
            sbFront.append("INTEGRALMULTIPLE,");
            sbBehind.append(userDiffConfigPO.getIntegralmultiple() + ",");
        }
        if (userDiffConfigPO.getSmsnotifynum() != null) {
            sbFront.append("SMSNOTIFYNUM,");
            sbBehind.append(userDiffConfigPO.getSmsnotifynum() + ",");
        }
        if (userDiffConfigPO.getMmsnotifynum() != null) {
            sbFront.append("MMSNOTIFYNUM,");
            sbBehind.append(userDiffConfigPO.getMmsnotifynum() + ",");
        }
        if (userDiffConfigPO.getSmsmonthlimit() != null) {
            sbFront.append("SMSMONTHLIMIT,");
            sbBehind.append(userDiffConfigPO.getSmsmonthlimit() + ",");
        }
        if (userDiffConfigPO.getMmsdaylimit() != null) {
            sbFront.append("MMSDAYLIMIT,");
            sbBehind.append(userDiffConfigPO.getMmsdaylimit() + ",");
        }
        if (userDiffConfigPO.getMmsmonthlimit() != null) {
            sbFront.append("MMSMONTHLIMIT,");
            sbBehind.append(userDiffConfigPO.getMmsmonthlimit() + ",");
        }
        if (userDiffConfigPO.getMaildaylimit() != null) {
            sbFront.append("MAILDAYLIMIT,");
            sbBehind.append(userDiffConfigPO.getMaildaylimit() + ",");
        }
        if (userDiffConfigPO.getMailmonthlimit() != null) {
            sbFront.append("MAILMONTHLIMIT,");
            sbBehind.append(userDiffConfigPO.getMailmonthlimit() + ",");
        }
        if (userDiffConfigPO.getAliasnum() != null) {
            sbFront.append("ALIASNUM,");
            sbBehind.append(userDiffConfigPO.getAliasnum() + ",");
        }
        if (userDiffConfigPO.getAliaslen() != null) {
            sbFront.append("ALIASLEN,");
            sbBehind.append(userDiffConfigPO.getAliaslen() + ",");
        }
        if (!StringUtils.isEmpty(userDiffConfigPO.getVipdomain())) {
            sbFront.append("VIPDOMAIN,");
            sbBehind.append(userDiffConfigPO.getVipdomain() + ",");
        }
        if (!StringUtils.isEmpty(userDiffConfigPO.getVipidentity())) {
            sbFront.append("VIPIDENTITY,");
            sbBehind.append(userDiffConfigPO.getVipidentity() + ",");
        }
        if (!StringUtils.isEmpty(userDiffConfigPO.getCosid())) {
            sbFront.append("COSID,");
            sbBehind.append(userDiffConfigPO.getCosid() + ",");
        }
        if (!StringUtils.isEmpty(userDiffConfigPO.getMailgradeid())) {
            sbFront.append("MAILGRADEID,");
            sbBehind.append(userDiffConfigPO.getMailgradeid() + ",");
        }
        if (!StringUtils.isEmpty(userDiffConfigPO.getLetterpaperid())) {
            sbFront.append("LETTERPAPERID,");
            sbBehind.append(userDiffConfigPO.getLetterpaperid() + ",");
        }
        if (!StringUtils.isEmpty(userDiffConfigPO.getCongracardid())) {
            sbFront.append("CONGRACARDID,");
            sbBehind.append(userDiffConfigPO.getCongracardid() + ",");
        }
        if (!StringUtils.isEmpty(userDiffConfigPO.getPostcardid())) {
            sbFront.append("POSTCARDID,");
            sbBehind.append(userDiffConfigPO.getPostcardid() + ",");
        }
        if (!StringUtils.isEmpty(userDiffConfigPO.getDermaid())) {
            sbFront.append("DERMAID,");
            sbBehind.append(userDiffConfigPO.getDermaid() + ",");
        }
        if (!StringUtils.isEmpty(userDiffConfigPO.getRemark())) {
            sbFront.append("REMARK,");
            sbBehind.append(userDiffConfigPO.getRemark() + ",");
        }
        if (userDiffConfigPO.getFilesharesavedays() != null) {
            sbFront.append("FILESHARESAVEDAYS,");
            sbBehind.append(userDiffConfigPO.getFilesharesavedays() + ",");
        }
        if (userDiffConfigPO.getSmspresentnum() != null) {
            sbFront.append("SMSPRESENTNUM,");
            sbBehind.append(userDiffConfigPO.getSmspresentnum() + ",");
        }
        if (userDiffConfigPO.getMmspresentnum() != null) {
            sbFront.append("MMSPRESENTNUM,");
            sbBehind.append(userDiffConfigPO.getMmspresentnum() + ",");
        }
        if (userDiffConfigPO.getSmsdaylimit() != null) {
            sbFront.append("SMSDAYLIMIT,");
            sbBehind.append(userDiffConfigPO.getSmsdaylimit() + ",");
        }

        String front = sbFront.substring(0, sbFront.lastIndexOf(",")) + ")";
        String behind = sbBehind.substring(0, sbBehind.lastIndexOf(",")) + ")";
        return front + behind;
    }

    private void excuteOneByOne(Map<String, String> retryMaps, PreparedStatement pst, Connection con,
            java.sql.Date nowDate, AtomicInteger success, AtomicInteger fail) {
        if (retryMaps.size() == 0)
            return;
        for (Entry<String, String> entrys : retryMaps.entrySet()) {
            String userNumber = entrys.getKey();
            if (batchDiffconfigService.countByUsernumber(userNumber) > 0) {
                LOG.error("[BatchDiffconfigOrderConsumeThread]run() excuteOneByOne() userNumber exist.{}", userNumber);
                fail.incrementAndGet();
                continue;
            }
            try {
                pst.setString(1, entrys.getKey());
                pst.setLong(2, Long.valueOf(entrys.getValue()));
                pst.setDate(3, nowDate);
                pst.addBatch();
                pst.executeBatch();
                con.commit();
                success.incrementAndGet();
            } catch (SQLException e) {
                fail.incrementAndGet();
                LOG.error("[BatchDiffconfigOrderConsumeThread]run() excuteOneByOne() error.", e);
            }
        }
    }

    private void excuteOneByOneGrey(Map<String, String> retryMaps, PreparedStatement pst, Connection con,
            java.sql.Date nowDate, AtomicInteger success, AtomicInteger fail) {
        if (retryMaps.size() == 0)
            return;
        for (Entry<String, String> entrys : retryMaps.entrySet()) {
            String userNumber = entrys.getKey();
            if (batchDiffconfigService.countByUsernumberGrey(userNumber) > 0) {
                LOG.error("[BatchDiffconfigOrderConsumeThread]run() excuteOneByOne() userNumber exist.{}", userNumber);
                fail.incrementAndGet();
                continue;
            }
            try {
                pst.setString(1, entrys.getKey());
                pst.setLong(2, Long.valueOf(entrys.getValue()));
                pst.setDate(3, nowDate);
                pst.addBatch();
                pst.executeBatch();
                con.commit();
                success.incrementAndGet();
            } catch (SQLException e) {
                fail.incrementAndGet();
                LOG.error("[BatchDiffconfigOrderConsumeThread]run() excuteOneByOne() error.", e);
            }
        }
    }

    public static void main(String[] agrs) {
        String sql = "1,2,3,4,5,";
        String result = sql.substring(0, sql.lastIndexOf(","));
        System.out.println(result);
    }
}

4、生产者线程（读取压缩文件，将号码放进队列）

package com.richinfo.quanyi.thread;

import java.io.BufferedInputStream;
import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.concurrent.BlockingQueue;
import java.util.concurrent.TimeUnit;
import java.util.zip.ZipEntry;
import java.util.zip.ZipFile;
import java.util.zip.ZipInputStream;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

/*
 * 
 * @ClassName: BatchDiffconfigOrderProduceThread
 * @Description: 生产线程，读取压缩文件，将号码放进队列
 * @author JaceJiang
 * @date 2018-1-18 下午2:16:07
 */
public class BatchDiffconfigOrderProduceThread implements Runnable {

    private static final Logger LOG = LoggerFactory.getLogger(BatchDiffconfigOrderProduceThread.class);
    private BlockingQueue<String> taskQueues;
    private String fileUrl;

    public BatchDiffconfigOrderProduceThread(BlockingQueue<String> taskQueues, String fileUrl) {
        this.taskQueues = taskQueues;
        this.fileUrl = fileUrl;
    }

    @Override
    public void run() {
        LOG.info("[BatchDiffconfigOrderProduceThread] readZipFile.fileUrl :{} ", fileUrl);
        try {
            ZipFile zf = new ZipFile(fileUrl);
            InputStream in = new BufferedInputStream(new FileInputStream(fileUrl));
            ZipInputStream zin = new ZipInputStream(in);
            ZipEntry ze;
            while ((ze = zin.getNextEntry()) != null) {
                if (ze.isDirectory()) {
                    LOG.info("[BatchDiffconfigOrderProduceThread]  {} is directory.", ze.getName());
                } else {
                    System.err.println("file - " + ze.getName() + " : " + ze.getSize() + " bytes");
                    long size = ze.getSize();
                    if (size > 0) {
                        BufferedReader br = new BufferedReader(new InputStreamReader(zf.getInputStream(ze)));
                        String line = "";
                        boolean tags = true;
                        while (tags && (line = br.readLine()) != null) {
                            tags = taskQueues.offer(line, 10, TimeUnit.SECONDS);
                        }
                        br.close();
                    }
                }
            }
            zin.close();
            in.close();
            zf.close();
        } catch (Exception e) {
            e.printStackTrace();
            LOG.info("[BatchDiffconfigOrderProduceThread]  wrong. {}", e);
        }
    }
}

3、BatchDiffconfigOrderFutureTask：处理任务结束后，对处理结果进行下一步操作

/*
 * 
 * @ClassName: BatchDiffconfigOrderFutureTask
 * @Description: FutureTask,处理任务结束后，对处理结果进行下一步操作
 * @author JaceJiang
 * @date 2018-1-18 下午2:14:39
 */
public class BatchDiffconfigOrderFutureTask extends FutureTask<Boolean> {

    private static final Logger LOG = LoggerFactory.getLogger(BatchDiffconfigOrderFutureTask.class);
    private BatchDiffconfigPO batchDiffconfigPO;
    private BatchDiffconfigService batchDiffconfigService;

    public BatchDiffconfigOrderFutureTask(Callable<Boolean> callable, BatchDiffconfigService batchDiffconfigService,
            BatchDiffconfigPO batchDiffconfigPO) {
        super(callable);
        this.batchDiffconfigPO = batchDiffconfigPO;
        this.batchDiffconfigService = batchDiffconfigService;
    }

    @Override
    protected void done() {
        Boolean result = false;
        try {
            result = get(60, TimeUnit.SECONDS);
            Long batchid = batchDiffconfigPO.getBatchid();
            if (!result) {
                BatchDiffconfigPO newBatchDiffconfigPO = new BatchDiffconfigPO();
                newBatchDiffconfigPO.setModifytime(new Date());
                newBatchDiffconfigPO.setStatus(Constants.BATCH_ORDER_FAILED);
                newBatchDiffconfigPO.setBatchid(batchid);
                if (batchDiffconfigService.update(newBatchDiffconfigPO) == 0) {
                    LOG.error("[BatchDiffconfigOrderFutureTask] update fail.result:{},batchid:{}", result, batchid);
                }
            }
            LOG.info("[BatchDiffconfigOrderFutureTask] done.result:{},batchid:{}", result, batchid);
        } catch (TimeoutException | InterruptedException | ExecutionException e) {
            LOG.error("[BatchDiffconfigOrderFutureTask] error.{}", e);
            e.printStackTrace();
        }
    }
}