是不是想以二进制来保存数据啊!下面是用二进制来保存数据的代码: 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();
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();
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();