jieshuframe.java

java 编写的图书管理系统源代码 密码和用户名都是123

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Date;
import javax.swing.*;
public class JieShuFrame 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 JieShuFrame() throws Exception
	{
		super("借书窗口");
		setSize(400,300);
		setLayout(null);
		setBackground(new Color(110,200,150));
		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:Library";

    	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 TSB where 图书编号 ='"+textField2.getText()+"'" );
							if(rs.next())
							{	
	                     		rs = stmt.executeQuery("select * from LLZB where 借阅者编号 ='"+textField1.getText()+"'" );
								if(rs.next())
								{	
										
            				stmt.execute("insert into JHB(借阅者编号,图书编号,借书日期) values ('" +
            				textField1.getText() + "','" + textField2.getText() + "','" +
            				today.toString()+ "')");
                            rs = stmt.executeQuery("select * from TSB where 图书编号 ='"+textField2.getText()+"'" );
							if(rs.next()){
							s=rs.getInt("数量");
							
                            s=s-1;
                           	if(s>=0){
                            stmt.execute(
            				"update TSB set 数量='"+s+"' where 图书编号='"+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("");
                 }

	}
}