java实现将资源文件转化成sql语句导入数据库

文档结构

注意事项：导入文档字符格式需转化成utf—8格式再进行导出，否则导出数据中文显示乱码。

java代码

package test;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.InputStream;
import java.io.OutputStreamWriter;
public class InsertTest {
    public static void main(String[] args) throws Exception{
        FileOutputStream writerStream = new FileOutputStream("result.txt");//sql语句写入数据文件
        BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(
                               writerStream, "UTF-8")); 
        String[] fileArr = new String[]{"games.txt","nickLib.txt"};//读取资源数据文件
        BufferedReader reader = null;
        for(int k = 0;k <fileArr.length;k++){
            File file = new File(fileArr[k]);
            FileReader re = new FileReader(file); 
            reader = new BufferedReader(re);
            String str = null;
            while((str = reader.readLine())!=null){
                String[] arr = str.split("//");
                if(!arr[0].equals("")){
                    String type = null;
                    for(int i = 0; i<arr.length;i++){
                        arr[i] = arr[i].replaceAll("\s*", "");
                    }
                    if(arr[0].endsWith("jsp")){
                        type = "100";
                    }
                    if(arr[0].endsWith("action")){
                        type = "101";
                    }
                    String sout = "insert into t_resource (ResourceTypeId,url,Title) values ("+type+","+"'"+arr[0]+"'"+","+"'"+arr[1]+"'"+");";
                    bw.write(sout+"
");
                }
                
            }
            bw.write("#"+fileArr[k]+"
");
            reader.close();
        }
        bw.close();
    }

}