JDBC | 4

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();            }        }    }}