javacsv导出csv

来源:互联网 发布:惠众金融网络借贷 编辑:程序博客网 时间:2024/05/08 22:12

1、目录结构



2、准备jar包,javacsv.jar

3、csvTest.java类

package com.hhj.csv;import java.io.File;import java.io.FileOutputStream;import java.nio.charset.Charset;import java.util.ArrayList;import java.util.List;import com.csvreader.CsvWriter;public class CSVTest {public static void main(String[] args) throws Exception {File file = new File("F:/test.csv");CsvWriter wr = new CsvWriter(new FileOutputStream(file), ',',Charset.forName("GB18030"));List<User> list = new ArrayList<User>();User user = new User();user.setAccount("001");user.setName("123");user.setTel("11111");list.add(user);User user1 = new User();user1.setAccount("002");user1.setName("456");user1.setTel("22222");list.add(user1);User user2 = new User();user2.setAccount("003");user2.setName("66");user2.setTel("vvvv");list.add(user2);StringBuilder sbBuilder = new StringBuilder();for(int i=0;i<list.size();i++) {sbBuilder.append(list.get(i).getAccount()+",");sbBuilder.append(list.get(i).getName()+",");if (i == list.size()-1){sbBuilder.append(list.get(i).getTel());break;}sbBuilder.append(list.get(i).getTel()+"\n");}System.out.println(sbBuilder.toString());wr.writeComment(sbBuilder.toString());wr.close();}}

4、user类

package com.hhj.csv;public class User {private String account;private String name;private String tel;public String getAccount() {return account;}public void setAccount(String account) {this.account = account;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getTel() {return tel;}public void setTel(String tel) {this.tel = tel;}}

总结:javacsv体积较小,如果需要一些简单的数据的话可以使用这种方式,如果比较复杂的数据,不太建议使用。

0 0
原创粉丝点击