teacherpanel.java

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

import javax.swing.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.border.*;

public class TeacherPanel extends JPanel
{
	public TeacherPanel(int selected)
	{
		this.selected = selected;
		if(selected == 0)                           //修改密码界面
	  {
	    JLabel label1 = new JLabel("请输入当前的密码：", JLabel.CENTER);
	    oldPasswordField = new JPasswordField(20);
	    Box hbox1 = Box.createHorizontalBox();
	    hbox1.add(label1);
	    hbox1.add(Box.createHorizontalStrut(10));
	    hbox1.add(oldPasswordField);
	    
	    JLabel label2 = new JLabel("请输入一个新密码：");
	    newPasswordField = new JPasswordField(20);
	    Box hbox2 = Box.createHorizontalBox();
	    hbox2.add(label2);
	    hbox2.add(Box.createHorizontalStrut(10));
	    hbox2.add(newPasswordField);
	    
	    JLabel label3 = new JLabel("请再次输入新密码：");
	    againPasswordField = new JPasswordField(20);
	    Box hbox3 = Box.createHorizontalBox();
	    hbox3.add(label3);
	    hbox3.add(Box.createHorizontalStrut(10));
	    hbox3.add(againPasswordField);
	    
	    changeButton = new JButton("修改");
	    changeButton.addActionListener(new TeacherPanelAction());
	    resetButton = new JButton("重置");
	    resetButton.addActionListener(new TeacherPanelAction());
	    Box hbox4 = Box.createHorizontalBox();
	    hbox4.add(changeButton);
	    hbox4.add(Box.createHorizontalStrut(50));
	    hbox4.add(resetButton);
	    
	    Box vbox = Box.createVerticalBox();
	    vbox.add(Box.createVerticalStrut(30));
	    vbox.add(hbox1);
	    vbox.add(Box.createVerticalStrut(20));
	    vbox.add(hbox2);
	    vbox.add(Box.createVerticalStrut(20));
	    vbox.add(hbox3);
	    vbox.add(Box.createVerticalStrut(40));
	    vbox.add(hbox4);
	    
	    add(vbox);
	    
	  }
	  
	  if(selected == 1)       //选课名单界面  选课名单界面  选课名单界面  
	  {
	  	setLayout(new BorderLayout());
			
			JLabel myLabel = new JLabel("请输入课程号");
			courseNumTextField = new JTextField(10);
			queryButton = new JButton("查询");
			queryButton.addActionListener(new TeacherPanelAction());
			queryButton.setPreferredSize(new Dimension(80, 20));
			
			JPanel myPanel = new JPanel();
			myPanel.add(myLabel);
			myPanel.add(courseNumTextField);
			myPanel.add(queryButton);
			
			add(myPanel, BorderLayout.NORTH);
			
			//构建表格
			query = new String("SELECT 成绩表.学号,姓名,成绩表.课程号,课程名  "
        	     +" FROM 学生基本信息表,成绩表,课程信息表,教师表 "
        	     +" WHERE 成绩表.学号=学生基本信息表.学号 "
        	     +" AND  成绩表.课程号=课程信息表.课程号 ");
      query = query+" AND 登陆帐号='"+LoginFrame.myTextField.getText()
        	     +"' AND 课程信息表.教师=教师表.教师 ";
        	     
      stuNameTable = new JTable();
		  JScrollPane commodityscroller = new JScrollPane( stuNameTable ); 
      add( commodityscroller ,BorderLayout.CENTER);
      
     
      getTable(query);
 		  
  	  }
  	  
  	  //成绩管理界面  //成绩管理界面  //成绩管理界面  
  	  if(selected == 2)     //成绩管理界面  
  	  {
  	  	queryButton=new JButton("查询");
        queryButton.addActionListener(new TeacherPanelAction());
        updateButton=new JButton("更新");
        updateButton.addActionListener(new TeacherPanelAction());
        resetButton=new JButton("重置");
        resetButton.addActionListener(new TeacherPanelAction());
      
  	    stuNumTextField = new JTextField(10);
  	    courseNumTextField = new JTextField(10);
  	    courseNameTextField = new JTextField(10);
        courseNameTextField.setEditable(false);     //设定为不可编辑
        gradeTextField=new JTextField(10);
        
        ////////////////////////////////////////
        JLabel label=new JLabel("学生选课成绩维护",JLabel.CENTER);
        label.setFont(new Font("TimesRoman",Font.BOLD,20));
        label.setForeground(Color.RED);
        ////////////////////////////////////////
        Box hbox1=Box.createHorizontalBox();
        hbox1.add(label);
        Box hbox2=Box.createHorizontalBox();              
        hbox2.add(new JLabel("学    号：",JLabel.CENTER));
        hbox2.add(stuNumTextField);
        Box hbox3=Box.createHorizontalBox();              
        hbox3.add(new JLabel("课程号：",JLabel.CENTER));
        hbox3.add(courseNumTextField);
        Box hbox4=Box.createHorizontalBox();              
        hbox4.add(new JLabel("课程名：",JLabel.CENTER));
        hbox4.add(courseNameTextField);
        Box hbox5=Box.createHorizontalBox();              
        hbox5.add(new JLabel("分    数：",JLabel.CENTER));
        hbox5.add(gradeTextField);
        
        Box vbox=Box.createVerticalBox();  
        vbox.add(Box.createVerticalStrut(8));           
        vbox.add(hbox1);
        vbox.add(Box.createVerticalStrut(8));
        vbox.add(hbox2);
        vbox.add(Box.createVerticalStrut(8));
        vbox.add(hbox3);
        vbox.add(Box.createVerticalStrut(8));
        vbox.add(hbox4);
        vbox.add(Box.createVerticalStrut(8)); 
        vbox.add(hbox5); 
        vbox.add(Box.createVerticalGlue());
                  
        JPanel textPanel = new JPanel();
        textPanel.add(vbox);
        
        JPanel buttonPanel = new JPanel();
        buttonPanel.add(queryButton);
        buttonPanel.add(updateButton);
        buttonPanel.add(resetButton);
        
        setLayout(new BorderLayout());
        add(textPanel, BorderLayout.CENTER);
        add(buttonPanel, BorderLayout.SOUTH);
        validate();
        

  	  }
  	  
  	  if(selected == 3)      //查询统计界面
  	  {
  	  	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 TeacherPanelAction());
		  
		    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);
		    
  	  }
  	  
  	  if(selected == 4)      //教师个人信息界面
  	  {
  	  	
  	  
  	  	JLabel myLabel = new JLabel("教师个人基本信息维护");
  	  	myLabel.setFont(new Font("TimesRoman",Font.BOLD,20));
        myLabel.setForeground(Color.RED);
        Box hbox1 = Box.createHorizontalBox();
        hbox1.add(myLabel);
        
        numTextField = new JTextField(15);
        numTextField.setEditable(false);
        Box hbox2 = Box.createHorizontalBox();
        hbox2.add(new JLabel("账号："));
        hbox2.add(numTextField);
        
        nameTextField = new JTextField(15);
        nameTextField.setEditable(false);
        Box hbox3 = Box.createHorizontalBox();
        hbox3.add(new JLabel("姓名："));
        hbox3.add(nameTextField);
        
        sexTextField = new JTextField(15);
        Box hbox4 = Box.createHorizontalBox();
        hbox4.add(new JLabel("性别："));
        hbox4.add(sexTextField);
        
        ageTextField = new JTextField(15);
        Box hbox5 = Box.createHorizontalBox();
        hbox5.add(new JLabel("年龄："));
        hbox5.add(ageTextField);
        
        collegeTextField = new JTextField(15);
        Box hbox6 = Box.createHorizontalBox();
        hbox6.add(new JLabel("院系："));
        hbox6.add(collegeTextField);
        
        titleTextField = new JTextField(15);
        Box hbox7 = Box.createHorizontalBox();
        hbox7.add(new JLabel("职称："));
        hbox7.add(titleTextField);
        
        queryButton = new JButton("查询");
        queryButton.addActionListener(new TeacherPanelAction());
      
      
        updateButton = new JButton("更新");
        updateButton.addActionListener(new TeacherPanelAction());
      
        resetButton = new JButton("重置");
        resetButton.addActionListener(new TeacherPanelAction());
      
        Box hbox8 = Box.createHorizontalBox();
        hbox8.add(queryButton);
        hbox8.add(Box.createHorizontalStrut(25));
        hbox8.add(updateButton);
        hbox8.add(Box.createHorizontalStrut(25));
        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);
        
       
  	  }
	  
	  
	}
	
	private class TeacherPanelAction implements ActionListener
	{
		public void actionPerformed(ActionEvent e)
		{
			/**
			   修改密码界面监听
			*/
			if(selected == 0)                                 //修改密码界面事件监听
			{
				if(e.getSource() == changeButton)                //修改密码按钮
				{ 
					newPassword = new String(newPasswordField.getPassword());
					againPassword = new String(againPasswordField.getPassword());
					if(newPassword.equals(againPassword))
					
					{
						
						try
						{