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