package com.dzq.batch;

import java.sql.Connection;

import java.sql.Statement;

import com.itheima.util.JDBCUtils;

/*

    create database day10batch;

    use day10batch;

    create table batchDemo(

        id int primary key auto_increment,

        name varchar(20)

    );

    insert into batchDemo values(null,'aaaa');

    insert into batchDemo values(null,'bbb');

    insert into batchDemo values(null,'cc');

    insert into batchDemo values(null,'d');

 */

/*

    Statement方式执行批处理:

        优点:可以执行多条不同结构的sql语句

        缺点:没有使用预编译机制,效率低下,如果要执行多条结构相同仅仅参数不同的sql时,仍然需要写多次sql语句的主干

 */

public class StatementBatch {

    public static void main(String[] args) {

        Connection conn = null;

        Statement stat = null;

        try{

            conn = JDBCUtils.getConn();

            stat = conn.createStatement();

            stat.addBatch("create database day10batch");

            stat.addBatch("use day10batch");

            stat.addBatch("create table batchDemo("+

                                "id int primary key auto_increment,"+

                                "name varchar(20)"+

                            ")");

            stat.addBatch("insert into batchDemo values(null,'aaaa')");

            stat.addBatch("insert into batchDemo values(null,'bbb')");

            stat.addBatch("insert into batchDemo values(null,'cc')");

            stat.addBatch("insert into batchDemo values(null,'d')");

            stat.executeBatch();

        }catch (Exception e) {

            e.printStackTrace();

        }finally{

            JDBCUtils.close(null, stat, conn);

        }

    }

}

package com.dzq.batch;

import java.sql.Connection;

import java.sql.PreparedStatement;

import com.itheima.util.JDBCUtils;

/*

     create table psbatch(

         id int primary key auto_increment,

         name varchar(30)

     );

 */

/*

    prparedStatement 方式实现的批处理:

        优点:有预编译机制,效率比较高.执行多条结构相同,参数不同的sql时,不需要重复写sql的主干

        缺点:只能执行主干相同参数不同的sql,没有办法在一个批中加入结构不同的sql

 */

public class PSBatch {

    public static void main(String[] args) {

        Connection conn = null;

        PreparedStatement ps = null;

        try{

            conn = JDBCUtils.getConn();

            ps = conn.prepareStatement("insert into psbatch values(null,?)");

            for(int i=1;i<=100000;i++){

                ps.setString(1, "name"+i);

                ps.addBatch();

                if(i%1000==0){

                    ps.executeBatch();

                    ps.clearBatch();

                }

            }

            ps.executeBatch();

        }catch (Exception e) {

            e.printStackTrace();

        }finally{

            JDBCUtils.close(null, ps, conn);

        }

    }

}