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();
}
}
jdbc 批处理
最新推荐文章于 2023-08-05 14:29:51 发布