public static boolean bachInsertData(List<String> sqlList) {
        boolean bool = false;
        Connection conn = null;
        Statement stm = null;
        try {
            conn = MyDAO.getConnection();
            conn.setAutoCommit(false);
            stm = conn.createStatement();
            for (String sql : sqlList) {
                stm.addBatch(sql);
            }
            stm.executeBatch();
            conn.commit();
            bool = true;
        } catch (Exception e) {
            if(e instanceof BatchUpdateException){
                BatchUpdateException bException = (BatchUpdateException)e;
                int[] s = bException.getUpdateCounts();
                logger.info("更新失败数据:"+sqlList.get(s.length));
                if(s.length+1<sqlList.size()){                    
                    List<String> sList = sqlList.subList(s.length+1, sqlList.size());                    
                    bachInsertData(sList);
                }
            }else{
                e.printStackTrace();
                try {
                    if (stm != null)
                        stm.close();
                } catch (SQLException ex) {
                    ex.printStackTrace();
                }
                try {
                    conn.close();
                } catch (SQLException ex) {
                    ex.printStackTrace();
                }
            }            
        } finally {
            try {
                if (stm != null)
                    stm.close();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
            try {
                conn.close();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
        return bool;
    }