怎样用JDBC进行事务处理

Question

//取得用作事务处理的conn
        Connection conn = null;
        Statement st = null;        try {
            //将该文件存入数据库
            conn = DriverManager.getConnection(Resource.URL, Resource.USER, Resource.PASSWORD);
            st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
            conn.setAutoCommit(false);
            
            st.addBatch(你的sql);
st.addBatch(你的sql);
st.addBatch(你的sql);
st.addBatch(你的sql);
......
            st.executeBatch();
            conn.commit();
            conn.setAutoCommit(true);
        } catch (SQLException e) {
            try {
                conn.rollback();
                conn.setAutoCommit(true);
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
            e.printStackTrace();
        } finally {
            try {
                st.close();
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

Answer 1

同意funcreal(new PLMM[Integer.MAX_VALUE]) 和Jacky1206(胖胖)