xiaohuframe.java

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

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class XiaoHuFrame extends Frame implements ActionListener,ItemListener
{
	 Label label1 = new Label("借阅者编号起始值");
  	TextField textField1 = new TextField();
 	 TextField textField2 = new TextField();
  	Label label2 = new Label("借阅者编号终止值");

  	Label label4 = new Label("---->");
  	Button button1 = new Button("确定");
  	Button button2 = new Button("取消");
  	Label label5 = new Label("借阅者编号");
  	TextField textField3 = new TextField();


	CheckboxGroup	cg=new CheckboxGroup();
	Checkbox	dange=new Checkbox("删除单个读者",cg,true);
	Checkbox	duoge=new Checkbox("删除多个读者",cg,false);
  	Connection conn;
  	Statement stmt;
  	ResultSet rs;  
    	String strurl;

	int n;


	public XiaoHuFrame() throws Exception
	{
		super("销户窗口");
		setSize(400,350);
		setLayout(null);
	   setBackground(new Color(110,200,150));	
	   this.setLocation(200,200);
  n=1;
    label1.setBounds(90, 186, 100, 24);
    textField1.setBounds(91, 212, 77, 23);
    textField2.setBounds(229, 212, 77, 24);
	textField3.setBounds(174, 108, 83, 23);
    label2.setBounds(230, 189, 100, 18);
    duoge.setBounds(150, 161, 100, 14);
    label4.setBounds(175, 214, 45, 19);
    button1.setBounds(90, 265, 77, 24);
	button1.addActionListener(this);
    button2.setBounds(217, 265, 86, 24);
        button2.addActionListener(this);
    label5.setBounds(105, 110, 70, 20);
    
    dange.setBounds(152, 67, 100, 21);

		dange.addItemListener(this);
		duoge.addItemListener(this);

    add(button1);
    add(label4);
    add(label2);
    add(label1);
   add(label5);

   add(button2);

	add(dange);
	add(duoge);
   add(textField3);
    add(textField1);
   add(textField2);


    	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 user,pass;
		
		if (str.equals("确定"))
		{

			if(n==0){
			user=textField1.getText();
			pass=textField2.getText();
			if(textField1.getText().equals(""))
			{
        		JOptionPane.showMessageDialog(null, "不能为空", "警告",
                                      JOptionPane.WARNING_MESSAGE);
			}
			else{
			try
			{
			 rs = stmt.executeQuery("select * from LLZB where 借阅者编号='"+user+"'" );
			if(rs.next()){				
       	          	stmt.execute("DELETE * from LLZB where 借阅者编号 >='" + user+ "' AND 借阅者编号 <'" +pass + "'");

				textField1.setText("");
				textField2.setText("");
				
        		JOptionPane.showMessageDialog(null, "销户成功", "提示",
                                      JOptionPane.WARNING_MESSAGE);
				}
				else{
	         		JOptionPane.showMessageDialog(null, "不存在", "警告",
                    
			                  JOptionPane.WARNING_MESSAGE);
			     textField1.setText("");
				textField2.setText("");
			                  }
                                      
						
			}
      			catch (Exception eg) {
         		JOptionPane.showMessageDialog(null, "操作错误", "警告",
                                      JOptionPane.WARNING_MESSAGE);
			eg.printStackTrace();
			}
			}
			}
			else
			{
			
			if(textField3.getText().equals(""))
			{
        		JOptionPane.showMessageDialog(null, "不能为空", "警告",
                                      JOptionPane.WARNING_MESSAGE);
			}
			else{
			try
			{
						 rs = stmt.executeQuery("select * from LLZB where 借阅者编号='"+textField3.getText()+"'" );
			if(rs.next()){
      	          	    stmt.execute("DELETE * FROM LLZB where 借阅者编号='" + textField3.getText() +"'");
 
				 textField3.setText("");
        		JOptionPane.showMessageDialog(null, "销户成功", "提示",
                                      JOptionPane.WARNING_MESSAGE);
                             }
                             else{
                             	       JOptionPane.showMessageDialog(null, "数据不存在", "提示",
                                      JOptionPane.WARNING_MESSAGE);
                                       textField3.setText("");
                                    }
			}


      			catch (Exception eg) {
        		JOptionPane.showMessageDialog(null, "操作错误", "警告",
                                      JOptionPane.WARNING_MESSAGE);
			eg.printStackTrace();
			}
			}			
			}

		}
                if(str.equals("取消"))
                {
                    setVisible(false);
                 }
	
	}
	public void itemStateChanged(ItemEvent e)
	{
		if(e.getItemSelectable()==dange)
		{
			n=1;
		}
		else
		{
			n=0;
		}
			
	}
}