一个从文本文件插入到数据库的代码

一个从文本文件插入到数据库的代码

public static void insertFromFile(Connection conn,File file) throws Exception {
                 String sql = "insert into test1 values (?,?,?)";
                BufferedReader br = new BufferedReader(new FileReader(file));
                String line = null;
                String[] record = null;
                String col1 = null;
                String col2 = null;
                String col3 = null;
                conn.setAutoCommit(false);
                PreparedStatement ps = conn.prepareStatement(sql);
                long start = System.currentTimeMillis();
                for (; (line = br.readLine()) != null; ) {
                        record = line.split("\t");
//                     System.out.println(record[0] + "\t" + record[1] + "\t" + record[2]);
                        col1 = record[0] ;
                        col2 = record[1] ;
                        col3 = record[2] ;
                        ps.setString(1,col1);
                        ps.setString(2,col2);
                        ps.setString(3,col3);
                        ps.executeUpdate();
//                     System.out.println(col1 + "\t" + col2 + "\t" + col3);
                }
                ;
                // PreparedStatement ps = conn.prepareStatement(sql);
                // ps.setInt(1, );
                conn.commit();
                long time = (System.currentTimeMillis()-start)/1000;
                System.out.println(time);
                System.out.println("插入成功！！");
                conn.close();
                br.close();
        }

欢迎拍砖