mysql JDBC批量操作

最新推荐文章于 2025-02-20 16:39:12 发布

方糖敲代码

最新推荐文章于 2025-02-20 16:39:12 发布

阅读量578

点赞数

分类专栏：技术总结文章标签： mysql jdbc

本文链接：https://blog.youkuaiyun.com/u010679782/article/details/54091730

版权

技术总结专栏收录该内容

60 篇文章

订阅专栏

private static void insertData() throws SQLException {
        DruidDataSource dataSource = new DruidDataSource();   dataSource.setUrl("jdbc:mysql://ip:3306/cms?rewriteBatchedStatements=true");
        dataSource.setUsername("root");
        dataSource.setPassword("root");

        dataSource.init();

        Connection connection = dataSource.getConnection();

        PreparedStatement preparedStatement = connection.prepareStatement("insert into Student(user_name,sex,age) values (?,?,?)");
        List<String> list = new ArrayList();
        for (int i = 0; i < list.size; i++) {
            preparedStatement.setString(1, list.get(i));
            preparedStatement.addBatch();
            if((i+1) % batchSize == 0) {
                preparedStatement.executeBatch();
            }
        }
        preparedStatement.executeBatch();

        connection.close();   

        dataSource.close();
    }