setcommitstyle.java

来自「一个简单的图书馆的管理系统,该系统主要是针对学校的图书馆而做的」· Java 代码 · 共 46 行

package librarymanagement.common;

import java.sql.Connection;
import java.sql.SQLException;

import javax.swing.JOptionPane;

import librarymanagement.dao.common.DBConnectionManager;
import librarymanagement.view.dialog.ReturnBookDialog;

/**
 * 设置数据回滚
 * 
 * @author 陈兵
 * 
 */
public class SetCommitStyle {
	private static Connection con;
	private static DBConnectionManager manager;
	private static ReturnBookDialog returnBook;

	public SetCommitStyle(Connection con, DBConnectionManager manager) {
		this.con = con;
		this.manager = manager;
	}

	public static void setCommit_RollBack(String name) {
		try {
			if (name.equals(" 取    消 ")) {
				con.rollback();
				JOptionPane.showMessageDialog(null, "数据成功回滚");
				// manager.freeConnection("oracle", con);

			}
			if (name.equals("提交数据")) {
				con.commit();
				JOptionPane.showMessageDialog(null, "数据提交成功");
				manager.freeConnection("oracle", con);
			}
		} catch (SQLException e) {
			JOptionPane.showConfirmDialog(null, e.getMessage(), "异常提示",
					JOptionPane.YES_OPTION);
		}
	}
}