loan_book.java~1~

一个简单的图书管理系统

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Date;
import javax.swing.*;
public class Loan_book extends Frame implements ActionListener
{
	 Label label1 = new Label("借阅者编号");
  	TextField textField1 = new TextField();
  	Label label2 = new Label("图书编号");
  	TextField textField2 = new TextField();
  	Button button1 = new Button("提交");
 	 Button button2 = new Button("重置");
  	Label label3 = new Label();
 		
	Connection conn;
  	Statement stmt;
  	ResultSet rs;  
    	String strurl;

	Date today=new Date();
	public Loan_book() throws Exception
	{
		super("借书窗口");
		setSize(400,300);
		setLayout(null);
		setBackground(new Color(0,100,255));
		this.setLocation(200,200);
    label1.setBounds(68, 70, 79, 23);
    textField1.setBounds(68, 101, 107, 25);
    label2.setBounds(212, 65, 73, 26);
    textField2.setBounds(212, 98, 114, 26);
    button1.setBounds(70, 171, 99, 25);
	button1.addActionListener(this);
    button2.setBounds(209, 170, 103, 28);
        button2.addActionListener(this);
	
    label3.setBounds(209, 223, 59, 32);
    add(button1);
    add(button2);
    add(textField2);
    add(label1);
    add(textField1);
    add(label2);
    add(label3);
	textField1.getCursor();

	strurl ="jdbc:odbc:book";

    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    	conn = DriverManager.getConnection(strurl);
    	stmt = conn.createStatement();



		setVisible(true);
		addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				dispose();
				setVisible(false);
			}
		}); 
	}
	public void actionPerformed(ActionEvent e)
	{
		String str=e.getActionCommand();
		String str1;
		int s;
		if (str.equals("提交"))
		{

			if (textField1.getText().equals(" "))
			{
				label3.setText("不能为空");
			}	
			else
			{        

	
				try{ 
                            rs = stmt.executeQuery("select * from add_book where idd ='"+textField2.getText()+"'" );
							if(rs.next())
							{	
	                     		rs = stmt.executeQuery("select * from add_people where id ='"+textField1.getText()+"'" );
								if(rs.next())
								{	
										
            				stmt.execute("insert into Loan_book(id,idd,loan_time) values ('" +
            				textField1.getText() + "','" + textField2.getText() + "','" +
            				today.toString()+ "')");
                            rs = stmt.executeQuery("select * from add_book where idd ='"+textField2.getText()+"'" );
							if(rs.next()){
							s=rs.getInt("shuliang");
							
                            s=s-1;
                           	if(s>=0){
                            stmt.execute(
            				"update add_book set shuliang='"+s+"' where idd='"+textField2.getText()+"'"); 
        					JOptionPane.showMessageDialog(null, "借书成功",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
        					label3.setText("借书成功");
                                        textField1.setText("");
                                        textField2.setText("");
                                    }
                                    else{
        								JOptionPane.showMessageDialog(null, "无书可借",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
                                      	textField1.setText("");
                                      	textField2.setText("");
                                      }
                                    }
                            	}
                       
                        	else{
                    			JOptionPane.showMessageDialog(null, "无此人",  "提示",
                    			JOptionPane.WARNING_MESSAGE);     
                    			textField1.setText("");
                                textField2.setText("");       	
                        		}
                        	 }
                            else{
        					JOptionPane.showMessageDialog(null, "没有此书",  "提示",
                    		JOptionPane.WARNING_MESSAGE);
                            textField1.setText("");
                            textField2.setText("");
                            }
                            
					}

	      			catch (Exception eg) {
        			JOptionPane.showMessageDialog(null, "借书失败",  "提示",
                    JOptionPane.WARNING_MESSAGE);
			eg.printStackTrace();
			}

			}
		}
                if(str.equals("重置"))
                {
                     textField1.setText("");
                 }

	}
}