我能够将mysql导出到csv文件,但我没有获取表头,我希望头文件在我的文件保存到我的系统时显示。
这是我正在使用的java代码:
import java.io.*;
import java.sql.*;
public class ExportData {
public static void main(String args[]) {
String Driver;
Statement stmt;
Driver = "com.mysql.jdbc.Driver";
Connection con = null;
try {
Class.forName(Driver);
con = DriverManager.getConnection(
"jdbc:mysql://localhost/emp", "root", "");
if (!con.isClosed()) {
System.out.println("Successfully connected to MySQL DataBase \n");
stmt = con.createStatement();
String filename = "C:/2.txt";
String tablename = "employees";
String sql;
stmt.executeUpdate("SELECT * INTO OUTFILE \""
+ filename + "\" FROM " + tablename);
}
} catch (Exception e) {
System.err.println("Exception: " + e.getMessage());
} finally {
try {
if (con != null) {
con.close();
}
} catch (SQLException e) {
}
}
}
}