?? borrowermanage.java
字號:
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);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -