批量向oracle插入数据

最新推荐文章于 2024-07-17 19:00:48 发布

龙海881123

最新推荐文章于 2024-07-17 19:00:48 发布

阅读量464

点赞数

文章标签： oracle random insert jdbc table null

本文链接：https://blog.csdn.net/ckf53390/article/details/6737108

版权

DECLARE
i INT;
BEGIN
i := 0;
WHILE(i < 100000)
LOOP
i := i + 1;
INSERT INTO TEST_TABLE(ID, XM) VALUES(i, '姓名' || i);
END LOOP;
COMMIT;
END;

Class.forName( "oracle.jdbc.driver.OracleDriver" );

Connection conn = DriverManager.getConnection( "jdbc:oracle:thin:@yourIp:1521:ORCL", "用户名", "密码" );

        PreparedStatement ps = null;
        try {
            conn.setAutoCommit(false);
            ps = conn.prepareStatement("insert into t_user(username, password) values(?,?)");
            Random r = new Random();
            for(int i = 0; i < 1000; i++){
                ps.setString(1, String.valueOf(r.nextInt(Integer.MAX_VALUE)));
                ps.setString(2, String.valueOf(r.nextInt()));
                ps.addBatch();//加入批处理
                //ps.executeUpdate();不能与addBatch（）同时用

            }
            int[] results = ps.executeBatch();//执行批处理
            conn.commit();
        } catch (SQLException e) {
            conn.rollback();
            throw e;
        }finally{
            ps.close();
            conn.close();
        }