package com.inspur.rail;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
public class RailChinaSql {
public static void main(String[] args) {
try{
/*从D:\test.txt下读取数据,将结果输出到D:\test_result中。加“\”是防止转义 */
InputStream is=new FileInputStream("D:\\test.txt");
OutputStream os=new FileOutputStream("D:\\test_result.txt");
BufferedReader reader=new BufferedReader(new InputStreamReader(is));
BufferedWriter writer=new BufferedWriter(new OutputStreamWriter(os));
String str=null;
String[] arrs=null;
while((str=reader.readLine())!=null){
arrs=str.split(" ");
writer.write("update necur_scene_c set longitude="+arrs[0]+", latitude="+arrs[1]
+" "+"where oid='"+arrs[2]+"';"+"\r\n");
//System.out.println("update necur_scene_c set longitude="+arrs[0]+", latitude="+arrs[1]
// +" "+"where oid='"+arrs[2]+"';");
}
is.close();
os.close();
}catch(IOException e){
e.printStackTrace();
}
}
}
说明:源程序要实现的功能是:依次读取文件中的每行中用分号隔开的数据,将其加工成sql语句。