JAVA中CSV操作(导出和导入) .
转:http://blog.csdn.net/ititjt/article/details/1602760import?java.io.*;?
public?class?csvbean
...{
??public?static?void?main(String[]?args)
??...{
???try...{
??File?file?=?new?File("C:/name.csv");
??FileOutputStream?out?=?new?FileOutputStream(file);
??OutputStreamWriter?osw?=?new?OutputStreamWriter(out);
??BufferedWriter?bw?=?new?BufferedWriter(osw);
//insert?data?
??bw.write("aa");
??bw.write(",");
??bw.write("bb");
??bw.write(",");
??bw.write("cc");
??bw.write(" ")?;
??//close
???bw.close();
???osw.close();
???out.close();
???}
??catch(Exception?e)...{
???e.printStackTrace()?;
??}
??}
}
/**?*//**************************************************************************************/
//需要包:?csvjdbc-r0-10.zip?536.81K
import?java.sql.*;?
public?class?cvsbean
...{
??public?static?void?main(String[]?args)
??...{
????try
????...{
??????//?load?the?driver?into?memory
??????Class.forName("org.relique.jdbc.csv.CsvDriver");
??????//?create?a?connection.?The?first?command?line?parameter?is?assumed?to
??????//??be?the?directory?in?which?the?.csv?files?are?held
??????Connection?conn?=?DriverManager.getConnection("jdbc:relique:csv:d:/"?);//最后是文件路径
??????//?create?a?Statement?object?to?execute?the?query?with
??????Statement?stmt?=?conn.createStatement();
??????String?ssss="20060707171747";//20060707171747是文件名
??????//?Select?the?ID?and?NAME?columns?from?sample.csv
??????ResultSet?results?=?stmt.executeQuery("select?*?from?"+ssss);
??????//?dump?out?the?results
??????while?(results.next())
??????...{
????????System.out.println("hh=?"?+?results.getString(1)?+?"???jj=?"?+?results.getString(1));
??????}
??????//?clean?up
??????results.close();
??????stmt.close();
??????conn.close();
????}
????catch(Exception?e)
????...{
??????//System.out.println("Oops->?"?+?e);
?????//System.out.println(e.getMessage())?;
?????e.printStackTrace();
????}
??}
}