循环读取mysql数据库中数据_循环读取数据库表数据，并且将结果集插入到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{

}

}

}

分享到：

2013-03-12 00:22

浏览 884

评论