文件批处理

opackage com.test.parse;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.UUID;

public class ReadQyjbxx {
 
    public static void readFileByLines(String fileName) {
        File file = new File(fileName);
        BufferedReader reader = null;
        int line = 0 ;
        Connection conn = null ; 
        PreparedStatement ps = null ;
        try {
            reader = new BufferedReader(new FileReader(file));
            String tempString = null;
            conn = Tools.getConn() ;
            conn.setAutoCommit(false) ;
            String sql = "insert into COMPANY_BASE_INFO(ID, APPLICANT_CODE, COMPANY_NAME, REGISTER_NO, LEGAL_PERSON, TYPE, COMPANY_ADDRESS, SETUP_TIME, APPROVAL_TIME, REGISTER_OFFICE) " +
      "values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" ;
            ps = conn.prepareStatement(sql) ;
            line = 1;
            while ((tempString = reader.readLine()) != null) {
                String values[] = tempString.split(",") ;
                //"ZZJGDM","QYMC","QYZCH","FDDBRXM","QYLXMC","ZS","SLRQ","HZRQ","DJJGMC"
                line++; 

                ps.setString(1, UUID.randomUUID().toString().toUpperCase().replaceAll("-", "")) ;
                ps.setString(2, values[0].substring(1, values[0].length()-1)) ;
                ps.setString(3, values[1].substring(1, values[1].length()-1)) ;
                ps.setString(4, values[2].substring(1, values[2].length()-1)) ;
                ps.setString(5, values[3].substring(1, values[3].length()-1)) ;
                ps.setString(6, values[4].substring(1, values[4].length()-1)) ;
                ps.setString(7, values[5].substring(1, values[5].length()-1)) ;
                ps.setString(8, values[6].substring(1, values[6].length()-1)) ;
                ps.setString(9, values[7].substring(1, values[7].length()-1)) ;
                ps.setString(10, values[8].substring(1, values[8].length()-1)) ;
                
                ps.addBatch() ;
            }
            
            ps.executeBatch() ;
            
            conn.commit() ;
            
            reader.close();
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println(line) ;
        } finally {
            if (reader != null) {
                try {
                    reader.close();
                } catch (IOException e1) {
                }
            }
            Tools.close(conn, ps) ;
        }
    }

    public static void main(String[] args) {
        String fileName = "D:/XXXX.txt";
        ReadQyjbxx.readFileByLines(fileName);
    }
}