borrowermanage.java

基于javaSwing的图书馆信息管理系统 使用oracle数据库连接

package com.lib.gui;

import java.awt.BorderLayout;
import java.util.Iterator;

import javax.swing.ButtonGroup;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.JToolBar;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;

import com.lib.DBConnection;
import com.lib.Main;
import com.lib.db.Borr;
import com.lib.db.Borrower;
import com.lib.db.Publisher;
import com.lib.db.oper.BorrowerOper;
import com.lib.db.oper.PublisherOper;

public class BorrowerManage extends JFrame {

	private JPanel jContentPane = null;

	private JToolBar jToolBar = null;

	private JToolBar jToolBar_card = null;

	private JToolBar jToolBar_id = null;

	private JToolBar jToolBar_borrower = null;

	private JToolBar jToolBar_pwd = null;

	private JToolBar jToolBar_isstudent = null;

	private JToolBar jToolBar_email = null;

	private JToolBar jToolBar_phone = null;

	private JTextField jTextField_card = null;

	private JTextField jTextField_id = null;

	private JLabel jLabel_card = null;

	private JLabel jLabel_id = null;

	private JToolBar jToolBar_control = null;

	private JButton jButton_clear = null;

	private JButton jButton_edit = null;

	private JButton jButton_add = null;

	private JButton jButton_del = null;

	private JLabel jLabel_borrower = null;

	private JLabel jLabel_pwd = null;

	private JLabel jLabel_email = null;

	private JLabel jLabel_phone = null;

	private JTextField jTextField_borrower = null;

	private JTextField jTextField_email = null;

	private JTextField jTextField_phone = null;

	private JToolBar jToolBar_space = null;

	private JTextArea jTextArea_space = null;

	private JRadioButton jRadioButton_stu = null;

	private JRadioButton jRadioButton_tea = null;

	private JPasswordField jPasswordField = null;

	private JPanel jPanel = null;

	private JScrollPane jScrollPane = null;

	private JTable jTable = null;

	private ButtonGroup bg;

	private void search() {
		TableModel model = getJTable().getModel();
		DefaultTableModel tablemodel = (DefaultTableModel) model;
		Iterator iter = BorrowerOper.getInfo().iterator();
		int counts = tablemodel.getRowCount();
		for (int i = counts - 1; i >= 0; i--) {
			tablemodel.removeRow(i);
		}
		while (iter.hasNext()) {
			Borr value = (Borr) iter.next();			
			String tempFlag = "";
			if (value.getIsStudent().equals("1")) {
				tempFlag = "学生";
			} else if (value.getIsStudent().equals("0")) {
				tempFlag = "老师";
			}
			Object[] obj = { value.getCard_id(), value.getBorrower_id(),
					value.getBorrower(), value.getLogin(), tempFlag, value.getEmail(),
					value.getPhone(), value.getBorrow_num() };
			tablemodel.addRow(obj);
		}
	}

	/**
	 * This is the default constructor
	 */
	public BorrowerManage() {
		super();
		initialize();
	}
	public Main main = null;
	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		search();
		this.setSize(640, 480);
		this.setLocation(200, 50);
		this.setContentPane(getJContentPane());
		this.setTitle("借阅人/卡维护");
		this.addWindowListener(new java.awt.event.WindowAdapter() {
			public void windowClosing(java.awt.event.WindowEvent e) {
				//DBConnection.closeConnection();
				if (main != null) {
					main.setVisible(true);
				}
			}
		});
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(new BorderLayout());
			jContentPane.add(getJToolBar(), java.awt.BorderLayout.EAST);
			jContentPane.add(getJPanel(), java.awt.BorderLayout.CENTER);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jToolBar
	 * 
	 * @return javax.swing.JToolBar
	 */
	private JToolBar getJToolBar() {
		if (jToolBar == null) {
			jToolBar = new JToolBar();
			jToolBar.setFloatable(false);
			jToolBar.setOrientation(javax.swing.JToolBar.VERTICAL);
			jToolBar.add(getJToolBar_card());
			jToolBar.add(getJToolBar_id());
			jToolBar.add(getJToolBar_borrower());
			jToolBar.add(getJToolBar_login());
			jToolBar.add(getJToolBar_isstudent());
			jToolBar.add(getJToolBar_email());
			jToolBar.add(getJToolBar_phone());
			jToolBar.add(getJToolBar_space());
			jToolBar.add(getJToolBar_pwd1());
			jToolBar.add(getJToolBar_pwd());
			jToolBar.add(getJToolBar_control());
		}
		return jToolBar;
	}

	/**
	 * This method initializes jToolBar_card
	 * 
	 * @return javax.swing.JToolBar
	 */
	private JToolBar getJToolBar_card() {
		if (jToolBar_card == null) {
			jLabel_card = new JLabel();
			jLabel_card.setText("借阅卡编号");
			jToolBar_card = new JToolBar();
			jToolBar_card.setFloatable(false);
			jToolBar_card.add(jLabel_card);
			jToolBar_card.add(getJTextField_card());
			jToolBar_card.add(getJButton_updateCard());
		}
		return jToolBar_card;
	}

	/**
	 * This method initializes jToolBar_id
	 * 
	 * @return javax.swing.JToolBar
	 */
	private JToolBar getJToolBar_id() {
		if (jToolBar_id == null) {
			jLabel_id = new JLabel();
			jLabel_id.setText("借阅者编号");
			jToolBar_id = new JToolBar();
			jToolBar_id.setFloatable(false);
			jToolBar_id.add(jLabel_id);
			jToolBar_id.add(getJTextField_id());
		}
		return jToolBar_id;
	}

	/**
	 * This method initializes jToolBar_borrower
	 * 
	 * @return javax.swing.JToolBar
	 */
	private JToolBar getJToolBar_borrower() {
		if (jToolBar_borrower == null) {
			jLabel_borrower = new JLabel();
			jLabel_borrower.setText("借阅者姓名");
			jToolBar_borrower = new JToolBar();
			jToolBar_borrower.setFloatable(false);
			jToolBar_borrower.add(jLabel_borrower);
			jToolBar_borrower.add(getJTextField_borrower());
		}
		return jToolBar_borrower;
	}

	/**
	 * This method initializes jToolBar_pwd
	 * 
	 * @return javax.swing.JToolBar
	 */
	private JToolBar getJToolBar_pwd() {
		if (jToolBar_pwd == null) {
			jLabel_pwd = new JLabel();
			jLabel_pwd.setText("密码");
			jToolBar_pwd = new JToolBar();
			jToolBar_pwd.setFloatable(false);
			jToolBar_pwd.add(jLabel_pwd);
			jToolBar_pwd.add(getJPasswordField());
			jToolBar_pwd.add(getJButton_updatePwd());
		}
		return jToolBar_pwd;
	}

	/**
	 * This method initializes jToolBar_isstudent
	 * 
	 * @return javax.swing.JToolBar
	 */
	private JToolBar getJToolBar_isstudent() {
		if (jToolBar_isstudent == null) {
			jLabel_stutea1 = new JLabel();
			jLabel_stutea1.setText("身     份");
			jToolBar_isstudent = new JToolBar();
			jToolBar_isstudent.setFloatable(false);
			bg = new ButtonGroup();
			jToolBar_isstudent.add(jLabel_stutea1);
			bg.add(getJRadioButton_stu());
			bg.add(getJRadioButton_tea());
			jToolBar_isstudent.add(getJRadioButton_stu());
			jToolBar_isstudent.add(getJRadioButton_tea());
		}
		return jToolBar_isstudent;
	}

	/**
	 * This method initializes jToolBar_email
	 * 
	 * @return javax.swing.JToolBar
	 */
	private JToolBar getJToolBar_email() {
		if (jToolBar_email == null) {
			jLabel_email = new JLabel();
			jLabel_email.setText("E-Mail");
			jToolBar_email = new JToolBar();
			jToolBar_email.setFloatable(false);
			jToolBar_email.add(jLabel_email);
			jToolBar_email.add(getJTextField_email());
		}
		return jToolBar_email;
	}

	/**
	 * This method initializes jToolBar_phone
	 * 
	 * @return javax.swing.JToolBar
	 */
	private JToolBar getJToolBar_phone() {
		if (jToolBar_phone == null) {
			jLabel_phone = new JLabel();
			jLabel_phone.setText("电话");
			jToolBar_phone = new JToolBar();
			jToolBar_phone.setFloatable(false);
			jToolBar_phone.add(jLabel_phone);
			jToolBar_phone.add(getJTextField_phone());
		}
		return jToolBar_phone;
	}

	/**
	 * This method initializes jTextField_card
	 * 
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField_card() {
		if (jTextField_card == null) {
			jTextField_card = new JTextField();
			jTextField_card.setEditable(false);
		}
		return jTextField_card;
	}

	/**
	 * This method initializes jTextField_id
	 * 
	 * @return javax.swing.JTextField
	 */
	private JTextField getJTextField_id() {
		if (jTextField_id == null) {
			jTextField_id = new JTextField();
			jTextField_id.setEditable(false);
		}
		return jTextField_id;
	}

	/**
	 * This method initializes jToolBar_control
	 * 
	 * @return javax.swing.JToolBar
	 */
	private JToolBar getJToolBar_control() {
		if (jToolBar_control == null) {
			jToolBar_control = new JToolBar();
			jToolBar_control.setFloatable(false);
			jToolBar_control.add(getJButton_clear());
			jToolBar_control.add(getJButton_add());
			jToolBar_control.add(getJButton_edit());
			jToolBar_control.add(getJButton_del());
		}
		return jToolBar_control;
	}

	/**
	 * This method initializes jButton_clear
	 * 
	 * @return javax.swing.JButton
	 */
	private JButton getJButton_clear() {
		if (jButton_clear == null) {
			jButton_clear = new JButton();
			jButton_clear.setText("清空");
			jButton_clear.setIcon(new ImageIcon("E:/img/standard_094_20.png"));
			jButton_clear
					.addActionListener(new java.awt.event.ActionListener() {
						public void actionPerformed(java.awt.event.ActionEvent e) {
							jTextField_card.setText(null);
							jTextField_id.setText(null);
							jTextField_borrower.setText(null);
							jTextField_login.setText(null);
							jPasswordField.setText(null);
							jTextField_email.setText(null);
							jTextField_phone.setText(null);
							jRadioButton_stu.setSelected(true);
						}
					});
		}
		return jButton_clear;
	}

	// 检查编号文本框是否为空,说明是否已选择了一条记录
	//ture 表明通过
	//false表明未选择
	private boolean checkEmpty() {
		String id = getJTextField_id().getText().trim();
		if (id.isEmpty()) {
			JOptionPane.showMessageDialog(null, "请选择一条出版社记录来进行操作!!");
			return false;
		}
		return true;
	}

	/**
	 * This method initializes jButton_edit
	 * 
	 * @return javax.swing.JButton
	 */
	private JButton getJButton_edit() {
		if (jButton_edit == null) {
			jButton_edit = new JButton();
			//jButton_edit.setText("修改");
			jButton_add.setToolTipText("修改选择的借阅者记录(密码修改须密码确认)");
			jButton_edit.setIcon(new ImageIcon("E:/img/standard_138_20.png"));
			jButton_edit.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					if (checkEmpty()) {
						//......应该加上 登录ID 唯一性检查

						int ch = JOptionPane.showConfirmDialog(null,
								"你真的要修改该纪录？(除密码)", "修改数据",
								JOptionPane.YES_NO_OPTION);
						if (ch == JOptionPane.YES_OPTION) {
							Borrower value = getIputText();
							if (BorrowerOper.update(value)) {
								JOptionPane.showMessageDialog(null, "修改成功");
								search();
							} else {
								JOptionPane.showMessageDialog(null, "数据修改失败");
							}
						}

					}
				}
			});
		}
		return jButton_edit;
	}

	/**
	 * This method initializes jButton_add 添加一条 借阅者记录时
	 * 每一新增借阅人记录的同时与之对应的新增借阅卡记录(触发器实现)
	 * 
	 * @return javax.swing.JButton
	 */
	private JButton getJButton_add() {
		if (jButton_add == null) {
			jButton_add = new JButton();
			// jButton_add.setText("添加");
			jButton_add.setIcon(new ImageIcon("E:/img/standard_159_20.png"));
			jButton_add.setToolTipText("添加一条新的借阅者记录");
			jButton_add.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {

					Borrower value = getIputText();
					
					int ch = JOptionPane.showConfirmDialog(null, "你真的要添加该纪录？",
							"添加数据", JOptionPane.YES_NO_OPTION);
					if (ch == JOptionPane.YES_OPTION) {
						//添加新登录名
						String login = JOptionPane.showInputDialog("添加新的登录ID");
						value.setLogin(login);