Artigos Java Executando processos batch com JDBC

A API JDBC fornece métodos para executar um determinado número de queries SQL em um batch. O exemplo abaixo executa 3-4 queries de INSERÇÃO em um único grupo (single batch).


import java.sql.*;

public class testBatch 
{
    public static void main(String[] args) 
    {
        DB db = new DB();
        Connection conn =
           db.dbConnect("jdbc:jtds:sqlserver://localhost:1433/tempdb","sa","");
        db.performBatch(conn);
    }
}

class DB
{
    public DB() {}

    public Connection dbConnect(String db_connect_string, 
                                String db_userid, String db_password)
    {
        try
        {
            Class.forName("net.sourceforge.jtds.jdbc.Driver");
            Connection conn = DriverManager.getConnection(
                              db_connect_string, db_userid,db_password);
            System.out.println("conectado");
            return conn;
            
        }
        catch (Exception e)
        {
            e.printStackTrace();
            return null;
        }
    }

    public void performBatch(Connection conn)
    {
        String query;
        Statement stmt;
        
        try
        {
            conn.setAutoCommit(false);

            stmt = conn.createStatement();  

            stmt.addBatch("INSERT INTO customer " + 

                "VALUES('name2', 'temp2',27)");
            stmt.addBatch("INSERT INTO customer " +
                "VALUES('name3', 'temp3',28)");
            stmt.addBatch("INSERT INTO customer " +
                "VALUES('name4','temp4',29)");
        
            int [] updateCounts = stmt.executeBatch();
            conn.commit();
            conn.setAutoCommit(true);
            stmt.close();
            conn.close();

        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
};