teachermagdialog.java

来自「学生管理系统。使用java编程」· Java 代码 · 共 1,063 行 · 第 1/3 页

		// 如果选中行，且该教师与班级表、考试表、评论表无关联，则执行删除
		if(!bisRight||bisReferenceWmStuPsyCom 
				||bisReferenceExam
				||bisReferenceClass)
		{
			bisRight=false;
		}
		else
		{
			bisRight=true;
		}

		if (bisRight) {
			try {
				Connection conn = null;
				String sql = "delete from teacher where " + "teacherid = " + strteacherId;
				int updateLine = jdbcConnection.updateData(sql);
				if(updateLine > 0){
					dataModel.removeRow(nrow);
					techTable1.setModel(dataModel);
					JOptionPane.showMessageDialog(this, "删除教师信息成功！！");
				}else{
					JOptionPane.showMessageDialog(this, "删除失败！");					
				}

			} catch (Exception e) {
				e.printStackTrace();
				JOptionPane.showMessageDialog(this, "有外键约束，删除失败！！");
			}
		}
	}
	/**
	 *  添加模块
	 * @return
	 */
	public String getteacherId()
	{
		String input = this.teacherIdTextField.getText().trim();
		return input ;
	}
	
	/**
	 * 增加教师信息
	 * @param evt
	 */
	private void addButtonActionPerformed(ActionEvent evt) {
		Vector vecData = new Vector();
		namecontrol=this.namecontrol();
		teaIdcontrol=this.teaIdcontrol();
		agecontrol=this.agecontrol();
		headshipcontrol=this.headshipcontrol();
		if(namecontrol==true&&teaIdcontrol==true&&agecontrol==true&&headshipcontrol==true )
		{
		String  id = getteacherId();
		int teacherId =Integer.parseInt(id);
		String sql = "select * from teacher where teacherId ="+getInput();
		System.out.println(sql);
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		boolean flag = false;
		conn = JdbcConnct.fetchConnection();
		try {
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			if(rs.next())
				flag = true;
			else flag =false;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}		
		if(flag== false)
		{
			
			try
			{
				
				conn = JdbcConnct.fetchConnection();
				System.out.println(conn);
				String gender;
				if(this.genderRadioButton.isSelected())
				{
					 gender="M";
				}
				else
				{
					 gender="W";
				}
				//将政治面貌选择按数据字典转化
				int  poliStatus=1;
				if(this.poliStatusComboBox.getSelectedItem().equals("共青团员"))
				{
					poliStatus = 1 ;
				}
				if(this.poliStatusComboBox.getSelectedItem().equals("党员"))
				{
					poliStatus = 2 ;
				}
				if(this.poliStatusComboBox.getSelectedItem().equals("群众"))
				{
					poliStatus = 3 ;
				}
				if(this.poliStatusComboBox.getSelectedItem().equals("其它党派"))
				{
					poliStatus = 4 ;
				}
				//将职称选择按数据字典转化
				int techLevel=1;
				if(this.techLevelComboBox.getSelectedItem().equals("助理讲师"))
				{
					techLevel = 1 ;
				}
				if(this.techLevelComboBox.getSelectedItem().equals("讲师"))
				{
					techLevel = 2 ;
				}
				if(this.techLevelComboBox.getSelectedItem().equals("副教授"))
				{
					techLevel = 3 ;
				}
				if(this.techLevelComboBox.getSelectedItem().equals("教授"))
				{
					techLevel = 4 ;
				}
			    sql = "insert into teacher(teacherId," +
						"teacherName,gender,poliStatus,age,techLevel,headShip" +
						")" +
						" values("  +
						teacherId+",'"+this.nameTextField.getText()+"',"+
						"'"+gender+"'"+","+poliStatus+",'"
						+this.ageTextField.getText()+ "',"+
						techLevel+ ",'"
						+this.headshipTextField.getText()+ "')";
				System.out.println(sql);
				stmt = conn.createStatement();
				int updateLine = stmt.executeUpdate(sql);
				vecData.addElement(getteacherId());
				vecData.addElement(this.nameTextField.getText());
				//性别
				vecData.addElement(gender);
				//政治面貌
				vecData.addElement(this.poliStatusComboBox.getSelectedItem().toString());
				//年龄
				vecData.addElement(this.ageTextField.getText());
				//职称
				vecData.addElement(this.techLevelComboBox.getSelectedItem().toString());
				//职务
				vecData.addElement(this.headshipTextField.getText());
				
				//dataModel.addRow(vecData);
				
				JOptionPane.showMessageDialog(this, "添加教师成功！！");
				//clear();

			}catch(Exception e)
			{
				e.printStackTrace();
				JOptionPane.showMessageDialog(this, "输入错误，请重新输入");
			}
		}
		else
		{
			JOptionPane.showMessageDialog(this, "此工号已存在！！");
		}
		}
		else
		{
			
			JOptionPane.showMessageDialog(this, "请填入必填内容！！");
		}
		
	}
	
	/**
	 * 修改
	 */
	String teacherId = null;
	private void modifyButtonActionPerformed(ActionEvent evt) {
		int row=this.techTable1.getSelectedRow();
		if(row !=-1)
		{
	   teacherId = (String) this.techTable1.getValueAt(row,0);
		String teacherName = (String) this.techTable1.getValueAt(row,1);
		String gender= (String) this.techTable1.getValueAt(row,2);
		String poliStatus = (String) this.techTable1.getValueAt(row,3);
		String age = (String) this.techTable1.getValueAt(row,4);
		String techLevel = (String) this.techTable1.getValueAt(row,5);
		String headShip = (String) this.techTable1.getValueAt(row,6);
		this.teacherIdTextField.setText(teacherId);
		this.nameTextField.setText(teacherName);
		if(gender.equals("男"))
			this.genderRadioButton.setSelected(true);
		else this.genderRadioButton1.setSelected(true);
		this.poliStatusComboBox.setSelectedItem(poliStatus);
		this.techLevelComboBox.setSelectedItem(techLevel);
		this.ageTextField.setText(age);
		
		this.headshipTextField.setText(headShip);
		}
		else 
		{
			JOptionPane.showMessageDialog(this, "没有选定");
		}
	}
	/*
	 * 确定
	 * 
	 */
	private void okButtonActionPerformed(ActionEvent evt) {
		String teacherid = getteacherId();
		String teachername = this.nameTextField.getText().trim();
		String poliStatus=(String) this.poliStatusComboBox.getSelectedItem();
		int status = 0;
		if(poliStatus.equals("共青团员"))
			status = 1;
		else if(poliStatus.equals("党员"))
			status = 2;
		else if(poliStatus.equals("群众"))
				status = 3;
		else  if(poliStatus.equals("其它党派"))
			   status = 4;
		String age=this.ageTextField.getText();
		String techLevel=(String) this.techLevelComboBox.getSelectedItem();
		int teacherLevel;
		if(techLevel.equals("助理讲师"))
			teacherLevel = 1;
		else if(techLevel.equals("助理讲师"))
			teacherLevel = 2;
		else if(techLevel.equals("副教授"))
			teacherLevel = 3;
		else
			teacherLevel = 4;
		String headShip=this.headshipTextField.getText();
		
		namecontrol=this.namecontrol();
		teaIdcontrol=this.teaIdcontrol();
		agecontrol=this.agecontrol();
		headshipcontrol=this.headshipcontrol();
		if(namecontrol==true&&teaIdcontrol==true&&agecontrol==true&&headshipcontrol==false){
		try
		{	
			Connection conn = JdbcConnct.fetchConnection();
			System.out.println(conn);
			String gender= null;
			if(this.genderRadioButton.isSelected())
			{
				 gender="M";
			}
			else
			{
				 gender="W";
			}
		    String sql = "update  teacher set "+
		         "teacherId = " +teacherid+
					",teacherName = '" + teachername +"'"+
					",gender= '" +gender+"'"+
					",poliStatus= " +status+
					",age= '" + age +
					"',techLevel = " + teacherLevel+
					",headShip ='" + headShip +"'"+
					" where teacherid=" + teacherId;
			System.out.print(sql);
		 Statement 	stmt = conn.createStatement();
			int updateLine = stmt.executeUpdate(sql);
			JOptionPane.showMessageDialog(this, "修改成功！！");
			//clear();

		}catch(Exception e)
		{
			JOptionPane.showMessageDialog(this, "输入错误，请重新输入");
		}
		}
		else
			;
	}
	//控制姓名的输入
	public boolean   namecontrol(){
		//姓名的控制 范围在（0，100]
		boolean namecontrol=false;
	    if(this.nameTextField.getText().length()==0)
	    	{JOptionPane.showMessageDialog(this, "姓名输入为空，请重新输入");
	    namecontrol=false;}
	    else if(this.nameTextField.getText().length()>10)
	    	{JOptionPane.showMessageDialog(this, "姓名输入超过10，请重新输入");
	    namecontrol=false;}
	    else
	    	namecontrol=true;
	    return namecontrol;
	}
	
	    //工号的控制 正则表达式
	public boolean   teaIdcontrol(){
		boolean teaIdcontrol=false;
	    if(this.teacherIdTextField.getText().matches(REG_DIGTEAID))
	    	teaIdcontrol=true;
	    	
	    else
	    	{JOptionPane.showMessageDialog(this, "教师工号输入错误，请重新输入");
	    	teaIdcontrol=false;
	    	}
	    return teaIdcontrol;
	    
	}
	    /*
	     * 年龄的正则表达式控制输入
	     */
	public boolean   agecontrol(){
		boolean agecontrol=false;
	    if(this.ageTextField.getText().matches(REG_DIGAGE))
	    	agecontrol=true;
	    else
	    	{JOptionPane.showMessageDialog(this, "年龄输入错误，请重新输入，范围在1到99之间");
	    	agecontrol=false;}
	    return  agecontrol ;
	}
	    /*
	     * 职务的输入控制
	     */
	public boolean   headshipcontrol(){
		boolean headshipcontrol=false;
	    if(this.headshipTextField.getText().length()<100)
	    	headshipcontrol=true;
	    else
	    	{
	    	JOptionPane.showMessageDialog(this, "职务描述不能超过100个字符，请重新输入");
	    	headshipcontrol=false;
	    	}
	    return headshipcontrol;
	    	
	}
	
	private void querComboBox1ActionPerformed(ActionEvent evt) {
		System.out.println("querConditionComboBox1.actionPerformed, event=" + evt);
		if(this.querComboBox1.getSelectedItem().equals("全部"))
			{
			this.querTextField1.setText("请输入查询条件");
			this.blurCheckBox.setSelected(false);
			this.querTextField1.setEnabled(false);
			this.blurCheckBox.setEnabled(false);}
		else 
		{
			this.querTextField1.setText("");
			this.querTextField1.setEnabled(true);
			this.blurCheckBox.setEnabled(true);}
	}
	
	private void techTable1MouseClicked(MouseEvent evt) {
		
	}

}