⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 loginframe.java

📁 利用JAVA的界面对MS SQL进行操作,实现了学生管理系统基本功能:登陆,录入,查询,删除,修改,内置程序详细讲解.
💻 JAVA
📖 第 1 页 / 共 5 页
字号:
    int iAge;
    
  //  Statist dlg;
    proceeSQL psql;

    Insert(JFrame f,String s,boolean b){
   
   	psql = new proceeSQL();
		
	 jdl=new JDialog(f,s,b);
	//k dlg=new Statist(f,"浏览",false);
	 
     jdl.setSize(320,380); 
     jdl.setLocation(350,240);    
     jdl.addWindowListener(new WindowAdapter()
      {public void windowClosing(WindowEvent e)
       {
        jdl.setVisible(false);
       }});
       
    
     Classes = new Choice();
     
     for(int i=0;i<4;i++)
     {
     	Classes.addItem("计科"+(i+1)+"班");
     }
     choice = new Choice();
       for(int i=10;i<30;i++)
         choice.addItem(""+i); 
     name=new TextField("",8);
     id=new TextField("",8);
     homeAddress=new TextField("",8);
     telNum=new TextField("",8);
     btn_receave=new JButton("添加");
     btn_statist=new JButton("浏览"); 
     pnl=new JPanel();

     sex.add(jrb_male);
     sex.add(jrb_female);
     pnl.add(jrb_male);
     pnl.add(jrb_female);
     jrb_male.addItemListener(this);
     jrb_female.addItemListener(this);
     choice.addItemListener(this);
     Classes.addItemListener(this);
     iAge = choice.getSelectedIndex()+10;
     iClass = Classes.getSelectedItem();
     
     Fmenubar=new JMenuBar();
     fileMenu=new JMenu("文件");
     editMenu=new JMenu("编辑");
     helpMenu=new JMenu("帮助");     
     item_receave=new JMenuItem("添加"); 
     item_statist=new JMenuItem("浏览");
     Fitem_exit=new JMenuItem("退出");
     item_save=new JMenuItem("保存");
     item_open=new JMenuItem("打开");
     item_clear=new JMenuItem("清空");
     item_about=new JMenuItem("学生信息管理系统");
     fileMenu.add(item_receave);
     fileMenu.add(item_statist); 
     fileMenu.addSeparator();
     fileMenu.add(Fitem_exit);
     helpMenu.add(item_about);
     editMenu.add(item_clear);
     Fmenubar.add(fileMenu);
     Fmenubar.add(editMenu);
     Fmenubar.add(helpMenu);
     jdl.setJMenuBar(Fmenubar);
  
     item_clear.addActionListener(this);
     item_about.addActionListener(this);
     name.addTextListener(this);
     id.addTextListener(this);
     homeAddress.addTextListener(this);
     telNum.addTextListener(this);
     
     
   	 item_save.addActionListener(this);
   	 item_open.addActionListener(this);
     btn_receave.addActionListener(this);
     btn_statist.addActionListener(this);
   
     jdl.add(new JLabel("学号",JLabel.CENTER));
     jdl.add(id);
     jdl.add(new JLabel("姓名",JLabel.CENTER));
     jdl.add(name);
     jdl.add(new JLabel("姓别",JLabel.CENTER));
     jdl.add(pnl);
     jdl.add(new JLabel("班级",JLabel.CENTER));
     jdl.add(Classes);
     jdl.add(new JLabel("年龄",JLabel.CENTER));
     jdl.add(choice);
     jdl.add(new JLabel("家庭住址",JLabel.CENTER));
     jdl.add(homeAddress);
     jdl.add(new JLabel("电话号码",JLabel.CENTER)); 
     jdl.add(telNum);
     jdl.add(new JLabel("创建密码:",JLabel.CENTER));
     jdl.add(newPasswordField);
     jdl.add(new JLabel("确认密码:",JLabel.CENTER));
     jdl.add(confirmNewPasswordField);
     jdl.add(btn_receave);
     jdl.add(btn_statist);
     jdl.setLayout(new GridLayout(10,2,20,9));
     //fam.setVisible(true);
     jdl.setResizable(false);
     
     
	}
	
   public void actionPerformed(ActionEvent e){
     if(e.getSource()==Fitem_exit){//添加保存信息
      	System.exit(0);
      }
         
    //监听录取按扭
    else if(e.getSource()==item_receave||e.getSource()==btn_receave){ 
      	
    	if(name.getText().equals("")||id.getText().equals(""))
    	{
    	JOptionPane.showMessageDialog(null, "学号或姓名不能为空!");
    	return;
    	}
    	
    	newPass=new String(newPasswordField.getPassword());
    	conPass=new String(confirmNewPasswordField.getPassword());
    	if(!newPass.equals(conPass)){
    			JOptionPane.showMessageDialog(null, "密码不一致!");
    			return;
    	}
    	ipassWord=new String(newPasswordField.getPassword());    	
    	psql.setValue(iId,iName,iSex,iClass,iAge,iAddtress,iphoneNum,ipassWord);
    	psql.insertStudentDetail();
    	psql.insertIDTABLEofCustomer();
    	JOptionPane.showMessageDialog(null, "添加成功");
    	
    	name.setText("");
    	id.setText("");
    	homeAddress.setText("");
    	telNum.setText("");
    	newPasswordField.setText("");
    	confirmNewPasswordField.setText("");
    }  
    
    //监听帮助中的关于按扭
    else if(e.getSource()==item_about){
    	JOptionPane.showMessageDialog(null, "作者:杨伟明"+"\n"+"时间:2007年6月01日"+"\n"+
      "版本号: Tryout version 2.0"+"\n"+"God is in his heaven."+"\n"+"All's Right with the world."+"\n\t"+"NERV");
    }
     
    //监听录取线选项  
    else if(e.getSource()==item_clear){id.setText("");name.setText("");homeAddress.setText("");telNum.setText("");} 

  //  else if(e.getSource()==item_statist||e.getSource()==btn_statist){
  //  	dlg.reFresh();
  //  	dlg.setVisible(true);
 //   }
   
 }
	  	
    public void textValueChanged(TextEvent e){
    	if(e.getSource()==id)
    	{
    		iId=id.getText();
    	}
    	
    	else if(e.getSource()==name){
    		iName = name.getText();
    	}
    	
        else if(e.getSource()==homeAddress){
        	iAddtress=homeAddress.getText();
        }
        
        else if(e.getSource()==telNum){
        	iphoneNum=telNum.getText();
        }   	
	 }
	 
	 public void itemStateChanged(ItemEvent e){
	 	
   	 	if(e.getItemSelectable()==jrb_male){
   	 		iSex="男";
   	 	}
   	 	
   	 	else if(e.getItemSelectable()==jrb_female){
   	 		iSex="女";
   	 	}
   	 	
   	 	else if(e.getSource()==choice){
   	 		
   	 		iAge = choice.getSelectedIndex()+10;
   	 	
   	 	}
   	 	
   	 	else if(e.getItemSelectable()==Classes){
   	 		iClass = Classes.getSelectedItem();
   	 	
   	 		
   	 	}
   	 }
	  	
   void setDisplay(Boolean tf){
   	jdl.setVisible(tf);
   }
	  		
}


//排序界面
class framForCompositor implements ActionListener,ItemListener	
{

	JDialog jdl;
	JPanel contentPane_1,contentPane_2,contentPane_3;
	int xxx=1;//1代表 按学号排序,2代表按姓别排序,3代表按年龄排序,4代表按班级排序
    proceeSQL psql= new proceeSQL();
    framForClasses ffc;

    JRadioButton jrb_id=new JRadioButton("                按学号排序");
    JRadioButton jrb_sex=new JRadioButton("                按姓别排序");
    JRadioButton jrb_age=new JRadioButton("                按年龄排序");
    JRadioButton jrb_classes=new JRadioButton("                按班级排序");
    ButtonGroup select= new ButtonGroup();
    
    String cId="",cName="",cSex="",cClass="",cAddtress="",cphoneNum="";
    int cAge;
    

	JButton handin = new JButton("提交");
	JButton cancel = new JButton("退出");
	
	
    
    framForCompositor(JFrame f,String s,boolean b){
    	jdl = new JDialog(f,s,b);
    	ffc =new framForClasses(f,"按班级排序",b);

    	contentPane_1=new JPanel();
    	contentPane_2=new JPanel();
    	contentPane_3=new JPanel();
    	
    	jdl=new JDialog(f,s,b);  
        jdl.setSize(200,200); 
        jdl.setLocation(350,240); 
        jdl.setResizable(false);
         
        jdl.addWindowListener(new WindowAdapter()
        {public void windowClosing(WindowEvent e)
         {
            jdl.setVisible(false);
         }});
    	
    	select.add(jrb_id);
    	select.add(jrb_sex);
    	select.add(jrb_age);
    	select.add(jrb_classes);
    	
    	contentPane_1.add(jrb_id);
    	contentPane_1.add(jrb_sex);
    	contentPane_1.add(jrb_age);
    	contentPane_1.add(jrb_classes);
    	contentPane_1.setLayout(new GridLayout(4,1,9,9));
        
    	
    	contentPane_3.add(handin); 
	    contentPane_3.add(cancel);
	    contentPane_3.setLayout(new GridLayout(1,2,9,9));
	    
	    jrb_id.addItemListener(this);
    	jrb_sex.addItemListener(this);
    	jrb_age.addItemListener(this);
    	jrb_classes.addItemListener(this);
	    
	    handin.addActionListener(this);
	    cancel.addActionListener(this);
	    
	    jdl.add(new JLabel("请选择排序方式",JLabel.CENTER),BorderLayout.NORTH);
	    jdl.add(contentPane_1);
	    jdl.add(contentPane_3,BorderLayout.SOUTH);;
    	
    }
    
     public void actionPerformed(ActionEvent e){
     	if(e.getSource()==cancel){
     		jdl.setVisible(false);
     	}
     	else if(e.getSource()==handin&&xxx==1){//按学号排序
     	     	Statist.setTabelDisplay(false);
     
     	     Statist.clear();
     	     Statist.jishu=psql.SearchStudentForCompositorByID(Statist.a);
     	     Statist.showNum.setText("人数为:"+Statist.jishu);
     	     Statist.setTabelDisplay(true);
     	     jdl.setVisible(false);
     	}
     	
        else if(e.getSource()==handin&&xxx==2){//按性别排序
        
              Statist.setTabelDisplay(false);
              Statist.clear();     
              Statist.jishu=psql.SearchStudentForCompositorBySex(Statist.a);
              Statist.showNum.setText("人数为:"+Statist.jishu);
              Statist.setTabelDisplay(true);
              jdl.setVisible(false);
     	}
     	
     	else if(e.getSource()==handin&&xxx==3){//按年龄排序
     	   Statist.setTabelDisplay(false);    
        	Statist.clear();     	
     	    Statist.jishu= psql.SearchStudentForCompositorByAge(Statist.a);
     	    Statist.showNum.setText("人数为:"+Statist.jishu);
     	   	Statist.setTabelDisplay(true);
     	     jdl.setVisible(false);
     	}
     	
    	else if(e.getSource()==handin&&xxx==4){//按班级排序
    	ffc.setDisplay(true);
    	
     	}
     	
     	}
     	
   	 public void itemStateChanged(ItemEvent e){
   	 	if(e.getItemSelectable()==jrb_id){
   	 		xxx=1;
   	 	}
   	 	
   	 	else if(e.getItemSelectable()==jrb_sex){
   	 		xxx=2;
   	 	}
   	 	
   	    else if(e.getItemSelectable()==jrb_age){
   	    	xxx=3;
   	 	}
   	 	
   	 	else if(e.getItemSelectable()==jrb_classes){
   	 		xxx=4;
   	 		
   	 	}
   	 	
     	}
     	
     void setValue(String id,String name,String sex,String Class,int age,String addtress,String phoneNum)
    {
    	cId=id;cName=name;cSex=sex;cClass=Class;cAge=age;cAddtress=addtress;cphoneNum=phoneNum;
    }
    
    void setDisplay(Boolean tf){
   	jdl.setVisible(tf);
   }
}



//查找界面
class framForSearch implements ActionListener,ItemListener	
{

    framForClasses ffc;
    framForFind fff;
	JDialog jdl;
	JPanel contentPane_1,contentPane_2,contentPane_3;
	int xxx=1;//1代表学号,2代表姓名,3代表年龄,4代表班级

    JRadioButton jrb_id=new JRadioButton("                按学号查找");
    JRadioButton jrb_name=new JRadioButton("                按姓名查找");
    JRadioButton jrb_age=new JRadioButton("                按年龄查找");
    JRadioButton jrb_classes=new JRadioButton("                按班级查找");
    ButtonGroup select= new ButtonGroup();
    
    String cId="",cName="",cSex="",cClass="",cAddtress="",cphoneNum="";
    int cAge;
    

	JButton handin = new JButton("确定");
	JButton cancel = new JButton("退出");
    
    framForSearch(JFrame f,String s,boolean b){
    	jdl = new JDialog(f,s,b);
        ffc = new framForClasses(f,"查看班级信息",b);
        fff = new framForFind(f,"输入信息",b);
        
    	contentPane_1=new JPanel();
    	contentPane_2=new JPanel();
    	contentPane_3=new JPanel();
    	
    	jdl=new JDialog(f,s,b);  
        jdl.setSize(200,200); 
        jdl.setLocation(350,240); 
        jdl.setResizable(false);
         
        jdl.addWindowListener(new WindowAdapter()
        {public void windowClosing(WindowEvent e)
         {
            jdl.setVisible(false);
         }});
    	
    	select.add(jrb_id);
    	select.add(jrb_name);
    	select.add(jrb_age);
    	select.add(jrb_classes);
    	
    	jrb_id.addItemListener(this);
    	jrb_name.addItemListener(this);
    	jrb_age.addItemListener(this);
    	jrb_classes.addItemListener(this);
    	
    	contentPane_1.add(jrb_id);
    	contentPane_1.add(jrb_name);
    	contentPane_1.add(jrb_age);
    	contentPane_1.add(jrb_classes);
    	contentPane_1.setLayout(new GridLayout(4,1,9,9));
        
    	
    	contentPane_3.add(handin); 
	    contentPane_3.add(cancel);
	    contentPane_3.setLayout(new GridLayout(1,2,9,9));
	    
	    handin.addActionListener(this);
	    cancel.addActionListener(this);
	    
	    jdl.add(new JLabel("请选择查找方式",JLabel.CENTER),BorderLayout.NORTH);
	    jdl.add(contentPane_1);
	    jdl.add(contentPane_3,BorderLayout.SOUTH);;
    	
    }
    
     public void actionPerformed(ActionEvent e){
     	if(e.getSource()==cancel){
     		jdl.setVisible(false);
     	}
     	else if(e.getSource()==handin&&xxx==1){//按学号查找
     	fff.change(1);
     	fff.setDisplay(true);
     	}
     	
        else if(e.getSource()==handin&&xxx==2){//按姓名查找
       	fff.change(2);
     	fff.setDisplay(true);
     	}
     	
     	else if(e.getSource()==handin&&xxx==3){//按年龄查找
        fff.change(3);
     	fff.setDisplay(true);
     	}
     	
    	else if(e.getSource()==handin&&xxx==4){//按学号查找

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -