systemdataresetaction.java

一个简单的图书馆的管理系统,该系统主要是针对学校的图书馆而做的

package librarymanagement.action.dialogAction;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JOptionPane;

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

public class SystemDataResetAction implements ActionListener{

	SystemDataResetDialog dialog;
	public SystemDataResetAction(SystemDataResetDialog dialog) {
		this.dialog = dialog;
	}

	public void actionPerformed(ActionEvent e) {
		String name = e.getActionCommand();
		Connection con = null;
		DBConnectionManager manager = DBConnectionManager.getInstance();
		con = manager.getConnection("oracle");
		Statement s = null;
		if(name.equals("返回")){
			return;
		}else if(name.equals("执行")){
			int ch = JOptionPane.showConfirmDialog(null,"确定执行？","严重警告！",JOptionPane.YES_NO_OPTION);
			if(ch == JOptionPane.YES_OPTION){
				if(dialog.box1.isSelected()){
				    try { s = con.createStatement();
		         
						s.executeUpdate("delete book");
				    }catch (SQLException e1) {
				    	 JOptionPane.showConfirmDialog(null, e1.getMessage(),"异常提示",JOptionPane.YES_OPTION);
					}
				} if(dialog.box2.isSelected()){
					 try { s = con.createStatement();
			         
						s.executeUpdate("delete reader");
				    }catch (SQLException e1) {
				    	 JOptionPane.showConfirmDialog(null, e1.getMessage(),"异常提示",JOptionPane.YES_OPTION);
					}
				} if(dialog.box3.isSelected()){
					 try {
						 s = con.createStatement();
			         
						s.executeUpdate("delete reader_info");
				    }catch (SQLException e1) {
				    	 JOptionPane.showConfirmDialog(null, e1.getMessage(),"异常提示",JOptionPane.YES_OPTION);
					}
				}
			}
		}		
			
				manager.freeConnection("oracle", con);		
			
	
	}

}