JDBC连接Oracle数据库，添加数据，设置手动提交，出现错误时启动回滚操作

 public static void  insert(){

        Connection conn = null;
        PreparedStatement stm1 = null;
        PreparedStatement stm2= null;
        try{
            conn = OracleUtil.getConnection();
            //设置事物为手动提交，
            conn.setAutoCommit(false);//不自动提交
            stm1= conn.prepareStatement("insert into t_admin values(?,?)");
            stm1.setString(1, "admin");
            stm1.setString(2,"bgsn");
            stm1.executeUpdate();
            stm2.setString(1,"qq");
            stm2.setString(2,"34");
            stm2.executeUpdate();
            //如果SQL正常运行，则提交事务
            conn.commit();
           
        }catch (Exception e){
            try {
                //SQL没有正确执行，回滚事务
                conn.rollback();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            e.printStackTrace();
        }finally {
            OracleUtil.closePreparedStatement(stm1);
            OracleUtil.closePreparedStatement(stm2);
            OracleUtil.closeConnection(conn);
        }