returnmsgbookfrm.java

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

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

class ReturnMsgbookfrm extends JFrame implements ActionListener {
	JLabel l_msg, l_yonghu, l_huanshuzhe, l_bookname, l_data, l_bookid;
	JTextField t_huanshuzhe, t_yonghu, t_bookname, t_data, t_bookid;
	JButton b_enter, b_clear, b_update, b_back;
	JPanel pan1, pan2, pan3, pan4, pan5, pan6, pan7;
	String a2, a3, a4, a5;

	Statement s;
	ResultSet rs;

	ReturnMsgbookfrm() {
		l_msg = new JLabel("还书信息修改窗口    ");
		l_huanshuzhe = new JLabel("还书者：");
		l_yonghu = new JLabel("用户：");
		l_bookname = new JLabel("书  名：");
		l_data = new JLabel("日  期：");
		l_bookid = new JLabel("书的编号：");
		t_huanshuzhe = new JTextField("", 10);
		t_yonghu = new JTextField("", 10);
		t_bookname = new JTextField("", 10);
		t_data = new JTextField("", 10);
		t_bookid = new JTextField("", 10);
		b_enter = new JButton("确定");
		b_clear = new JButton("清除");
		b_update = new JButton("更新");
		b_back = new JButton("返回");
		b_enter.addActionListener(this);
		b_clear.addActionListener(this);
		b_update.addActionListener(this);
		b_back.addActionListener(this);
		pan1 = new JPanel();
		pan2 = new JPanel();
		pan3 = new JPanel();
		pan4 = new JPanel();
		pan5 = new JPanel();
		pan6 = new JPanel();
		pan7 = new JPanel();
		pan1.add(l_msg);
		pan2.add(l_huanshuzhe);
		pan2.add(t_huanshuzhe);
		pan3.add(l_bookname);
		pan3.add(t_bookname);
		pan4.add(l_data);
		pan4.add(t_data);
		pan5.add(l_bookid);
		pan5.add(t_bookid);
		pan6.add(b_clear);
		pan6.add(b_update);
		pan6.add(b_back);
		pan7.add(l_yonghu);
		pan7.add(t_yonghu);
		pan7.add(b_enter);
		setLayout(new GridLayout(7, 1));
		add(pan1);
		add(pan7);
		add(pan5);
		add(pan2);
		add(pan3);
		add(pan4);
		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) {
			this.dispose();
		} else if (ed.getSource() == b_clear) {
			t_huanshuzhe.setText("");
			t_bookid.setText("");
			t_bookname.setText("");
			t_data.setText("");
		} else if (ed.getSource() == b_enter) {
			
			try {l_msg.setText("操作失败！用户名或编号有误！");
				rs = s.executeQuery("SELECT * FROM bookbrowse where username="
								+ "'" + t_yonghu.getText() + "'" +"and bookid="+"'"+t_bookid.getText()+"'");
				
				while (rs.next()) {
					
					l_msg.setText("查询用户信息成功");
					t_huanshuzhe.setText(rs.getString(2));
					t_bookname.setText(rs.getString(3));
					t_data.setText(rs.getString(5));
					t_bookid.setText(rs.getString(1));
					
				}

			} catch (SQLException e2) {
				
			}

		} else if (ed.getSource() == b_update) {
			try {
				a2 = "'" + t_bookid.getText().trim() + "'";
				a3 = "'" + t_huanshuzhe.getText().trim() + "'";
				a4 = "'" + t_bookname.getText().trim() + "'";
				a5 = "'" + t_data.getText().trim() + "'";
				String tem = "UPDATE bookbrowse SET returndata=" 
				+ a5 +  " WHERE username=" + a3 +"and bookid="+a2;
				s.executeUpdate(tem);
				l_msg.setText("用户修改成功");
			} catch (SQLException dd) {
			}
		}
	}
}