fraddreader.java~3~

用java编写的实现图书管理系统系统的功能

package mybook.book;

import java.awt.*;

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Dimension;
import java.awt.Font;
import mydbc.dbc.DBC;
import java.sql.ResultSet;
import java.sql.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class FrAddreader extends JFrame {
    public FrAddreader() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        setSize(new Dimension(342, 408));
        this.setTitle("添加新读者");
        lblCash.setText("金额：");
        lblCash.setBounds(new Rectangle(55, 272, 42, 15));
        jLabel8.setBounds(new Rectangle(45, 326, 42, 15));
        txtName.setBounds(new Rectangle(129, 56, 92, 20));
        txtSex.setBounds(new Rectangle(129, 99, 51, 20));
        txtRenttime.setBounds(new Rectangle(129, 142, 51, 20));
        txtPhone.setBounds(new Rectangle(129, 185, 150, 20));
        txtAddress.setBounds(new Rectangle(129, 228, 150, 20));
        txtCash.setBounds(new Rectangle(129, 271, 45, 20));
        btnSubmit.setBounds(new Rectangle(52, 332, 81, 23));
        btnSubmit.setText("提交");
        btnSubmit.addActionListener(new FrAddreader_btnSub_actionAdapter(this));
        btnBack.setBounds(new Rectangle(200, 332, 81, 23));
        btnBack.setText("返回");
        btnBack.addActionListener(new FrAddreader_btnBack_actionAdapter(this));
        lblAddress.setText("地址:");
        lblAddress.setBounds(new Rectangle(55, 230, 42, 15));
        lblPhone.setText("联系电话:");
        lblPhone.setBounds(new Rectangle(55, 188, 65, 15));
        lblRenttime.setText("借书期限:");
        lblRenttime.setBounds(new Rectangle(55, 145, 63, 15));
        lblSex.setText("性别:");
        lblSex.setBounds(new Rectangle(55, 103, 42, 15));
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
        jLabel1.setText("添加新读者");
        jLabel1.setBounds(new Rectangle(127, 8, 88, 30));
        lblRmb.setText("元");
        lblRmb.setBounds(new Rectangle(184, 272, 42, 15));
        jLabel2.setText("天");
        jLabel2.setBounds(new Rectangle(186, 144, 42, 15));
        this.getContentPane().add(lblSex);
        this.getContentPane().add(lblPhone);
        this.getContentPane().add(txtRenttime);
        this.getContentPane().add(txtPhone);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(txtCash);
        this.getContentPane().add(txtAddress);
        this.getContentPane().add(lblAddress);
        this.getContentPane().add(lblCash);
        this.getContentPane().add(lblRenttime);
        this.getContentPane().add(txtName);
        this.getContentPane().add(txtSex);
        this.getContentPane().add(btnBack);
        this.getContentPane().add(btnSubmit);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(lblName);
        this.getContentPane().add(lblRmb);
        this.getContentPane().add(jLabel2);
        lblName.setText("姓名:");
        lblName.setBounds(new Rectangle(55, 61, 42, 15));
    }

    JLabel lblName = new JLabel();
    JLabel lblSex = new JLabel();
    JLabel lblRenttime = new JLabel();
    JLabel lblPhone = new JLabel();
    JLabel lblAddress = new JLabel();
    JLabel lblCash = new JLabel();
    JLabel jLabel8 = new JLabel();
    JTextField txtName = new JTextField();
    JTextField txtSex = new JTextField();
    JTextField txtRenttime = new JTextField();
    JTextField txtPhone = new JTextField();
    JTextField txtAddress = new JTextField();
    JTextField txtCash = new JTextField();
    JButton btnSubmit = new JButton();
    JButton btnBack = new JButton();
    JLabel jLabel1 = new JLabel();
    JLabel lblRmb = new JLabel();
    JLabel jLabel2 = new JLabel();
    public void btnSub_actionPerformed(ActionEvent e) {
        if(txtName.getText().equals("") || txtSex.getText().equals("") || txtPhone.getText().equals("")
                || txtRenttime.getText().equals("") || txtAddress.getText().equals("") || txtCash.getText().equals("")){
            javax.swing.JOptionPane.showMessageDialog(this,"各栏位不能为空！请重填。");
        }else{
            try {
                Integer.parseInt(txtCash.getText());
            } catch (NumberFormatException ex) {
                javax.swing.JOptionPane.showMessageDialog(this,"现金必须为数字！请重填。");
                return;
            }
            DBC dbc = DBC.getInstance();
            if(dbc.executeUpdate("INSERT Users VALUES ('"+txtName.getText()+"','"+txtSex.getText()+"',"+Integer.parseInt(txtRenttime.getText())+",'"+txtPhone.getText()+"','"+txtAddress.getText()+"',"+Integer.parseInt(txtCash.getText())+",DEFAULT)")){
                ResultSet rs = dbc.executeQuery("SELECT Uid FROM Users WHERE Uname = '"+txtName.getText()+"'");
                    String id = null;
                    try {
                        rs.next();
                        id = rs.getString("Uid");
                    } catch (SQLException ex1) {
                        javax.swing.JOptionPane.showMessageDialog(this,ex1.getMessage().toString());
                    }
                    javax.swing.JOptionPane.showMessageDialog(this,
                            "新读者添加成功！读者编号为：" + id+"请您牢记！");
            }
        }
    }

    public void btnBack_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }

}


class FrAddreader_btnBack_actionAdapter implements ActionListener {
    private FrAddreader adaptee;
    FrAddreader_btnBack_actionAdapter(FrAddreader adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnBack_actionPerformed(e);
    }
}


class FrAddreader_btnSub_actionAdapter implements ActionListener {
    private FrAddreader adaptee;
    FrAddreader_btnSub_actionAdapter(FrAddreader adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnSub_actionPerformed(e);
    }
}