JavaCSV编写器失败，但数据就在那里

Question

我正在尝试将查询的输出写入CSV。字符串在那里（控制台输出显示“公司1、公司2、公司3”等——但创建的CSV是空的。

while (rs2.next()) { 
    out.write(rs2.getString("CompanyName") );
    System.out.println(rs2.getString("companyname"));
    out.newLine();
}
rs2.close();
fstream.flush();
fstream.close();

Answer 1

FileOutputStream os = new FileOutputStream(new File(getFilesDir(),"myfile.csv"));
            OutputStreamWriter osw = new OutputStreamWriter(os, "UTF-8");
            BufferedWriter bw = new BufferedWriter(osw);

while (rs2.next()) { 
    bw.write(rs2.getString("CompanyName"));
    System.out.println(rs2.getString("companyname"));
    bw.newLine();
}
rs2.close();
bw.close()
osw.close()
os.close()
bw.flush()
osw.flush()
os.flush()

也许，此代码适用于您：）