package cn.itcast.demo5;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import org.junit.Test;

import cn.itcast.demo3.JdbcUtils;

public class Demo5 {

    @Test

    public void fun5() throws SQLException {

        /*

         * pstmt：

         * > 添加参数到批中

         * > 执行批！

         */

        Connection con = JdbcUtils.getConnection();

        String sql = "INSERT INTO t_stu VALUES(?,?,?,?)";

        PreparedStatement pstmt = con.prepareStatement(sql);

        // 疯狂的添加参数

        for(int i = 0; i < 10000; i++) {

            pstmt.setInt(1, i+1);

            pstmt.setString(2, "stu_" + i);

            pstmt.setInt(3, i);

            pstmt.setString(4, i%2==0?"男":"女");

            pstmt.addBatch();//添加批！这一组参数就保存到集合中了。

        }

        long start = System.currentTimeMillis();

        pstmt.executeBatch();//执行批！

        long end = System.currentTimeMillis();

        System.out.println(end - start);

    }

}