用opencsv做导出数据生成csv文件 有实例没？？？？

Question

有高手给个实例没

Answer 1

[code="java"]
驱动程序名

public void exportToCSV() throws Exception{
String driver = "com.mysql.jdbc.Driver";

// URL指向要访问的数据库名scutcs

String url = "jdbc:mysql://127.0.0.1:3306/scutcs";
// MySQL配置时的用户名
String user = "root";
// Java连接MySQL配置时的密码
String password = "root";

try {
// 加载驱动程序
Class.forName(driver);
// 连续数据库
Connection conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
// statement用来执行SQL语句
Statement stmt= conn.createStatement();
// 要执行的SQL语句
String sql = "select * from student";
ResultSet rs = stmt.executeQuery(sql);
CSVWriter writer = new CSVWriter(new FileWriter("yourfile.csv"), '\t');
String [] includeHeaders = {"col1","col2"};//表头
writer.writeAll(rs , includeHeaders);
writer.close();//关闭文件流
} finally {
release(rs,stmt,conn );
}
}

//关闭数据库连接
private void release(ResultSet rs,Statement stmt,Connection conn)
throws SQLException {
try {
if(rs!=null) {
rs.close();
}
} finally {
try {
if(stmt!=null){
stmt.close();
}
} finally {
if(con!=null) {
con.close();
}
}
}
}
[/code]