从数据库的employee表(只需有名字,薪水,入职日期三列便可)中查出所有雇员信息,然后将所有记录存储到一个文本文件中(exployee.dat) 。Exployee.dat的格式如下:
总共有n个雇员的记录。
姓名 薪水 入职日期
1.张三 1000 2008-01-01
读取上面产生的数据文件中间部分的数据记录并写入到另一个文本文件中(exployee_bak.data)中
总共有n个雇员的记录。
姓名 薪水 入职日期
1.张三 1000 2008-01-01
读取上面产生的数据文件中间部分的数据记录并写入到另一个文本文件中(exployee_bak.data)中
//上回给你回过一次,另一个帖上,代码如下,很粗糙,自己整理整理吧,细节方面的package A;import java.io.BufferedWriter;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.io.RandomAccessFile;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class a { private static Connection conn = null; private static Statement s = null; private static RandomAccessFile inout = null; private static BufferedWriter out = null;
static {
try {
conn = DriverManager.getConnection("");
} catch (SQLException e) {
e.printStackTrace();
}
} /**
* @param args
* @throws ClassNotFoundException
*/
public static void main(String[] args) {
writeData();
readData();
} private static void readData() {
try { out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream("D:\\exployee_bak.data")));
inout.seek(0);
String s = inout.readLine();
System.out.println(s);
out.write(s); } catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
try {
out.close();
inout.close();
} catch (IOException e) {
e.printStackTrace();
} }
} private static void writeData() {
try {
s = conn.createStatement();
ResultSet rs = s.executeQuery("select * from employee");
int count = 0;
while (rs.next()) {
count++;
String name = rs.getString(1);//名字:
double gongzi = rs.getDouble(2);//工资
String date = rs.getString(3);//日期
inout = new RandomAccessFile("D:\\exployee.dat", "rw");
inout.writeChars(count + ". " + name + " " + String.valueOf(gongzi) + " " + date);
}
} catch (SQLException e) {
e.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
try {
s.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
} } }
}