java读取csv乱码解决及java读取csv全部代码＜搬代码＞

最新推荐文章于 2024-06-28 11:23:25 发布

原创最新推荐文章于 2024-06-28 11:23:25 发布 · 2k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#java #servlet #jvm

该代码段展示了如何使用Java的BufferedReader和InputStreamReader处理GBK编码的CSV文件。通过指定GBK编码，能正确读取非UTF-8格式的乱码内容，逐行解析文件并分配给相应变量进行处理。

1.首先看乱码结果和代码
因为没有GBK，如何加入GBK如下

BufferedReader reader = new BufferedReader(new FileReader(file));

查看结果：

2.加入GBK

BufferedReader reader = new BufferedReader(new InputStreamReader(new FileInputStream(file),"GBK"));

查看结果：

读入csv全部代码：

	@Test
    public  void kaihucsv() throws IOException, InterruptedException {
		//地址
        File file = new File("src/main/java/com/znzdh/until/kaihucsv.csv");
		//BufferedReader读取
        BufferedReader reader = new BufferedReader(new InputStreamReader(new FileInputStream(file),"GBK"));
        //创建一个空的一行准备接收
        String line ="";
		//创建接收字段
        String dalishang=null;
        String shoujihao=null;
        String yaoqingma=null;
        String jigoumingcheng=null;
        String yingyezhizhao=null;
        String youxiang=null;
        String lianxidianhua=null;
        String lianxidizhi=null;
        String xingming=null;
        String shenfenzhenghao=null;
        String shenfendizhi=null;
        String qianfajiguan=null;
        String timestart=null;
        String timeout=null;
        String yinhangkahao=null;
        String jiesuanyinhang=null;
        String zhihang=null;
        String yuliushoujihao=null;
        String yuliushenfenzheng=null;
        String huming=null;
		//接收循环遍历
        while ((line=reader.readLine()) != null){
            String[] split = line.split(",");
            System.out.println(split[0]);
            dalishang=split[0];
            shoujihao=split[1];
            yaoqingma=split[2];
            jigoumingcheng=split[3];
            yingyezhizhao=split[4];
            youxiang=split[5];
            lianxidianhua=split[6];
            lianxidizhi=split[7];
            xingming=split[8];
            shenfenzhenghao=split[9];
            shenfendizhi=split[10];
            qianfajiguan=split[11];
            timestart=split[12];
            timeout=split[13];
            yinhangkahao=split[14];
            jiesuanyinhang=split[15];
            zhihang=split[16];
            yuliushoujihao=split[17];
            yuliushenfenzheng=split[18]
            huming=split[19];
            //输出
            System.out.println(dalishang+","+shoujihao+","+yaoqingma+","+
                    jigoumingcheng+","+yingyezhizhao+","+youxiang+","+lianxidianhua+","+lianxidizhi+","+
                    xingming+","+shenfenzhenghao+","+shenfendizhi+","+ qianfajiguan+","+
                    timestart+","+timeout+","+ yinhangkahao+","+jiesuanyinhang+","+
                    zhihang+","+yuliushoujihao+","+yuliushenfenzheng+","+huming);
			
    }