returnbookfrm.java

用Java实现的图书馆的管理系统

import java.util.*;
import java.awt.*;
import java.io.*;
import java.net.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.Date;

class Returnbookfrm extends JFrame implements ActionListener {
	JLabel l_msg, l_user, l_bookid, l_data, l_beizhu;
	JTextField t_user, t_bookid, t_data, t_beizhu;
	JButton b_enter, b_clear, b_back;
	JPanel pan1, pan2, pan3, pan4, pan5, pan6;

	Date d;
	Statement s;

	Returnbookfrm() {
		l_msg = new JLabel("还书窗口    ");
		l_user = new JLabel("还书者：");
		l_bookid = new JLabel("书编号：");
		l_data = new JLabel("日  期：");
		l_beizhu = new JLabel("备  注：");
		t_user = new JTextField("", 12);
		t_bookid = new JTextField("", 12);
		t_data = new JTextField("", 12);
		d = new Date();
		t_data.setText(d.toLocaleString());
		t_beizhu = new JTextField("", 12);
		b_enter = new JButton("确定");
		b_clear = new JButton("清除");
		b_back = new JButton("返回");
		b_enter.addActionListener(this);
		b_clear.addActionListener(this);
		b_back.addActionListener(this);
		pan1 = new JPanel();
		pan2 = new JPanel();
		pan3 = new JPanel();
		pan4 = new JPanel();
		pan5 = new JPanel();
		pan6 = new JPanel();
		pan1.add(l_msg);
		pan2.add(l_user);
		pan2.add(t_user);
		pan3.add(l_bookid);
		pan3.add(t_bookid);
		pan4.add(l_data);
		pan4.add(t_data);
		pan5.add(l_beizhu);
		pan5.add(t_beizhu);
		pan6.add(b_enter);
		pan6.add(b_clear);
		pan6.add(b_back);
		setLayout(new GridLayout(6, 1));
		add(pan1);
		add(pan2);
		add(pan3);
		add(pan4);
		add(pan5);
		add(pan6);
		setBounds(400, 100, 400, 500);

	}

	public void actionPerformed(ActionEvent ed) {
		String JDriver = "sun.Jdbc.Odbc.JdbcOdbcDriver";
		String conURL = "jdbc:odbc:abc";
		try {
			Class.forName(JDriver);
		} catch (java.lang.ClassNotFoundException e1) {
			System.out.println("forname:" + e1.getMessage());
		}
		try {
			Connection con = DriverManager.getConnection(conURL);
			s = con.createStatement();
		} catch (SQLException e1) {
			System.out.println("SQLException:" + e1.getMessage());
		}
		if (ed.getSource() == b_back) {
			if (ed.getSource() == b_back) {
				dispose();
			}
		} else if (ed.getSource() == b_clear) {
			t_user.setText("");
			t_beizhu.setText("");
			t_bookid.setText("");
		} else if (ed.getSource() == b_enter) {
			try {
				String a1 = "'" + t_data.getText() + "'";
				String a2 = "'" + t_beizhu.getText() + "'";
				String a3 = "'" + t_user.getText() + "'";
				String a4 = "'" + t_bookid.getText() + "'";
				String a5 = "'" + "Yes" + "'";
				String temp = "update bookbrowse set returndata =" + a1
						+ ", isreturn =" + a5 + ", beizhu =" + a2
						+ " where username =" + a3+" and bookid="+a4;
						
				s.executeUpdate(temp);
				l_msg.setText("还书成功");
			} catch (SQLException eg) {
			}
		}
	}
}