1000条数据写入到txt文件中,并且做了换行

1000条数据写入到txt文件中,并且做了换行

package test;
import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.IOException;
public class Writer {
    public static void main(String[] args) {
        String fileName = "F:/ewssql.txt";
        int task_id = 10000;
        String sql="";
        for (int i = 0; i < 5000; i++) {
            sql=" insert into ews_task " +
                       "( TASK_ID,EWS_ID,SERV_CODE_LIST,STATUS_CHANGE_TIME,TASK_PRIORITY,CREATE_TIME,FINISH_TIME, " +
                       " DEV_ID,USER_TYPE_ID,REALTIME_FLAG,SYNC_FLAG,TASK_STATUS,USER_OP_FLAG,ARCHIVE_TIME, " +
                       " TML_ID,ELAPSED_TIME,ACTION_OWN,SYNC_VSOP_STATUS )" +
                       " values ("+task_id+", 56800420985714, '050E', to_date('26-10-2012 12:00:00', 'dd-mm-yyyy hh24:mi:ss'), " +
                       " 65, to_date('26-10-2012 12:00:00', 'dd-mm-yyyy hh24:mi:ss'),to_date('26-10-2012 12:01:00', 'dd-mm-yyyy hh24:mi:ss'), " +
                       " 5512280, 51, 0, 0, 0, -1,to_date('26-10-2012 12:00:00', 'dd-mm-yyyy hh24:mi:ss'), 55101, 1092, 2,0 ); ";
                task_id=task_id+1;
                String   nextLine   =   System.getProperty( ";"); 
                System.out.println(sql+nextLine);
             Writer.appendMethodB(fileName, sql);
        }
    }

    public static void appendMethodB(String fileName, String content) {
        try {
            //打开一个写文件器,构造函数中的第二个参数true表示以追加形式写文件
            BufferedWriter writer = new BufferedWriter(new FileWriter("F:/ewssql.txt",true));
            writer.newLine();
            writer.write(content);
            writer.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

 

posted @ 2012-10-26 17:20  合肥房屋托管  阅读(2150)  评论(0编辑  收藏  举报