图书管理系统（C/S）（ACCP认证考试扩展）

package findbook; import java.awt.BorderLayout; import javax.swing.JFrame; import javax.swing.JRadioButton; import java.awt.*; import javax.swing.JLabel; import javax.swing.JTextField; import javax.swing.JButton; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.text.DateFormat; import java.util.Calendar; import java.text.ParseException; import javax.swing.JOptionPane; import java.util.Date; import java.sql.*; import java.text.SimpleDateFormat; /** * <p>Title:图书信息管理 </p> * * <p>Description: 2008-10-17</p> * * <p>Copyright: Copyright (c) 2008</p> * * <p>Company:卜文磊（QQ：517908824） </p> * * @author not attributable * @version 1.0 */ public class AddBookFrame extends JFrame { //定义临时变量以区别添加和修改的行为 String whatAction = null; DBGet db = null; JOptionPane jPane = new JOptionPane(); public AddBookFrame(String action) { try { jbInit(); //调用内部方法whatAction() whatAction(action); } catch (Exception exception) { exception.printStackTrace(); } } public AddBookFrame(String action, String bookname, String booktype, String pubdate, String price) { try { jbInit(); //获取要修改的书籍信息，以更改其相关信息 this.txtBName.setText(bookname); this.txtBType.setText(booktype); this.txtBPubDate.setText(pubdate); this.txtBPrice.setText(price); whatAction(action); } catch (Exception ex) { ex.printStackTrace(); } } //窗体所执行行为的判断 private void whatAction(String action) { if (action.equals("Add")) { whatAction = "Add"; txtBName.setEnabled(true); txtBType.setEnabled(true); txtBPubDate.setEnabled(true); txtBPrice.setEnabled(true); this.setTitle("图书信息添加"); lblMain.setText("图书信息添加"); this.btnModifyOrAdd.setText("添 加"); } else if (action.equals("Modify")) { whatAction = "Modify"; txtBName.setEnabled(false); txtBPrice.setEnabled(true); txtBType.setEnabled(true); txtBPubDate.setEnabled(true); this.setTitle("图书信息修改"); lblMain.setText("书籍信息修改"); this.btnModifyOrAdd.setText("修 改"); } } private void jbInit() throws Exception { getContentPane().setLayout(null); setSize(400, 350); lblMain.setFont(new java.awt.Font("Dialog", Font.BOLD, 20)); // lblMain.setText("书籍添加"); lblMain.setBounds(new Rectangle(122, 10, 153, 34)); txtBName.setBounds(new Rectangle(132, 52, 160, 28)); lblBName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13)); lblBName.setText("图书名称:"); lblBName.setBounds(new Rectangle(48, 50, 67, 31)); txtBPrice.setEnabled(true); txtBPrice.setBounds(new Rectangle(132, 180, 160, 29)); lblBPrice.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13)); lblBPrice.setText("图书价格:"); lblBPrice.setBounds(new Rectangle(48, 182, 66, 25)); txtBPubDate.setEnabled(true); txtBPubDate.setBounds(new Rectangle(132, 136, 160, 29)); txtBType.setEnabled(true); txtBType.setBounds(new Rectangle(132, 92, 160, 29)); lblBType.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13)); lblBType.setText("图书类别:"); lblBType.setBounds(new Rectangle(48, 96, 64, 31)); btnClear.setBounds(new Rectangle(226, 222, 68, 27)); btnClear.setText("清 空"); btnClear.addActionListener(new AddBookFrame_btnClear_actionAdapter(this)); lblPubDate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13)); lblPubDate.setText("出版日期:"); lblPubDate.setBounds(new Rectangle(48, 130, 64, 41)); btnModifyOrAdd.setBounds(new Rectangle(98, 223, 74, 25)); btnModifyOrAdd.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13)); btnModifyOrAdd.setText(""); btnModifyOrAdd.addActionListener(new AddBookFrame_btnModifyOrAdd_actionAdapter(this)); lblDateFormat.setFont(new java.awt.Font("Dialog", Font.PLAIN, 10)); lblDateFormat.setForeground(Color.red); lblDateFormat.setText("例：2008-12-12"); lblDateFormat.setBounds(new Rectangle(298, 140, 83, 21)); this.getContentPane().add(txtBName); this.getContentPane().add(lblBName); this.getContentPane().add(txtBPrice); this.getContentPane().add(lblBPrice); this.getContentPane().add(txtBPubDate); this.getContentPane().add(txtBType); this.getContentPane().add(lblBType); this.getContentPane().add(lblPubDate); this.getContentPane().add(btnClear); this.getContentPane().add(lblMain); this.getContentPane().add(btnModifyOrAdd); this.getContentPane().add(lblDateFormat); } JLabel lblMain = new JLabel(); JTextField txtBName = new JTextField(); JLabel lblBName = new JLabel(); JTextField txtBPrice = new JTextField(); JLabel lblBPrice = new JLabel(); JTextField txtBPubDate = new JTextField(); JTextField txtBType = new JTextField(); JLabel lblBType = new JLabel(); JButton btnClear = new JButton(); JLabel lblPubDate = new JLabel(); JButton btnModifyOrAdd = new JButton(); int success; JLabel lblDateFormat = new JLabel(); public void btnClear_actionPerformed(ActionEvent e) { this.txtBName.setText(""); this.txtBPrice.setText(""); this.txtBPubDate.setText(""); this.txtBType.setText(""); } public void btnModifyOrAdd_actionPerformed(ActionEvent e) throws ParseException { db = new DBGet(); String bName = txtBName.getText(); String bType = txtBType.getText(); String bDate = txtBPubDate.getText(); String bPrice = txtBPrice.getText(); //检查个字段的值是否为空 if (bName.equals("") || bType.equals("") || bDate.equals("") || bPrice.equals("")) { jPane.showMessageDialog(this, "请填写完整信息！"); return; } //调用方法以检查日期与数值的格式 //如果转换出现异常即停止执行 String pubDate = this.formatToDate(bDate); if (pubDate == null) { return; } float price = this.formatToDouble(bPrice); if (price == 0.0f) { return; } try { //判断此窗体要执行添加还是修改 if (whatAction.equals("Add")) { success = 0; boolean flag = checkText(); //首先检查书籍信息输入的合法性 if (!flag) { success = db.isOrNotAdd(txtBName.getText(), txtBType.getText(), pubDate, price); if (success != 0) { jPane.showMessageDialog(this, "添加成功！", "提示", jPane. INFORMATION_MESSAGE); } else { jPane.showMessageDialog(this, "添加失败！", "提示", jPane. INFORMATION_MESSAGE); return; } } else { jPane.showMessageDialog(this, "该书籍名称已存在！", "提示", jPane.