transactionsql.java~2~

来自「野生动物系统的JAVA源码, 野生动物系统的JAVA源码」· JAVA~2~ 代码 · 共 46 行

package scout.database.util;

import java.sql.*;
import java.util.*;
import scout.database.util.*;

public class TransactionSql {
    Connection conn = null;
    public TransactionSql(Connection conn) {
        this.conn = conn;
    }

    /**
     * exeute transaction of sql,
     * 0:dont't exequte;
     * 1:OK
     * -1:commit is error
     * -2:rollback is error
     * @param sqlVv Vector
     * @return int
     */
    public int delete(Vector sqlVv) {
        InsertOrDelete iod = new InsertOrDelete(conn);
        int flag = 0;
        try {
            conn.setAutoCommit(false);
            for (int i = 0; i < sqlVv.size(); i++) {
                iod.inOrDel(sqlVv.get(i).toString());
            }
            conn.commit();
            conn.setAutoCommit(true);
            flag = 1;
        } catch (SQLException e1) {
            try {
                conn.rollback();
                e1.printStackTrace();
                flag = -1;
            } catch (SQLException e2) {
                e2.printStackTrace();
                flag = -2;
            }
        }
        return flag;
    }
}