addbook.java

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

import java.awt.*;
import java.sql.*;
import java.awt.event.*;
public class AddBook extends FrameClass implements ActionListener
{ 
	Label l1,l2,l3,l4,l5,l6,l7;
	TextField t1,t2,t3,t4,t5,t6,t7;
	Button add_button,exit_button;
	Connection con;
    Statement sql;
    ResultSet rs;
	String s1,s2,s3,s4,s5,s6,s7;
	double price;
	boolean b=false;
	AddBook()	
    {
		super("书籍信息输入窗口");
		setBounds(150,100,500,350);
		setVisible(true);
		setLayout(null);
		l1=new Label("      标识：");
		l2=new Label("      书名：");
		l3=new Label("    出版社：");
		l4=new Label("出版社地址：");
		l5=new Label("      作者：");
		l6=new Label("  出版日期：");
		l7=new Label("      单价：");
		t1=new TextField(" ",20);
		t2=new TextField(" ",20);
		t3=new TextField(" ",20);
		t4=new TextField(" ",20);
		t5=new TextField(" ",20);
		t6=new TextField(" ",20);
		t7=new TextField("0",20);
		add_button=new Button("添加");
		exit_button=new Button("退出");
		add(l1);add(t1);
		add(l2);add(t2);
		add(l3);add(t3);
		add(l4);add(t4);
		add(l5);add(t5);
		add(l6);add(t6);
		add(l7);add(t7);
		add(add_button);
		add(exit_button);
		t1.addActionListener(this);
		t2.addActionListener(this);
		t3.addActionListener(this);
		t4.addActionListener(this);
		t5.addActionListener(this);
		t6.addActionListener(this);
		t7.addActionListener(this);
		add_button.addActionListener(this);
		exit_button.addActionListener(this);
		l1.setBounds(80,30,70,25);
		t1.setBounds(155,30,200,25);
		l2.setBounds(80,60,70,25);
		t2.setBounds(155,60,200,25);
		l3.setBounds(80,90,70,25);
		t3.setBounds(155,90,200,25);
		l4.setBounds(80,120,70,25);
		t4.setBounds(155,120,200,25);
		l5.setBounds(80,150,70,25);
		t5.setBounds(155,150,200,25);
		l6.setBounds(80,180,70,25);
		t6.setBounds(155,180,200,25);
		l7.setBounds(80,210,70,25);
		t7.setBounds(155,210,200,25);
		add_button.setBounds(160,270,70,30);
		exit_button.setBounds(280,270,70,30);
		message.setBounds(170,240,160,30);
		l1.transferFocus();
		validate();
		try
	    {
	        Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");
	    }
        catch(ClassNotFoundException e1)
	    {
	        setMessage("无法连接到数据库！",5000);
			dispose();
	    }
        try
		{
			con=DriverManager.getConnection("jdbc:odbc:book","","");
			sql=con.createStatement();
		}
		catch(SQLException e2)
		{
			setMessage("没有找到数据库！",5000);
			dispose();
		}
		addWindowListener(new WindowAdapter(){public void windowClosing(WindowEvent e)
		    {
			  setVisible(false);
			  dispose();
			}});
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==t1)
		{
			if(t1.getText().trim().length()==0)
			{
				setMessage("标识不能为空！",3000);
				l1.transferFocus();
			}
			else
				t1.transferFocus();
		}
		if(e.getSource()==t2)
		{
			if(t2.getText().trim().length()==0)
			{
				setMessage("书名不能为空！",3000);
				t1.transferFocus();				
			}
			else
				t2.transferFocus();
		}
		if(e.getSource()==t3)
		{
			t3.transferFocus();
		}
		if(e.getSource()==t4)
		{
			t4.transferFocus();
		}
		if(e.getSource()==t5)
		{
			t5.transferFocus();
		}
		if(e.getSource()==t6)
		{
			t6.transferFocus();
		}
		if(e.getSource()==t7)
		{
			try
			{
				price=Double.valueOf(t7.getText()).doubleValue();
				t7.transferFocus();	
			}
			catch(NumberFormatException e3)
			{
				setMessage("单价应输入数字字符！",3000);
				t6.transferFocus();
				t7.setText("");
			}
		}		
		if(e.getSource()==add_button)
		{
			boolean bb=true;
   			s1="'"+t1.getText().trim()+"'";
			try
			{
				rs=sql.executeQuery("SELECT * FROM 书籍信息表 WHERE 标识="+s1);
				while(rs.next())
				{
					setMessage("该编号已被其它书使用!",3000);
					t1.setText(" ");
		    	    t2.setText(" ");
		         	t3.setText(" ");
		    	    t4.setText(" ");
		        	t5.setText(" ");
		        	t6.setText(" ");
		        	t7.setText("0");
		        	l1.transferFocus();
					bb=false;
				}
			}
			catch(SQLException e4){}
			if(bb&&(t1.getText().trim().length()!=0)&&(t2.getText().trim().length()!=0)&&(Double.valueOf(t7.getText()).doubleValue()>0))
			{
    			s1="'"+t1.getText().trim()+"'";
	    		s2="'"+t2.getText().trim()+"'";
		    	s3="'"+t3.getText().trim()+"'";
			    s4="'"+t4.getText().trim()+"'";
		    	s5="'"+t5.getText().trim()+"'";
		    	s6="'"+t6.getText().trim()+"'";
				price=Double.valueOf(t7.getText()).doubleValue();
	    		try
		    	{
	    			sql.executeUpdate("INSERT INTO 书籍信息表 VALUES("+s1+","+s2+","+s3+","+s4+","+s5+","+s6+","+price+","+b+")");
					setMessage("该书数据登记完毕!",3000);
                	t1.setText(" ");
		    	    t2.setText(" ");
		         	t3.setText(" ");
		    	    t4.setText(" ");
		        	t5.setText(" ");
		        	t6.setText(" ");
		        	t7.setText("0");
		        	l1.transferFocus();
		    	}
		    	catch(SQLException e3){setMessage("没有添加该数据",3000);}
		    	t1.setText(" ");
		    	t2.setText(" ");
		    	t3.setText(" ");
		    	t4.setText(" ");
		    	t5.setText(" ");
		    	t6.setText(" ");
		    	t7.setText("0");
		    	l1.transferFocus();
			}
			else
			{
				setMessage("数据有误，没有添加该数据",3000);
			}
		}
		if(e.getSource()==exit_button)
		{
			try
			{
				con.close();
			}catch(SQLException e4){}
			dispose();
			setVisible(false);
		}
	}
}