glyzhuceframe.java

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

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class GLYZhuCeFrame extends Frame implements ActionListener,ItemListener
{
  	Label label1 = new Label("员工编号");
 	Label label2 = new Label("用户名");
  	Label label3 = new Label("密码");

  	TextField textField1 = new TextField();
  	TextField textField2 = new TextField();
  	TextField textField3 = new TextField();
   	Button button1 = new Button("确定");
  	Button button2 = new Button( "取消");
  	Label label5 = new Label("用户类型");
  	TextField textField4 = new TextField();
	Choice choice1=new Choice();
	  	Connection conn;
  	Statement stmt;
  	ResultSet rs;  
    	String strurl;
	int n;
	public GLYZhuCeFrame() throws Exception
	{
                super("管理员注册窗口");
		setSize(400,300);
		setLayout(null);
		setBackground(new Color(110,200,150));
				this.setLocation(200,200);
		addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				dispose();
				setVisible(false);
			}
		}); 
  	 choice1.add("普通用户");
  	choice1.add("超级用户");
    	label1.setBounds(96, 74, 79, 16);
    	label2.setBounds(96, 118, 76, 16);
    	label3.setBounds(96, 157, 75, 16);
    	textField1.setBounds(181, 74, 102, 24);
    	textField2.setBounds(181, 116, 104, 23);
    	textField3.setEchoChar('*');
    	textField3.setBounds(181, 153, 105, 24);
    	button1.setBounds(81, 235, 89, 27);
	button1.addActionListener(this);
    	button2.setBounds(209, 238, 95, 25);
    	label5.setBounds(96, 188, 74, 18);
    	choice1.setBounds(181, 188, 103, 23);
	choice1.addItemListener(this);
        button2.addActionListener(this);
    	add(textField3);
    	add(textField2);
   	add(textField1);
    	add(label1);
    	add(label2);
   	add(label3);
    	add(button1);
    	add(button2);
   	add(label5);
    	add(choice1);


    	strurl ="jdbc:odbc:Library";

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

		setVisible(true);
	}
	public void actionPerformed(ActionEvent e)
	{
		String str=e.getActionCommand();
		if (str.equals("确定"))
		{
			if(n==0){
			if(textField1.getText().equals(""))
			{
				//dialog.setVisible(true);
			}
			else{
			try
			{
			 rs = stmt.executeQuery("select * from GLYB where 员工编号 ='"+textField1.getText()+"'" );
			if(rs.next()){
        				JOptionPane.showMessageDialog(null, "员工ID存在重新输入",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
				textField1.setText("");
				textField2.setText("");
				textField3.setText("");	
			}	
			else{
			 rs = stmt.executeQuery("select * from GLYB where 用户名 ='"+textField2.getText()+"'" );
			if(rs.next()){
        				JOptionPane.showMessageDialog(null, "用户名存在重新输入",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
				textField1.setText("");
				textField2.setText("");
				textField3.setText("");	
			}	
			else{			
       			stmt.execute(
            			"insert into GLYB(员工编号,用户名,密码) values ('" +
            			textField1.getText() + "','" + textField2.getText() + "','" +
            			textField3.getText()+ "')");
        				JOptionPane.showMessageDialog(null, "添加成功",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);			
                textField1.setText("");
				textField2.setText("");
				textField3.setText("");	
				}
				}	
						
			}
      			catch (Exception eg) {
        				JOptionPane.showMessageDialog(null, "添加失败",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
			eg.printStackTrace();
			}
			}
			}
			else
			{
			if(textField1.getText().equals(""))
			{
        				JOptionPane.showMessageDialog(null, "不能为空",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
			}
			else{
			try
			{
			 rs = stmt.executeQuery("select * from CJGLYB where 员工编号 ='"+textField1.getText()+"'" );
			if(rs.next()){
        				JOptionPane.showMessageDialog(null, "员工ID存在重新输入",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
				textField1.setText("");
				textField2.setText("");
				textField3.setText("");	
			}
			else{				
       			stmt.execute(
            			"insert into CJGLYB(员工编号,用户名,密码) values ('" +
            			textField1.getText() + "','" + textField2.getText() + "','" +
            			textField3.getText()+ "')");

        				JOptionPane.showMessageDialog(null, "添加成功",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
				textField1.setText("");
				textField2.setText("");
				textField3.setText("");
		
				}		
			}
      			catch (Exception eg) {
        				JOptionPane.showMessageDialog(null, "添加失败",  "提示",
                                      	JOptionPane.WARNING_MESSAGE);
			eg.printStackTrace();
			}
			}			
			}

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

}