frmreturn.java

在管理员表中初始插入数据 usn: admin, pwd: 21232F297A57A5A743894A0E4A801FC3 初始用户账号/密码: admin (密码为 md5 加密) SRC

import java.awt.*;

import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;

public class FrmReturn extends JDialog implements ActionListener {
	FrmMain pr;
    public FrmReturn(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
    	Gload.checkLogin(this);
        pr = (FrmMain)owner;
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            this.setBounds((Gload.de.width - 400)/2, (Gload.de.height-340)/2, 400, 340);
            this.setResizable(false);
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public FrmReturn() {
        this(new Frame(), "FrmReturn", false);
    }

    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        t2.setBorder(titledBorder2);
        t2.setBounds(new Rectangle(13, 243, 371, 62));
        t1.setBorder(titledBorder1);
        t1.setBounds(new Rectangle(11, 69, 375, 170));
        t1.setBackground(this.getContentPane().getBackground());
        t2.setBackground(this.getContentPane().getBackground());
        jButton2.addActionListener(this);
        jButton1.addActionListener(this);
        jTextField2.setBounds(new Rectangle(48, 7, 253, 20));
        jLabel3.setText("书号:");
        jLabel3.setBounds(new Rectangle(6, 4, 37, 29));
        jButton2.setBounds(new Rectangle(309, 5, 78, 22));
        jButton2.setText("查 看");
        jTextField1.setBounds(new Rectangle(48, 34, 255, 21));
        jLabel2.setText("读者号：");
        jLabel2.setBounds(new Rectangle(4, 33, 53, 21));
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(t1);
        this.getContentPane().add(t2);
        this.getContentPane().add(jTextField2);
        jButton1.setBounds(new Rectangle(310, 34, 77, 21));
        jButton1.setEnabled(false);
        jButton1.setText("还 书");
    }

    JTextArea t2 = new JTextArea();
    JButton jButton1 = new JButton();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JButton jButton2 = new JButton();
    JLabel jLabel3 = new JLabel();
    JTextArea t1 = new JTextArea();
    JTextField jTextField2 = new JTextField();
    TitledBorder titledBorder1 = new TitledBorder("图书信息");
    TitledBorder titledBorder2 = new TitledBorder("读者信息");
    
    public void actionPerformed(ActionEvent e) {
        Object o = e.getSource();
        if (o.equals(this.jButton1)) {
        	this.jButton1_actionPerformed(e);
        } else if (o.equals(this.jButton2)) {
        	this.jButton2_actionPerformed(e);
        }
    }
    
    private int bid = -1, rid = -1;
    public void jButton2_actionPerformed(ActionEvent e) {
    	String s1, s2;
    	s2 = Gload.getText(this.jTextField1);
    	s1 = Gload.getText(this.jTextField2);
    	if (s1.equals("")) {
    		Gload.MSG(this, "请输入书号!");
    		return;
    	}
    	try { this.bid = Integer.parseInt(s1); }
    	catch(Exception e1) {
    		Gload.MSG(this, "书号不正确!");
    		return;
    	}
    	if (s2.equals("")) {
    		Gload.MSG(this, "请输入读者号!");
    		return;
    	}
    	try {
    		this.rid = Integer.parseInt(s2);
    	} catch(Exception e1) {
    		Gload.MSG(this, "读者号不正确!");
    		return;
    	}
    	System.out.println(s1 + " : " + s2);
    	ResultSet rs = Conn.query("select id from 借书 where 书号=" + s1 + " and 读者号=" + s2);
    	try {
    		if (!rs.next()) {
    			Gload.MSG(this, "该读者没有借此书!");
    			rs.close();
    			return;
    		}
			rs.close();
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
    	t1.setText(Conn.getBookInfo(s1));
    	t2.setText(Conn.getReader(s2));
    	this.jButton1.setEnabled(true);
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        //借出
    	this.jButton1.setEnabled(false);
    	if (Gload.NO == Gload.Confirm(this, "确认还书吗?"))
    		return;
    	Conn.exec("delete from 借书 where 书号=" + this.bid + " and 读者号=" + this.rid);
    	Conn.exec("insert into 运行记录(书号,操作,备注) values(" + this.bid + ", '还书', '读者号:" + this.rid + "')");
    	Conn.exec("update 图书状态 SET 库存=库存+1, 借出=借出-1 where 书号=" + bid);
    	Gload.MSG(this, "操作成功!");
    	pr.initBook();
    	this.dispose();
    }
}