循环读取数据库表数据，并且将结果集插入到sql文本中

package com.dqm.io;


import java.io.*;
import java.sql.*;


public class TestFile{
		
	
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		
		new b1().start();
	}

}

class b1 extends Thread {
	public void run(){
		try {
			String url = "jdbc:oracle:thin:@127.0.0.1:1521:tvds";
			String user = "tvdb";
			String password = "tvdb";
			Class.forName("oracle.jdbc.driver.OracleDriver");
			try {
				Connection conn = DriverManager.getConnection(url, user, password);
				PreparedStatement ps = conn.prepareStatement("select * from student");
				ResultSet rs = ps.executeQuery();
				File file = new File("D:\\student.sql");
				String strContent ="";
				FileWriter fw = new FileWriter(file);
				PrintWriter myFile = new PrintWriter(fw);  
				while(rs.next()){
					System.out.println(rs.getObject(1));
					strContent = strContent+"insert into student values ("+rs.getString("sno")+", '"+
					rs.getString("sname")+"', "+rs.getString("age")+", to_date('"+rs.getDate("ENROLLMENTDATE")+"', 'YYYY-MM-DD'));";
					strContent = strContent+"\r\n";
				}
					 
				myFile.println(strContent);   
				myFile.flush();
				myFile.close();   
					
						
				if(!file.exists())
					try {
						file.createNewFile();
					} catch (IOException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				rs.close();
				ps.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		} catch (ClassNotFoundException e2) {
			// TODO Auto-generated catch block
			e2.printStackTrace();
		}finally{
			
		}
		}
}