jdbc 批处理

package com.xxx

import com.mysql.jdbc.PreparedStatement;
import org.springframework.stereotype.Component;
import javax.xml.stream.XMLStreamException;
import java.io.FileNotFoundException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;


@Component
public class BatchJdbc {

    /**
     *
     * @throws SQLException
     * @throws FileNotFoundException
     * @throws XMLStreamException
     */
    public void insertA0ym() throws SQLException, ClassNotFoundException {
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/ytt";
        String username = "root";
        String password = "root";
        Connection connection = null;

        Class.forName(driver);
        connection = DriverManager.getConnection(url, username, password);
        // 组合sql语句 0f6986e0-cb20-4373-b078-6832970f17b3    44295084-521A-4A5D-B9BE-BBD122541B81         20 20 06
        String sql1 = "truncate table a0ym;";
        String sql2 = "INSERT INTO a0ym VALUES('0f6986e0-cb20-4373-b078-6832970f17b3','44295084-521A-4A5D-B9BE-BBD122541B81',null,null,10,10,'02')," +
                "('0f6986e0-cb20-4373-b078-6832970fb3','44295084-521A-4A5D-B9BE-BBD122541B81',null,null,20,20,'04')," +
                "('0f6986e0-c373-b078-6832970f17b3','44295084-521A-4A5D-B9BE-BBD122541B81',null,null,30,30,'05')";
        // 设置事务为非自动提交
        connection.setAutoCommit(false);
        // PreparedStatement 执行 sql语句
        PreparedStatement pst = (PreparedStatement) connection.prepareStatement("");
        // 添加执行sql
        pst.addBatch(sql1);
        // 执行操作
        pst.executeBatch();
        // 提交事务
        connection.commit();
        pst.addBatch(sql2);
        // 执行操作
        pst.executeBatch();
        // 提交事务
        connection.commit();
        connection.close();
    }

}