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

来源：互联网发布：.hp文件是什么数据库编辑：程序博客网时间：2024/05/22 14:20

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

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();        }

欢迎拍砖

0 0