/**

     * 数据批量插入

     * @param poolName

     * @param humanList

     * @param sql

     * @return

     */

    public int executeInsertSQL(String poolName,List<HumanBo> humanList, String sql) {

        Connection conn = null;

        PreparedStatement prep = null;

        int ret = 0;

        try {

            conn = ConnectionPoolManager.getInstance().getConnection(poolName);

            prep = conn.prepareStatement(sql);

            for(HumanBo humanBo : humanList){

                prep.setString(1, humanBo.getId());

                prep.setString(2, humanBo.getName());

                prep.setString(3, humanBo.getIdNumber());

                byte[] imageUrl = Base64.decode(humanBo.getHumanPic());

                ByteArrayInputStream inputstr = new ByteArrayInputStream(imageUrl);

                prep.setBinaryStream(4, inputstr, imageUrl.length);

                prep.setString(5, humanBo.getFlag());

                prep.setString(6, humanBo.getType());

                prep.setDate(7, humanBo.getCreateTime());

                prep.addBatch();

            }

            int[] result = prep.executeBatch();

            ret = result.length;

        } catch (Exception e) {

            logger.error("执行数据库操作出错, SQL语句:" + sql, e);

        } finally {

            closeConn(poolName, conn, prep, null);

        }

        return ret;

    }