find_reader.java

简易图书管理样板 其他功能仿照即可 小弟能力有限

import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
class find_reader extends JFrame implements ActionListener
{
	JLabel _ID;
	JTextField ID;
	JButton ID_true;
	JButton ID_false;
	JTextArea msg;
	Connection con1;
	Statement sql;
	ResultSet rs;
	int a=0;
	find_reader()
	{
		super("信息查询");
		Toolkit tool=getToolkit();
		Dimension dim=tool.getScreenSize();
		setBounds(dim.width/2-100,dim.height/2-100,200,200);
		//setSize(200,200);
		//setBounds(540,300,200,200);
		setResizable(false);
		setVisible(true);
		FlowLayout con=new FlowLayout();
		setLayout(con);
		_ID=new JLabel("读者编号：");
		ID=new JTextField(10);
		ID_true=new JButton("查询");
		ID_true.addActionListener(this);
		ID_false=new JButton("取消");
		ID_false.addActionListener(this);
		msg=new JTextArea(5,18);
		add(_ID);
		add(ID);
		add(msg);
		add(ID_true);
		add(ID_false);
		msg.setEditable(false);
		validate();	
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==ID_true)
		{
		try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			}
		catch(ClassNotFoundException e1)
		{
			System.out.println(""+e1);
		}
		
		try{ con1=DriverManager.getConnection("jdbc:odbc:book","admin","111111");
			sql=con1.createStatement();
			rs=sql.executeQuery("select * from reader where number='"+ID.getText()+"'");
			while(rs.next())
			{
				String number=rs.getString(1);
				String name=rs.getString(2);
				String limit=rs.getString(3);
				String type=rs.getString(4);
				System.out.print(" "+number+" "+name+" "+limit+" "+type);
				System.out.println();
				msg.setText("  编号 "+"  姓名 "+"  限借数量 "+"  类型"+"\n"+"   "+number+"  "+name+"  "+limit+"  "+type+"\n");
			}
			con1.close();
			}
			catch(SQLException e2)
			{
				System.out.println(e2);
			}
	
	     }
	     //else
	     	//JOptionPane.showMessageDialog(null,"用户不存在!");
	     if(e.getSource()==ID_false)this.dispose();
	}
}