teacher.java

学生选课系统-java做的学生选课系统

						}
					
                         //						擦新
						studentjList.setListData(data.getCourse(StudentcourseNojTextField.getText()));
						
				      }
				}
			});
		}
		return jButton2;
	}

	/**
	 * This method initializes chengjipanel	
	 * 	
	 * @return java.awt.Panel	
	 */
	private Panel getChengjipanel() {
		if (chengjipanel == null) {
			jLabel27 = new JLabel();
			jLabel27.setBounds(new Rectangle(4, 320, 175, 56));
			jLabel27.setFont(new Font("\u65b9\u6b63\u59da\u4f53", Font.BOLD, 36));
			jLabel27.setText("评分管理");
			jLabel26 = new JLabel();
			jLabel26.setBounds(new Rectangle(523, 9, 125, 18));
			jLabel26.setText("课程人数统计表");
			jLabel20 = new JLabel();
			jLabel20.setBounds(new Rectangle(89, 176, 81, 18));
			jLabel20.setText("给于成绩：");
			jLabel19 = new JLabel();
			jLabel19.setBounds(new Rectangle(89, 132, 52, 18));
			jLabel19.setText("班级:");
			jLabel18 = new JLabel();
			jLabel18.setBounds(new Rectangle(89, 96, 52, 18));
			jLabel18.setText("姓名：");
			jLabel17 = new JLabel();
			jLabel17.setBounds(new Rectangle(89, 60, 51, 18));
			jLabel17.setText("学号：");
			jLabel16 = new JLabel();
			jLabel16.setBounds(new Rectangle(90, 9, 75, 18));
			jLabel16.setText("课程编号：");
			chengjipanel = new Panel();
			chengjipanel.setLayout(null);
			chengjipanel.setBounds(new Rectangle(0, 37, 750, 392));
			chengjipanel.add(jLabel16, null);
			chengjipanel.add(getChengjicourseNojTextField(), null);
			chengjipanel.add(getJButton3(), null);
			chengjipanel.add(jLabel17, null);
			chengjipanel.add(jLabel18, null);
			chengjipanel.add(jLabel19, null);
			chengjipanel.add(jLabel20, null);
			chengjipanel.add(getJButton4(), null);
			chengjipanel.add(getChengjiSutendsNojTextField1(), null);
			chengjipanel.add(getChengjiStudentNamejTextField1(), null);
			chengjipanel.add(getStudentclassjTextField1(), null);
			chengjipanel.add(getChegnjijTextField1(), null);
			chengjipanel.add(getChengjijScrollPane1(), null);
			chengjipanel.add(jLabel26, null);
			chengjipanel.add(jLabel27, null);
		}
		return chengjipanel;
	}

	/**
	 * This method initializes chengjijTable	
	 * 	
	 * @return javax.swing.JTable	
	 */
	private JTable getChengjijTable(String courseNo) {
		
			chengjijTable =data.getStudentChengji(courseNo);
			chengjijTable.setRowSelectionAllowed(true);
			chengjijTable.setShowVerticalLines(true);
			chengjijTable.setShowHorizontalLines(true);
			chengjijTable.addMouseListener(new java.awt.event.MouseAdapter() {
				public void mouseClicked(java.awt.event.MouseEvent e) {
					
					
					
					
					int selectRows=chengjijTable.getSelectedRows().length; //  取得用户所选行的行数
		    		DefaultTableModel tableModel = (DefaultTableModel) chengjijTable.getModel();

		    		if(selectRows==1){

		    		  int selectedRowIndex = chengjijTable.getSelectedRow(); // 取得用户所选单行 
		    		
		    		     chengjiSutendsNojTextField1.setText((String) tableModel.getValueAt(selectedRowIndex, 0));
		    		     chengjiStudentNamejTextField1.setText((String) tableModel.getValueAt(selectedRowIndex, 1));
		    		     studentclassjTextField1.setText((String) tableModel.getValueAt(selectedRowIndex, 2));
		    		     chegnjijTextField1.setText((String) tableModel.getValueAt(selectedRowIndex, 3));
		    		  }
					
				}
			});
		    return chengjijTable;
	}

	/**
	 * This method initializes chengjicourseNojTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getChengjicourseNojTextField() {
		if (chengjicourseNojTextField == null) {
			chengjicourseNojTextField = new JTextField();
			chengjicourseNojTextField.setBounds(new Rectangle(174, 7, 82, 22));
			chengjicourseNojTextField.setText("1001");
		}
		return chengjicourseNojTextField;
	}

	/**
	 * This method initializes jButton3	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton3() {
		if (jButton3 == null) {
			jButton3 = new JButton();
			jButton3.setBounds(new Rectangle(274, 5, 63, 22));
			jButton3.setText("浏览");
			jButton3.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					chengjijScrollPane1.setViewportView(getChengjijTable(chengjicourseNojTextField.getText()));
				}
			});
		}
		return jButton3;
	}

	/**
	 * This method initializes jButton4	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton4() {
		if (jButton4 == null) {
			jButton4 = new JButton();
			jButton4.setBounds(new Rectangle(165, 216, 64, 23));
			jButton4.setText("评分");
			jButton4.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					
					if(!chegnjijTextField1.getText().equals("没出"))
					{
						 String QueryString="update 学生选课表 set  成绩='"+ chegnjijTextField1.getText()+"'"
					      +"  where 课程编号='"+chengjicourseNojTextField.getText().trim()+"'"+"  and  学号='"+chengjiSutendsNojTextField1.getText()+"'";
					      data.updata(QueryString); 
					      //擦新
					      chengjijScrollPane1.setViewportView(getChengjijTable(chengjicourseNojTextField.getText()));
					}
					
					
				}
			});
		}
		return jButton4;
	}

	/**
	 * This method initializes chengjiSutendsNojTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getChengjiSutendsNojTextField1() {
		if (chengjiSutendsNojTextField1 == null) {
			chengjiSutendsNojTextField1 = new JTextField();
			chengjiSutendsNojTextField1.setBounds(new Rectangle(184, 67, 105, 22));
			chengjiSutendsNojTextField1.setEnabled(false);
		}
		return chengjiSutendsNojTextField1;
	}

	/**
	 * This method initializes chengjiStudentNamejTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getChengjiStudentNamejTextField1() {
		if (chengjiStudentNamejTextField1 == null) {
			chengjiStudentNamejTextField1 = new JTextField();
			chengjiStudentNamejTextField1.setBounds(new Rectangle(184, 98, 105, 22));
			chengjiStudentNamejTextField1.setEnabled(false);
		}
		return chengjiStudentNamejTextField1;
	}

	/**
	 * This method initializes studentclassjTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getStudentclassjTextField1() {
		if (studentclassjTextField1 == null) {
			studentclassjTextField1 = new JTextField();
			studentclassjTextField1.setBounds(new Rectangle(184, 132, 163, 22));
			studentclassjTextField1.setEnabled(false);
		}
		return studentclassjTextField1;
	}

	/**
	 * This method initializes chegnjijTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getChegnjijTextField1() {
		if (chegnjijTextField1 == null) {
			chegnjijTextField1 = new JTextField();
			chegnjijTextField1.setBounds(new Rectangle(183, 171, 109, 22));
		}
		return chegnjijTextField1;
	}

	/**
	 * This method initializes chengjijScrollPane1	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */
	private JScrollPane getChengjijScrollPane1() {
		if (chengjijScrollPane1 == null) {
			chengjijScrollPane1 = new JScrollPane();
			chengjijScrollPane1.setBounds(new Rectangle(348, 27, 395, 351));
		}
		return chengjijScrollPane1;
	}

	/**
	 * This method initializes jMenu4	
	 * 	
	 * @return javax.swing.JMenu	
	 */
	private JMenu getJMenu4() {
		if (jMenu4 == null) {
			jMenu4 = new JMenu();
			jMenu4.setText("成绩录入");
			jMenu4.add(getChengjijMenuItem());
		}
		return jMenu4;
	}

	/**
	 * This method initializes chengjijMenuItem	
	 * 	
	 * @return javax.swing.JMenuItem	
	 */
	private JMenuItem getChengjijMenuItem() {
		if (chengjijMenuItem == null) {
			chengjijMenuItem = new JMenuItem();
			chengjijMenuItem.setText("录入");
			chengjijMenuItem.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					turnToPanel(e); // TODO Auto-generated Event stub actionPerformed()
				}
			});
		}
		return chengjijMenuItem;
	}

	/**
	 * This method initializes classNojTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getClassNojTextField() {
		if (classNojTextField == null) {
			classNojTextField = new JTextField();
			classNojTextField.setBounds(new Rectangle(645, 27, 98, 22));
			classNojTextField.setText("078021");
		}
		return classNojTextField;
	}

	/**
	 * This method initializes userMangerpanel	
	 * 	
	 * @return java.awt.Panel	
	 */
	private Panel getUserMangerpanel() {
		if (userMangerpanel == null) {
			label = new Label();
			label.setBounds(new Rectangle(235, 178, 58, 23));
			label.setText("确认码：");
			jLabel51 = new JLabel();
			jLabel51.setBounds(new Rectangle(236, 132, 52, 18));
			jLabel51.setText("新密码：");
			userMangerpanel = new Panel();
			userMangerpanel.setLayout(null);
			userMangerpanel.setBounds(new Rectangle(0, 37, 750, 392));
			userMangerpanel.add(jLabel51, null);
			userMangerpanel.add(label, null);
			userMangerpanel.add(getPasswordjTextField(), null);
			userMangerpanel.add(getNewPasswordjTextField(), null);
			userMangerpanel.add(getOkjButton5(), null);
			userMangerpanel.add(getJButton5(), null);
		}
		return userMangerpanel;
	}

	/**
	 * This method initializes passwordjTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getPasswordjTextField() {
		if (passwordjTextField == null) {
			passwordjTextField = new JTextField();
			passwordjTextField.setBounds(new Rectangle(312, 133, 141, 22));
		}
		return passwordjTextField;
	}

	/**
	 * This method initializes newPasswordjTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getNewPasswordjTextField() {
		if (newPasswordjTextField == null) {
			newPasswordjTextField = new JTextField();
			newPasswordjTextField.setBounds(new Rectangle(312, 175, 135, 22));
		}
		return newPasswordjTextField;
	}

	/**
	 * This method initializes okjButton5	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getOkjButton5() {
		if (okjButton5 == null) {
			okjButton5 = new JButton();
			okjButton5.setBounds(new Rectangle(278, 230, 68, 23));
			okjButton5.setText("重置");
			okjButton5.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					passwordjTextField.setText(""); // TODO Auto-generated Event stub actionPerformed()
					newPasswordjTextField.setText("");
				}
			});
		}
		return okjButton5;
	}

	/**
	 * This method initializes jButton5	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton5() {
		if (jButton5 == null) {
			jButton5 = new JButton();
			jButton5.setBounds(new Rectangle(381, 230, 64, 24));
			jButton5.setText("确定");
			jButton5.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					
					if(passwordjTextField.getText().equals(newPasswordjTextField.getText())
					 &!passwordjTextField.getText().equals(""))
					{
						  String QueryString="update 教师表 set  密码='"+passwordjTextField.getText()+"'"+
						  "   where  教师名='"+teacherName.trim()+"'";
						
						data.updata(QueryString); 
					}
				}
			});
		}
		return jButton5;
	}

	/**
	 * This method initializes jMenu5	
	 * 	
	 * @return javax.swing.JMenu	
	 */
	private JMenu getJMenu5() {
		if (jMenu5 == null) {
			jMenu5 = new JMenu();
			jMenu5.setText("用户");
			jMenu5.add(getPasswordjMenuItem());
		}
		return jMenu5;
	}

	/**
	 * This method initializes passwordjMenuItem	
	 * 	
	 * @return javax.swing.JMenuItem	
	 */
	private JMenuItem getPasswordjMenuItem() {
		if (passwordjMenuItem == null) {
			passwordjMenuItem = new JMenuItem();
			passwordjMenuItem.setText("修改密码");
			passwordjMenuItem.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					turnToPanel(e); // TODO Auto-generated Event stub actionPerformed()
				}
			});
		}
		return passwordjMenuItem;
	}

	/**
	 * This method initializes zhuxiaojButton6	
	 * 	
	 *