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

📄 loginframe.java

📁 利用JAVA的界面对MS SQL进行操作,实现了学生管理系统基本功能:登陆,录入,查询,删除,修改,内置程序详细讲解.
💻 JAVA
📖 第 1 页 / 共 5 页
字号:
    	ffc.setDisplay(true);
     	}
     	
     	}
   	 public void itemStateChanged(ItemEvent e){
   	 	if(e.getItemSelectable()==jrb_id){
   	 		xxx=1;
   	 	}
   	 	
   	 	else if(e.getItemSelectable()==jrb_name){
   	 		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 framForClasses implements ActionListener,ItemListener	
{

	JDialog jdl;
	JPanel contentPane_1,contentPane_2,contentPane_3;
	int xxx=1;//1代表计科1班,2代表计科2班,3代表计科3班,4代表计科4班

    JRadioButton jrb_1=new JRadioButton("                计科1班");
    JRadioButton jrb_2=new JRadioButton("                计科2班");
    JRadioButton jrb_3=new JRadioButton("                计科3班");
    JRadioButton jrb_4=new JRadioButton("                计科4班");
    ButtonGroup select= new ButtonGroup();
    
    String cId="",cName="",cSex="",cClass="",cAddtress="",cphoneNum="";
    int cAge;
    

	JButton handin = new JButton("提交");
	JButton cancel = new JButton("退出");
	
	proceeSQL psql = new proceeSQL();
    
    framForClasses(JFrame f,String s,boolean b){
    	jdl = new JDialog(f,s,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_1);
    	select.add(jrb_2);
    	select.add(jrb_3);
    	select.add(jrb_4);
    	
    	jrb_1.addItemListener(this);
    	jrb_2.addItemListener(this);
    	jrb_3.addItemListener(this);
    	jrb_4.addItemListener(this);
    	
    	contentPane_1.add(jrb_1);
    	contentPane_1.add(jrb_2);
    	contentPane_1.add(jrb_3);
    	contentPane_1.add(jrb_4);
    	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){//查找1班
     	     	Statist.setTabelDisplay(false);
     	
     	       	Statist.clear();
        		Statist.jishu=psql.SearchStudentDetaiByClasses("计科1班",Statist.a);
        		Statist.showNum.setText("人数为:"+Statist.jishu);
        		Statist.setTabelDisplay(true);
        			jdl.setVisible(false);
     	}
     	
        else if(e.getSource()==handin&&xxx==2){//查找2班
             	Statist.setTabelDisplay(false);
     
              	Statist.clear();
        		Statist.jishu=psql.SearchStudentDetaiByClasses("计科2班",Statist.a);
        		Statist.showNum.setText("人数为:"+Statist.jishu);
        		jdl.setVisible(false);
        		Statist.setTabelDisplay(true);
     	}
     	
     	else if(e.getSource()==handin&&xxx==3){//查找3班
     	        Statist.setTabelDisplay(false);    
     	    	Statist.clear();
        		Statist.jishu=psql.SearchStudentDetaiByClasses("计科3班",Statist.a);
        		Statist.setTabelDisplay(true);
        			jdl.setVisible(false);
     	}
     	
    	else if(e.getSource()==handin&&xxx==4){//查找4班
    	     	Statist.setTabelDisplay(false);
     	
    	    	Statist.clear();
        		Statist.jishu=psql.SearchStudentDetaiByClasses("计科4班",Statist.a);
        		Statist.showNum.setText("人数为:"+Statist.jishu);
        		Statist.setTabelDisplay(true);
        		jdl.setVisible(false);
     	}
     	
     	}
     	
   	 public void itemStateChanged(ItemEvent e){
   	 	if(e.getItemSelectable()==jrb_1){
   	 		xxx=1;
   	 	}
   	 	
   	 	else if(e.getItemSelectable()==jrb_2){
   	 		xxx=2;
   	 	}
   	 	
   	    else if(e.getItemSelectable()==jrb_3){
   	    	xxx=3;
   	 	}
   	 	
   	 	else if(e.getItemSelectable()==jrb_4){
   	 		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 framForDelete implements ActionListener
{

    framForSearch ffs;//查找界面
	JDialog jdl;
	JPanel contentPane_1,contentPane_3;
    
    JLabel du_id=new JLabel("输入学号",JLabel.CENTER); 
    JTextField jf_id=new JTextField();  
    String cId="",cName="",cSex="",cClass="",cAddtress="",cphoneNum="";
    int cAge;
    

	JButton handin = new JButton("提交");
	JButton find =new JButton("查找");
	JButton cancel = new JButton("退出");
	
	proceeSQL psql=new proceeSQL();
    
   framForDelete(JFrame f,String s,boolean b){
    	jdl = new JDialog(f,s,b);
    	ffs = new framForSearch(f,"查找用户信息",b);

    	contentPane_1=new JPanel();
    	contentPane_3=new JPanel();
    	
    	jdl=new JDialog(f,s,b);  
        jdl.setSize(275,170); 
        jdl.setLocation(350,240); 
        jdl.setResizable(false);
         
        jdl.addWindowListener(new WindowAdapter()
        {public void windowClosing(WindowEvent e)
         {
            jdl.setVisible(false);
         }});
    	

    	
    	contentPane_1.add(du_id);
    	contentPane_1.add(jf_id);  	
    	contentPane_1.add(find);
	    contentPane_1.add(cancel);

    	contentPane_1.setLayout(new GridLayout(2,2,9,9));
        
    	
	    contentPane_3.add(new JLabel("一失足成千古恨,君请三思",JLabel.CENTER));
	    contentPane_3.add(handin);
	    contentPane_3.setLayout(new GridLayout(2,1,9,9));
	    
	    handin.addActionListener(this);
	    find.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()==find){
     		ffs.setDisplay(true);
     	}
     	
        else if(e.getSource()==handin){

        	boolean state = psql.weatherExist(jf_id.getText());
        	if(!state)JOptionPane.showMessageDialog(null, "没有此人");  
        	else{        
        
            
        	Statist.setTabelDisplay(false);    
        	Statist.clear();
        	psql.DistroyStudentDetail(jf_id.getText());
        	psql.DistroyIDTABLE(jf_id.getText());
        	Statist.setTabelDisplay(true);
        	}


     	}      	
   	 	
     	}
     	
     	
     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 framForUpdate implements ActionListener
{

    framForSearch ffs;//查找界面
    updateInfo ffu;//修改界面
    proceeSQL psql=new proceeSQL();
	JDialog jdl;
	JPanel contentPane_1,contentPane_3;
    
    JLabel du_id=new JLabel("输入学号",JLabel.CENTER); 
    JTextField jf_id=new JTextField();  
    String cId="",cName="",cSex="",cClass="",cAddtress="",cphoneNum="";
    int cAge;
    

	JButton handin = new JButton("提交");
	JButton find =new JButton("查找");
	JButton cancel = new JButton("退出");
    
   framForUpdate(JFrame f,String s,boolean b){
    	jdl = new JDialog(f,s,b);
    	ffs = new framForSearch(f,"查找用户信息",b);
        ffu = new updateInfo(f,"修改用户信息",b);
    	contentPane_1=new JPanel();
    	contentPane_3=new JPanel();
    	
    	jdl=new JDialog(f,s,b);  
        jdl.setSize(275,170); 
        jdl.setLocation(350,240); 
        jdl.setResizable(false);
         
        jdl.addWindowListener(new WindowAdapter()
        {public void windowClosing(WindowEvent e)
         {
            jdl.setVisible(false);
         }});
    	

    	
    	contentPane_1.add(du_id);
    	contentPane_1.add(jf_id);  	
    	contentPane_1.add(find);
	    contentPane_1.add(cancel);

    	contentPane_1.setLayout(new GridLayout(2,2,9,9));      
	    contentPane_3.add(handin);
	    
	    handin.addActionListener(this);
	    find.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()==find){
     		ffs.setDisplay(true);
     	}
     	
        else if(e.getSource()==handin){
        	if((jf_id.getText()).equals("")){
        		JOptionPane.showMessageDialog(null, "请输入学号!"); 
        		return;
        	}
        	boolean state=psql.weatherExist(jf_id.getText());
        	if(!state){
        		JOptionPane.showMessageDialog(null, "没有此人"); 
        		return;
        	}
        	
        	ffu.setID(jf_id.getText());
            ffu.setDisplay(true);
     	}      	
   	 	
     	}
     	
     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 framForFind implements ActionListener
{

	JDialog jdl;
	JPanel contentPane_1,contentPane_3;
	proceeSQL psql;
    
    JLabel du_info=new JLabel("",JLabel.CENTER); 
    JTextField jf_id=new JTextField();  
    String cId="",cName="",cSex="",cClass="",cAddtress="",cphoneNum="";
    int cAge;
    int cChange;
    

	JButton handin = new JButton("提交");
	JButton cancel = new JButton("取消");
    
   framForFind(JFrame f,String s,boolean b){
    	jdl = new JDialog(f,s,b);
        psql = new proceeSQL();
    	contentPane_1=new JPanel();
    	
    	jdl=new JDialog(f,s,b);  
        jdl.setSize(275,150); 
        jdl.setLocation(350,240); 
        jdl.setResizable(false);
         
        jdl.addWindowListener(new WindowAdapter()
        {public void windowClosing(WindowEvent e)
         {
            jdl.setVisible(false);
         }});
    	

    	
    	contentPane_1.add(du_info);
    	contentPane_1.add(jf_id); 
    	contentPane_1.add(handin);
	    contentPane_1.add(cancel);

    	contentPane_1.setLayout(new GridLayout(2,2,9,9));      

	    
	    handin.addActionListener(this);
	    cancel.addActionListener(this);
	    
	    jdl.add(new JLabel("请输入信息",JLabel.CENTER),BorderLayout.NORTH);
	    jdl.add(contentPane_1);
    	
    }
    
     public void actionPerformed(ActionEvent e){
     	
     	if(e.getSource()==cancel){
     		jdl.setVisible(false);
     	}
     	
     	
        else if(e.getSource()==handin){
        	if(cChange==1){
        	Statist.setTabelDisplay(false);
           	Statist.clear();
        	Statist.jishu=psql.SearchStudentDetaiById(jf_id.getText(),Statist.a);
        	Statist.showNum.setText("人数为:"+Statist.jishu);
        	Statist.setTabelDisplay(true);
        	}
        	
        	else if(cChange==2){
        		Statist.setTabelDisplay(false);
        		Statist.clear();
        		Statist.jishu=psql.SearchStudentDetaiByName(jf_id.getText(),Statist.a);
        		Statist.showNum.setText("人数为:"+Statist.jishu);

⌨️ 快捷键说明

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