将文件中的数据存入到数据库

    //测试ftp路径
    private final static String filenames = "F:\\";
   @Autowired
    JdbcTemplate jdbcTemplate;
/**
     * 将文件中的数据读取到数据库中
     *
     * @param filename
     * @throws Exception
     */
    public void AddUserToDatebase(String filename) throws Exception {
        File file = new File(filenames + filename);
        Charset charset = Charset.defaultCharset();
        BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(new FileInputStream(file), charset));
        //sql语句
        StringBuffer sqls = new StringBuffer("START TRANSACTION; ");
        //当前行数据
        String line = "";
        //标识每5000条提交一次数据
        int index = 0;
        //去掉文件后缀
        String splitstr = Splitstr(filename);
        //判断成功多少
        int index2 = 0;
        while ((line = bufferedReader.readLine()) != null) {
            //判断是否乱码  true 为正常
            if (IsGarbled(line)) {
                sqls.append("INSERT INTO  dmp_mp_" + splitstr + "  (`account`) VALUES ('" + line.trim() + "');");
                index++;
                if (index == 5000) {
                    index2 += 5000;
                    index = 0;
                    sqls.append("COMMIT;");
                    jdbcTemplate.execute(sqls.toString());
                    sqls = new StringBuffer("START TRANSACTION; ");
                }
            }

        }
        if (index > 0 && index < 5000) {
            sqls.append("COMMIT;");
            index2 += index;
            jdbcTemplate.execute(sqls.toString());
        }

        bufferedReader.close();

    }