62,614
社区成员
发帖
与我相关
我的任务
分享
FileOutputStream out = new FileOutputStream("user_UTF_8.txt");
ResultSet rs = connection.createStatement().executeQuery(
"select id, name, password from user");
ResultSetMetaData meta = rs.getMetaData();
int metaCount = meta.getColumnCount();
// 保存字段:
for (int i = 1; i < metaCount; i++) {
out.write((meta.getColumnName(i + 1) + "\t").getBytes("UTF-8"));
}
out.write(("\n").getBytes("UTF-8"));
// 保存数据:
while (rs.next()) {
out.write((rs.getString("id") + "\t").getBytes("UTF-8"));
out.write((rs.getString("name") + "\t").getBytes("UTF-8"));
out.write((rs.getString("password") + "\n").getBytes("UTF-8"));
}
out.close();
FileOutputStream out = new FileOutputStream("user_UTF_8.txt");
ResultSet rs = connection.createStatement().executeQuery("select id, name, password from user" );
ResultSetMetaData meta = rs.getMetaData();
int metaCount = meta.getColumnCount();
for (int i = 1; i < metaCount; i++) {
out.write((meta.getColumnName(i + 1)+"\t").getBytes("UTF-8"));
}
out.write(("\n").getBytes("UTF-8"));
while (rs.next()) {
out.write((rs.getString("id") + "\t").getBytes("UTF-8"));
out.write((rs.getString("name") + "\t").getBytes("UTF-8"));
out.write((rs.getString("name") + "\n").getBytes("UTF-8"));
}
out.close();