register.java

用JAVA做的图书借阅信息系统

import java.sql.*;
import java.awt.*;
import java.awt.event.*;
public class Register extends FrameClass implements ActionListener
{ 
	Label l1,l2,l3;
	TextField t1,t2,t3;
	Button 清空,确定,退出;
	Connection con;
    Statement sql;
    ResultSet rs;
	boolean flag1,flag2;
	String reader_name,reader_num,book_num,book_name,borrow_date,return_date,notice;
	String s1,s2,s3,s4,s5,s6,s7,reader_num1;
	Register()	
    {
		super("新读者登记窗口");
		setBounds(150,130,500,300);
		l1=new Label("新读者编号：");
		l2=new Label("新读者姓名：");
		l3=new Label("      备注：");
		t1=new TextField(" ",20);
		t2=new TextField(" ",20);
		t3=new TextField(" ",20);
		清空=new Button("清空");
		确定=new Button("确定");
		退出=new Button("退出");
		清空.addActionListener(this);
		确定.addActionListener(this);
	    退出.addActionListener(this);
	    add(l1);add(l2);add(l3);
		add(t1);add(t2);add(t3);
		add(清空);add(确定);add(退出);
		message.setBounds(160,40,230,25);
		l1.setBounds(90,80,80,25);t1.setBounds(180,80,200,25);
		l2.setBounds(90,110,80,25);t2.setBounds(180,110,200,25);
		l3.setBounds(90,140,80,25);t3.setBounds(180,140,200,25);
		清空.setBounds(170,230,50,25);确定.setBounds(220,230,50,25);退出.setBounds(270,230,50,25);
		setVisible(true);
		validate();
		try
	    {
	        Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");
	    }
        catch(ClassNotFoundException e1)
	    {
			setMessage("无法连接到数据库！",5000);
			this.dispose();
	    }
        try
		{
			con=DriverManager.getConnection("jdbc:odbc:book","","");
			sql=con.createStatement();
		}
		catch(SQLException e2)
		{
			setMessage("没有找到数据库！",3000);
			this.dispose();
		}
	    addWindowListener(new WindowAdapter(){public void windowClosing(WindowEvent e)
		    {
			  setVisible(false);
			  dispose();
		}});
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==确定)
		{
			flag1=true;
			flag2=true;
			reader_num=t1.getText().trim();
			reader_name=t2.getText().trim();
			notice=t3.getText().trim();
			if((reader_num.equals(""))||(reader_name.equals("")))
			{
				flag1=false;
				setMessage("新读者编号及姓名不能为空！",5000);
			}
			reader_num1="'"+reader_num+"'";
			//按新读者编号在读者库中查找,如找到就说明与其他读者编号重号
			try
			{
				rs=sql.executeQuery("SELECT *FROM 读者信息表 WHERE 读者编号="+reader_num1);
				while(rs.next())
     			{//找到了
	    			flag2=false;
					setMessage("该编号已被他人使用！",5000);
	    		}
			}
			catch(SQLException e3){}
			//没有找到,是一个新读者,进行登记操作
	    	if((flag1==true)&&(flag2==true))
    		{	
				try
				{
					if(notice.trim().equals(""))
					{
						notice=" ";
					}
					book_num=" ";
					book_name=" ";
					borrow_date=" ";
					return_date=" ";
					s1="'"+reader_num+"'";
     				s2="'"+reader_name+"'";
					s3="'"+book_num+"'";
					s4="'"+book_name+"'";
					s5="'"+borrow_date+"'";
					s6="'"+return_date+"'";
					s7="'"+notice+"'";
	    			sql.executeUpdate("INSERT INTO 读者信息表 VALUES("+s1+","+s2+","+s3+","+s4+","+s5+","+s6+","+s7+")");
					setMessage("该读者登记完毕！",5000);
					t1.setText(" ");
					t2.setText(" ");
					t3.setText(" ");
				}
				catch(SQLException e5){}
		    }
		}
		if(e.getSource()==清空)
		{
			t1.setText(" ");
			t2.setText(" ");
			t3.setText(" ");
		}
		if(e.getSource()==退出)
		{
			try
			{
				con.close();
			}
			catch(SQLException e4){}
			setVisible(false);
			dispose();
		}
	}
}