JDBC | 4 - PreparedStatement 批处理 |

import java.sql.*;

public class Main {
    private static final String DBDRIVER = "com.mysql.jdbc.Driver";
    private static final String DBURL = "jdbc:mysql://localhost:3306/TEACH?characterEncoding=utf-8&useSSL=true";
    private static final String DBUSER = "root";
    private static final String DBPASSWORD = "newpass";
    public static void main(String[] args) throws Exception{
        // 加载数据库驱动程序
        Class.forName(DBDRIVER);

        // 连接数据库
        Connection connection = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);

        try{
            connection.setAutoCommit(false);

            String sql = "INSERT into ELECTIVE VALUES (?,?,?)";
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1,"S7");
            preparedStatement.setString(2,"B");
            preparedStatement.setString(3,"99");
            preparedStatement.addBatch();

            preparedStatement.setString(1,"S7");
            preparedStatement.setString(2,"C");
            preparedStatement.setString(3,"99");
            preparedStatement.addBatch();

            preparedStatement.setString(1,"S7");
            preparedStatement.setString(2,"D");
            preparedStatement.setString(3,"99");
            preparedStatement.addBatch();

            preparedStatement.executeBatch();

            String sql2 = "SELECT SNO,CNO,SCORE FROM ELECTIVE";
            PreparedStatement preparedStatement1 = connection.prepareStatement(sql2);
            ResultSet resultSet = preparedStatement1.executeQuery();
            while (resultSet.next()){
                String SNO = resultSet.getString(1);
                String CNO = resultSet.getString(2);
                String SCORE = resultSet.getString(3);
                System.out.println(SNO + " " + CNO + " " + SCORE);
            }

            connection.commit();
            connection.setAutoCommit(true);
        }catch (Exception e){
            e.printStackTrace();
            connection.rollback();
            connection.setAutoCommit(true);
        }finally {
            try{
                if(connection != null){
                    connection.close();
                }
            }catch (Exception e){
                e.printStackTrace();
            }
        }
    }
}