managerpanel.java

由java编写的学生选课管理系统

			vbox.add(hbox5);
			vbox.add(Box.createVerticalStrut(5));
			vbox.add(hbox6);
			vbox.add(Box.createVerticalStrut(5));
			vbox.add(hbox7);
			vbox.add(Box.createVerticalStrut(10));
			vbox.add(hbox8);
			
			add(vbox);
		}
		
		
		//查询课程信息  查询课程信息  查询课程信息  查询课程信息  
		if(selected == 12)
		{
			JLabel myLabel =  new JLabel("    查 询 课 程 信 息");
			myLabel.setFont(new Font("TimesRoman", Font.BOLD, 20));
			myLabel.setForeground(Color.RED);
			Box hbox1 = Box.createHorizontalBox();
			hbox1.add(myLabel);
			
			courseNumTextField = new JTextField(15);
			Box hbox2 = Box.createHorizontalBox();
			hbox2.add(new JLabel("课程号："));
			hbox2.add(courseNumTextField);
			
			courseNameTextField = new JTextField(15);
			courseNameTextField.setEditable(false);
			Box hbox3 = Box.createHorizontalBox();
			hbox3.add(new JLabel("课程名："));
			hbox3.add(courseNameTextField);
			
			periodTextField = new JTextField(15);
			periodTextField.setEditable(false);
			Box hbox4 = Box.createHorizontalBox();
			hbox4.add(new JLabel("学    时："));
			hbox4.add(periodTextField);
			
			creditHourTextField = new JTextField(15);
			creditHourTextField.setEditable(false);
			Box hbox5 = Box.createHorizontalBox();
			hbox5.add(new JLabel("学    分："));
			hbox5.add(creditHourTextField);
			
			termTextField = new JTextField(15);
			termTextField.setEditable(false);
			Box hbox6 = Box.createHorizontalBox();
			hbox6.add(new JLabel("学    期："));
			hbox6.add(termTextField);
			
			teaTextField = new JTextField(15);
			teaTextField.setEditable(false);
			Box hbox7 = Box.createHorizontalBox();
			hbox7.add(new JLabel("教    师："));
			hbox7.add(teaTextField);
			
			queryButton = new JButton("查询");
			queryButton.addActionListener(new ManagerPanelAction());
			resetButton = new JButton("继续");
			resetButton.addActionListener(new ManagerPanelAction());
			Box hbox8 = Box.createHorizontalBox();
			hbox8.add(Box.createHorizontalStrut(30));
			hbox8.add(queryButton);
			hbox8.add(Box.createHorizontalStrut(50));
			hbox8.add(resetButton);
			
			Box vbox = Box.createVerticalBox();
			vbox.add(hbox1);
			vbox.add(Box.createVerticalStrut(5));
			vbox.add(hbox2);
			vbox.add(Box.createVerticalStrut(5));
			vbox.add(hbox3);
			vbox.add(Box.createVerticalStrut(5));
			vbox.add(hbox4);
			vbox.add(Box.createVerticalStrut(5));
			vbox.add(hbox5);
			vbox.add(Box.createVerticalStrut(5));
			vbox.add(hbox6);
			vbox.add(Box.createVerticalStrut(5));
			vbox.add(hbox7);
			vbox.add(Box.createVerticalStrut(10));
			vbox.add(hbox8);
			
			add(vbox);
		}
		
		//删除课程信息  删除课程信息  删除课程信息  删除课程信息  
		if(selected == 13)
		{
			JLabel myLabel =  new JLabel("      删除课程信息", JLabel.CENTER);
			myLabel.setFont(new Font("TimesRoman", Font.BOLD, 25));
			myLabel.setForeground(Color.RED);
			Box hbox1 = Box.createHorizontalBox();
			hbox1.add(myLabel);
				
			
			courseNumTextField = new JTextField(15);
			JPanel courseNumPanel = new JPanel(); 
			Box hbox2 = Box.createHorizontalBox();
			hbox2.add(new JLabel("课程号："));
			hbox2.add(courseNumTextField);
			
						
			delButton = new JButton("删除");
			delButton.addActionListener(new ManagerPanelAction());
			resetButton = new JButton("继续");
			resetButton.addActionListener(new ManagerPanelAction());
			Box hbox3 = Box.createHorizontalBox();
      hbox3.add(delButton);
      hbox3.add(Box.createHorizontalStrut(25));
      hbox3.add(resetButton);
      hbox3.add(Box.createHorizontalStrut(25));
      hbox3.add(resetButton);
			
			Box vbox = Box.createVerticalBox();
			vbox.add(Box.createVerticalStrut(20));
			vbox.add(hbox1);
			vbox.add(Box.createVerticalStrut(35));
			vbox.add(hbox2);
			vbox.add(Box.createVerticalStrut(60));
			vbox.add(hbox3);		
			
			add(vbox);
		}
		
		if(selected == 14)             //更新学生成绩
		{
			JLabel myLabel =  new JLabel("    更 新 学 生 成 绩");
			myLabel.setFont(new Font("TimesRoman", Font.BOLD, 25));
			myLabel.setForeground(Color.RED);
			Box hbox1 = Box.createHorizontalBox();
			hbox1.add(myLabel);
			
			stuNumTextField = new JTextField(15);
		  Box hbox2 = Box.createHorizontalBox();
			hbox2.add(new JLabel("学    号："));
			hbox2.add(stuNumTextField);
			
			courseNumTextField = new JTextField(15);
			Box hbox3 = Box.createHorizontalBox();
			hbox3.add(new JLabel("课程号："));
			hbox3.add(courseNumTextField);
			
			gradeTextField = new JTextField(15);
			Box hbox4 = Box.createHorizontalBox();
			hbox4.add(new JLabel("成    绩："));
			hbox4.add(gradeTextField);
			
			insertButton = new JButton("更新");
			insertButton.addActionListener(new ManagerPanelAction());
			resetButton = new JButton("继续");
			resetButton.addActionListener(new ManagerPanelAction());
			Box hbox5 = Box.createHorizontalBox();
			hbox5.add(Box.createHorizontalStrut(30));
			hbox5.add(insertButton);
			hbox5.add(Box.createHorizontalStrut(50));
			hbox5.add(resetButton);
			
			Box vbox = Box.createVerticalBox();
			
			vbox.add(hbox1);
			vbox.add(Box.createVerticalStrut(20));
			vbox.add(hbox2);
			vbox.add(Box.createVerticalStrut(20));
			vbox.add(hbox3);		
			vbox.add(Box.createVerticalStrut(20));
			vbox.add(hbox4);
			vbox.add(Box.createVerticalStrut(35));
			vbox.add(hbox5);
			
			add(vbox);
			
			
		}
		
		if(selected == 15)              //查询学生成绩
		{
			JLabel myLabel =  new JLabel("    查 询 学 生 成 绩");
			myLabel.setFont(new Font("TimesRoman", Font.BOLD, 25));
			myLabel.setForeground(Color.RED);
			Box hbox1 = Box.createHorizontalBox();
			hbox1.add(myLabel);
			
			stuNumTextField = new JTextField(15);
		  Box hbox2 = Box.createHorizontalBox();
			hbox2.add(new JLabel("学    号："));
			hbox2.add(stuNumTextField);
			
			courseNumTextField = new JTextField(15);
			Box hbox3 = Box.createHorizontalBox();
			hbox3.add(new JLabel("课程号："));
			hbox3.add(courseNumTextField);
			
			gradeTextField = new JTextField(15);
			gradeTextField.setEditable(false);
			Box hbox4 = Box.createHorizontalBox();
			hbox4.add(new JLabel("成    绩："));
			hbox4.add(gradeTextField);
			
			queryButton = new JButton("查询");
			queryButton.addActionListener(new ManagerPanelAction());
			resetButton = new JButton("继续");
			resetButton.addActionListener(new ManagerPanelAction());
			Box hbox5 = Box.createHorizontalBox();
			hbox5.add(Box.createHorizontalStrut(30));
			hbox5.add(queryButton);
			hbox5.add(Box.createHorizontalStrut(50));
			hbox5.add(resetButton);
			
			Box vbox = Box.createVerticalBox();
			
			vbox.add(hbox1);
			vbox.add(Box.createVerticalStrut(20));
			vbox.add(hbox2);
			vbox.add(Box.createVerticalStrut(20));
			vbox.add(hbox3);		
			vbox.add(Box.createVerticalStrut(20));
			vbox.add(hbox4);
			vbox.add(Box.createVerticalStrut(35));
			vbox.add(hbox5);
			
			add(vbox);
		}
		
		if(selected == 16)             //删除学生成绩
		{
			JLabel myLabel =  new JLabel("    删 除 学 生 成 绩");
			myLabel.setFont(new Font("TimesRoman", Font.BOLD, 20));
			myLabel.setForeground(Color.RED);
			Box hbox1 = Box.createHorizontalBox();
			hbox1.add(myLabel);
			
			stuNumTextField = new JTextField(15);
		  Box hbox2 = Box.createHorizontalBox();
			hbox2.add(new JLabel("学    号："));
			hbox2.add(stuNumTextField);
			
			courseNumTextField = new JTextField(15);
			Box hbox3 = Box.createHorizontalBox();
			hbox3.add(new JLabel("课程号："));
			hbox3.add(courseNumTextField);
					
			delButton = new JButton("删除");
			delButton.addActionListener(new ManagerPanelAction());
			resetButton = new JButton("继续");
			resetButton.addActionListener(new ManagerPanelAction());
			Box hbox4 = Box.createHorizontalBox();
			hbox4.add(Box.createHorizontalStrut(30));
			hbox4.add(delButton);
			hbox4.add(Box.createHorizontalStrut(50));
			hbox4.add(resetButton);
			
			Box vbox = Box.createVerticalBox();
			vbox.add(Box.createVerticalStrut(10));
			vbox.add(hbox1);
			vbox.add(Box.createVerticalStrut(30));
			vbox.add(hbox2);
			vbox.add(Box.createVerticalStrut(35));
			vbox.add(hbox3);		
			vbox.add(Box.createVerticalStrut(40));
			vbox.add(hbox4);
			
			
			add(vbox); 
		}
		
		if(selected == 17)              //统计学生成绩
		{
			ButtonGroup bGroup = new ButtonGroup();
			byTotalButton = new JRadioButton("按总分排序", true);
			//byTotalButton.addActionListener(new ManagerPanelAction());
		  byAverageButton = new JRadioButton("按平均分排序", false);
		  //byAverageButton.addActionListener(new ManagerPanelAction());
		  bGroup.add(byTotalButton);
		  bGroup.add(byAverageButton);
		  confirmButton = new JButton("确定");
		  confirmButton.addActionListener(new ManagerPanelAction());
		  
		  Box hbox = Box.createHorizontalBox();
		  hbox.add(byTotalButton);
		  hbox.add(Box.createHorizontalStrut(20));
		  hbox.add(byAverageButton);
		  hbox.add(Box.createHorizontalStrut(40));
		  hbox.add(confirmButton);
		
		  
		  Border titledBorder = BorderFactory.createTitledBorder("排序方式");
		  
		  JPanel orderPanel = new JPanel();
		  orderPanel.add(hbox);
		  orderPanel.setBorder(titledBorder);
		  
		  setLayout(new BorderLayout());
		  add(orderPanel, BorderLayout.NORTH);
		 
		  

		}
		
		
		
	}
	
	/**
    私有类作为各个面板监听
  */
	private class ManagerPanelAction implements ActionListener
	{
		public void actionPerformed(ActionEvent e)
		{
			
			//修改密码界面监听  修改密码界面监听  修改密码界面监听  
			if(selected == 1)
			{
				if(e.getSource() == changeButton)
				{
					newPassword = new String(newPasswordField.getPassword());
					againPassword = new String(againPasswordField.getPassword());
					if(newPassword.equals(againPassword))
					{
						
						try
						{
							inquestPass();
						}
						catch(SQLException sqle){}
					  
						
					}
					else
					{
						
						JOptionPane.showMessageDialog(null, "你输入的密码不匹配，请重新输入！", "用户帐户", JOptionPane.WARNING_MESSAGE);
						oldPasswordField.setText(null);
						newPasswordField.setText(null);
						againPasswordField.setText(null);
						
					}
				}
				
				if(e.getSource() == resetButton)
				{
					oldPasswordField.setText(null);
					newPasswordField.setText(null);
					againPasswordField.setText(null);
				}
			}
			
			//录入学生成绩界面监听//录入学生成绩界面监听
			if(selected == 2)      
			{
				if(e.getSource() == insertButton)  //录入按钮监听
				{
					try
          {  
             String sex = (String)sexComboBox.getSelectedItem();
          	 
             if(stuNumTextField.getText().equals( "" )||stuNameTextField.getText().equals( "" )
                 || majorTextField.getText().equals( "" ) || birthTextField.getText().equals( "" ))
   	         {
   	             JOptionPane.showMessageDialog(ManagerPanel.this , "请填好学生资料" ); 
                 //setTitle( "无记录显示" ); 
                 return; 	
   	         }
   	         insertQuery = "SELECT * FROM 学生基本信息表 WHERE 学号 = '" + stuNumTextField.getText()+"'";
             insertUpdate = "INSERT INTO 学生基本信息表 VALUES('"
      		 			+ stuNumTextField.getText()+"','"+stuNameTextField.getText()+"','"
      		 			+ sex +"','" + majorTextField.getText() + "','"
      		 			+ birthTextField.getText()+"'," + heightTextField.getText()+",'"
      		 			+ stuNumTextField.getText()+"')";
            
             inputStudent();              //调用方法  调用方法  调用方法  
             
          }
          catch(SQLException ee)
          {
          	  JOptionPane.showMessageDialog (ManagerPanel.this ,ee ,
          "学生选课管理系统",JOptionPane.WARNING_MESSAGE );
          }
				}
				
			
				if(e.getSource() == resetButton)  //继续按钮监听