managerwindow.java

图书馆的图书管理系统！ 图书查询

package labraryManager;
import javax.swing.*;
import javax.swing.border.EmptyBorder;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class ManagerWindow extends JFrame implements ActionListener{
	public static final int WIDTH=500;
    public static final int HEIGHT=300;
    public static final int VERTICAL_STRUT_SIZE=100;
    private static String s1="";
    private static String s2="";
    JTextField t1;
    JTextField t2;
    public ManagerWindow(String s){
    	setSize(WIDTH,HEIGHT);
    	setDefaultCloseOperation(WindowConstants.DO_NOTHING_ON_CLOSE);
    	addWindowListener(new WindowDestroyer());
    	setTitle("图书管理系统");
    	Container x=getContentPane();
    	
    	x.setLayout(new BorderLayout());
    	JLabel z1=new JLabel("操作员号码");
    	JLabel z2=new JLabel("操作员口令");
    	t1=new JTextField(29);
    	t2=new JPasswordField(16);
    	
    	
    	JPanel m1=new JPanel();
    	
    	m1.setLayout(new FlowLayout());
    	m1.add(z1);
    	m1.add(t1);
    	m1.setBorder(new EmptyBorder(100,0,0,0));
    	x.add(m1,BorderLayout.NORTH);
    	JPanel m2=new JPanel();
    	
    	m2.setLayout(new FlowLayout());
    	m2.add(z2);
    	m2.add(t2);
    	m2.setBorder(new EmptyBorder(0,0,0,0));
    	
    	JPanel y=new JPanel();
    	x.add(m2,BorderLayout.CENTER);
    	
    	y.setLayout(new FlowLayout());
    	JButton b1=new JButton("确定");
    	if(s.equals("图书流通"))
    	{
    		b1.setActionCommand("1");
    	}
    	else if(s.equals("系统操作"))
    	{
    		b1.setActionCommand("2");
    	}
    	b1.addActionListener(this);
    	y.add(b1);
    	JButton b2=new JButton("取消");
    	
    	b2.addActionListener(this);
    	y.add(b2);
    	x.add(y,BorderLayout.SOUTH);
    }
    public void actionPerformed(ActionEvent e){
        if(e.getActionCommand().equals("1"))
        	
        {
        	if (t1.getText().trim().equals("")) 
        	{
        		JOptionPane.showMessageDialog(null, "请先输入管理员帐号");
        	} 
        	else {
        	    s1=t1.getText().trim();
        	    s2=t2.getText().trim();
        		
        	    String s3="";
        	    int count=0;
        	    DataBase_Sever d=new DataBase_Sever();
        	    d.select("administer", "where Account='"+s1+"'");
        	    try{
    			
    			    while(d.rs.next()){
    				    s3=d.rs.getString("Password");
    				    Main.level=Integer.parseInt(d.rs.getString("WorkerLevel"));
    				    count++;
    		        }
    	            d.rs.close();
    		        }catch(SQLException ex1){}
    		    d.closeDB();
    		    if(count==0)
    		    {
        		    JOptionPane.showMessageDialog(null, "帐号不存在");
        		    t1.setText("");
        		    t2.setText("");
        	    } 
    		    else
    		    {
    			    if(s2.equals(s3)){
    				    CirculateWindow manager=new CirculateWindow();
	                    manager.setVisible(true);
	                    Main.entered=true;
	                    Main.manager=s1;
	                    Main.pass=s2;
	                    dispose();
	                    }
    			    else{
    				    JOptionPane.showMessageDialog(null, "密码错误");
        		        t1.setText("");
        		        t2.setText("");
        		        }
    		    }
        	}
	    }
        else if(e.getActionCommand().equals("2"))
        {
        	if (t1.getText().trim().equals("")) 
        	{
        		JOptionPane.showMessageDialog(null, "请先输入管理员帐号");
        	} 
        	else {
        	    s1=t1.getText().trim();
        	    s2=t2.getText().trim();
        		
        	    String s3="";
        	    int count=0;
        	    DataBase_Sever d=new DataBase_Sever();
        	    d.select("administer", "where Account='"+s1+"'");
        	    try{
    			
    			    while(d.rs.next()){
    				    s3=d.rs.getString("Password");
    				    Main.level=Integer.parseInt(d.rs.getString("WorkerLevel"));
    				    count++;
    		        }
    	            d.rs.close();
    		        }catch(SQLException ex1){}
    		    d.closeDB();
    		    if(count==0)
    		    {
        		    JOptionPane.showMessageDialog(null, "帐号不存在");
        		    t1.setText("");
        		    t2.setText("");
        	    } 
    		    else
    		    {
    			    if(s2.equals(s3)){
    			    	SystemManageWindow x=new SystemManageWindow();
    			        x.setVisible(true);
    			        Main.entered=true;
    			        Main.manager=s1;
    			        Main.pass=s2;
    			        dispose();
	                    }
    			    else{
    				    JOptionPane.showMessageDialog(null, "密码错误");
        		        t1.setText("");
        		        t2.setText("");
        		        }
    		    }
        	}
    		
        	
	    }
        else if(e.getActionCommand().equals("取消"))
        {MainWindow x=new MainWindow();
	    x.setVisible(true);
	    dispose();
	    }
    	else
    		System.out.println("Error!");
    }
}