denglu.java

数据库 学生综合管理系统 实现了学生课程教师管理 及学生选课

package test;



import java.awt.*;
import java.io.*;//输入输出
import java.awt.event.*;
import java.sql.*;

import javax.swing.*;

public class denglu extends JFrame implements ActionListener
{sql sqll;ResultSet rs;int n;
	public static String mm;
	
	JRadioButton b1=new JRadioButton("管理员");
JRadioButton b2=new JRadioButton("学生",true);
JRadioButton b3=new JRadioButton("教师");
ButtonGroup group;
//group.add(b1);group.add(b1);group.add(b1);

JButton button1=new JButton("登陆"),button2=new JButton("退出");
JTextField field1,field2;JPasswordField j2;
JLabel jl1=new JLabel("用户名："),jl2=new JLabel("密码：");
//button1.addActionListener(this);

	
	
	
	
	public denglu(){
	
	Container contentpane=getContentPane(); 
      setBounds(300,200,300,200);
     setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);	
     setTitle("登陆界面");
     JPanel p1=new JPanel(),p2=new JPanel(),p3 =new JPanel();

     field1=new JTextField(10);field2=new JTextField(10);
     j2=new JPasswordField();
     contentpane.add(p1,BorderLayout.CENTER);
     contentpane.add(p3,BorderLayout.SOUTH);
			
    contentpane.add(p2,BorderLayout.NORTH);	
	p1.setLayout(new GridLayout(2,1));
	group= new ButtonGroup ();
	group.add(b1);group.add(b2);group.add(b3);
	p1.add(jl1);p1.add(field1);
	p1.add(jl2);p1.add(j2);
	
	p2.add(b1);p2.add(b2);p2.add(b3);
	p3.add( button1);p3.add( button2);
	button1.addActionListener(this);
	
	
	
	
	}
	public static void main(String[] args){		 
		denglu dd=new denglu();
		dd.setVisible(true);
	}
	
	
	
	public void actionPerformed(ActionEvent e){
		if(e.getSource()==button1&&b2.isSelected()){n++;
		String s="select * from xushengdenglu";
		sqll=new sql();
		try{rs=sqll.execsql(s);
		rs.next();
		do{//System.out.println(rs.getString(1));
		                 //System.out.println(rs.getString(2));
			mm=rs.getString(1);
			if(mm.trim().equals(field1.getText().trim())&&rs.getString(2).trim().equals(j2.getText().trim()))	                        
			{System.out.println("sucess denlu!!!");
			n=0;
			Xuesheng g=new Xuesheng();
			//rs.next();//rs.previous();
			g.xuehao=mm;
			g.setVisible(true);
			break;}}
			
			while(rs.next());
		                     
		if(n==1){JOptionPane.showMessageDialog(this,"您还有2次机会!"+JOptionPane.WARNING_MESSAGE);}
		if(n==2){JOptionPane.showMessageDialog(this,"您还有1次机会!"+JOptionPane.WARNING_MESSAGE);}
		if(n==3){JOptionPane.showMessageDialog(this,"您没有机会!"+JOptionPane.WARNING_MESSAGE);}
		if(n>3){JOptionPane.showMessageDialog(this,"抱歉,登陆次数太多!"+JOptionPane.WARNING_MESSAGE);System.exit(0);}
	 }catch(Exception f){f.printStackTrace(); }
		
		
	}
		//******************************************************************************************************************
		if(e.getSource()==button1&&b1.isSelected()){n++;
		String s="select * from guanliyuan";
		sqll=new sql();
		try{rs=sqll.execsql(s);
		rs.next();
		do{//System.out.println(rs.getString(1));
		                 //System.out.println(rs.getString(2));
			mm=rs.getString(1);
			if(mm.trim().equals(field1.getText().trim())&&rs.getString(2).trim().equals(j2.getText().trim()))	                        
			{System.out.println("sucess denlu!!!");
			n=0;
			Guanliyuan g=new Guanliyuan();
			//rs.next();//rs.previous();
			g.xuehao=mm;
			g.setVisible(true);
			break;}}
			
			while(rs.next());
		                     
		if(n==1){JOptionPane.showMessageDialog(this,"您还有2次机会!"+JOptionPane.WARNING_MESSAGE);}
		if(n==2){JOptionPane.showMessageDialog(this,"您还有1次机会!"+JOptionPane.WARNING_MESSAGE);}
		if(n==3){JOptionPane.showMessageDialog(this,"您没有机会!"+JOptionPane.WARNING_MESSAGE);}
		if(n>3){JOptionPane.showMessageDialog(this,"抱歉,登陆次数太多!"+JOptionPane.WARNING_MESSAGE);System.exit(0);}
	 }catch(Exception f){f.printStackTrace(); }
		
		
	}
		//******************************************************************************************************************
		if(e.getSource()==button1&&b3.isSelected()){n++;
		String s="select * from jiaoshidenglu";
		sqll=new sql();
		try{rs=sqll.execsql(s);
		rs.next();
		do{//System.out.println(rs.getString(1));
		                 //System.out.println(rs.getString(2));
			mm=rs.getString(1);
			if(mm.trim().equals(field1.getText().trim())&&rs.getString(2).trim().equals(j2.getText().trim()))	                        
			{System.out.println("sucess denlu!!!");
			n=0;
		Teacher g=new Teacher();
			//rs.next();//rs.previous();
			g.jiaoshihao=mm;
			g.setVisible(true);
			break;}}
			
			while(rs.next());
		                     
		if(n==1){JOptionPane.showMessageDialog(this,"您还有2次机会!"+JOptionPane.WARNING_MESSAGE);}
		if(n==2){JOptionPane.showMessageDialog(this,"您还有1次机会!"+JOptionPane.WARNING_MESSAGE);}
		if(n==3){JOptionPane.showMessageDialog(this,"您没有机会!"+JOptionPane.WARNING_MESSAGE);}
		if(n>3){JOptionPane.showMessageDialog(this,"抱歉,登陆次数太多!"+JOptionPane.WARNING_MESSAGE);System.exit(0);}
	 }catch(Exception f){f.printStackTrace(); }
		
		
	}
		//******************************************************************************************************************


}}