Connection conn = null;
PreparedStatement ps = null;
try {
// 1.注册驱动
Class.forName("com.mysql.jdbc.Driver");
// 2.获取连接
conn = DriverManager
.getConnection(
"jdbc:mysql://localhost:3306/库名?useUnicode=true&characterEncoding=UTF-8",
用户名,密码);
// 3.获取预编译的数据库操作对象
String sql = "sql语句";
ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
File file = new File("D:/tttt.csv");
if (!file.exists())
file.createNewFile();
CSVWriter writer = new CSVWriter(new FileWriter(file));
writer.writeNext(new String[]{"编号","名称","创建日期"});
writer.writeAll(rs, true);
} catch (Exception e) {
e.printStackTrace();
} finally {
// 5.释放资源
if (ps != null) {
try {
ps.close();
} catch (Exception e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
PreparedStatement ps = null;
try {
// 1.注册驱动
Class.forName("com.mysql.jdbc.Driver");
// 2.获取连接
conn = DriverManager
.getConnection(
"jdbc:mysql://localhost:3306/库名?useUnicode=true&characterEncoding=UTF-8",
用户名,密码);
// 3.获取预编译的数据库操作对象
String sql = "sql语句";
ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
File file = new File("D:/tttt.csv");
if (!file.exists())
file.createNewFile();
CSVWriter writer = new CSVWriter(new FileWriter(file));
writer.writeNext(new String[]{"编号","名称","创建日期"});
writer.writeAll(rs, true);
} catch (Exception e) {
e.printStackTrace();
} finally {
// 5.释放资源
if (ps != null) {
try {
ps.close();
} catch (Exception e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}