wmstupsycomdialog.java

学生管理系统。使用java编程

			    			JOptionPane.showMessageDialog(this, "学号输入错误！");
			    		}
			    		else
			    		{
						   String sql = " where  yearTerm = '"+ yearTerm+"' and studentid like '%"+id+"%'";
						   iniStuTable(sql);
			    		}
	 	    		}
		    	}
		    	else if(stuCondition.equals("姓名")) 
		    	{
		    		if(flag ==false){
		    		if(name.equals("null"))
		    		{
		    			JOptionPane.showMessageDialog(this,"姓名不能为空！");
		    		}
		    		else
			    	{
				    	String sql =" where yearTerm = '"+ yearTerm+"' and stuname = '"+name+"'";
				    	iniStuTable(sql);
		    		}}
		    		else
		    		{
			    		if(name.equals("null"))
			    		{
			    			JOptionPane.showMessageDialog(this,"姓名不能为空！");
			    		}
			    		else
				    	{
					    	String sql =" where yearTerm = '"+ yearTerm+"' and stuname like '%"+name+"%'";
					    	iniStuTable(sql);
			    		}
		    		}
		    	}

			    }
				if(studyOrPsy.equals("心理"))
		    	{
					if(stuCondition.equals("学号"))
			    	{
						if(flag == false){
			    		if(id==0)
			    		{
			    			JOptionPane.showMessageDialog(this, "学号输入错误！");
			    		}
			    		else
			    		{
						   String sql = " where  yearTerm = '"+ yearTerm+"'  and studentid = "+id;
						   iniPsyTable(sql);
			    		}
						}
						else{
				    		if(id==0)
				    		{
				    			JOptionPane.showMessageDialog(this, "学号输入错误！");
				    		}
				    		else
				    		{
							   String sql = " where  yearTerm = '"+ yearTerm+"'  and studentid like '%"+id+"%'";
							   iniPsyTable(sql);
				    		}
						}
			    	}
			    	else if(stuCondition.equals("姓名")) 
			    	{
			    		if(flag ==false){
			    		if(name.equals("null"))
			    		{
			    			JOptionPane.showMessageDialog(this,"姓名不能为空！");
			    		}
			    		else
				    	{
					    	String sql =" where yearTerm = '"+ yearTerm+"' and stuname = '"+name+"'";
					    	iniPsyTable(sql);
			    		}
			    		}
			    		else
			    		{
				    		if(name.equals("null"))
				    		{
				    			JOptionPane.showMessageDialog(this,"姓名不能为空！");
				    		}
				    		else
					    	{
						    	String sql =" where yearTerm = '"+ yearTerm+"' and stuname like  '%"+name+"%'";
						    	iniPsyTable(sql);
				    		}
			    		}
			    	}

			    }
	    }
	    //复合查询
	    else if(yearTerm.equals("全部")&&!weekOrMonth.equals("全部")&&!studyOrPsy.equals("全部")&&!stuCondition.equals("全部"))
	    {
	    	 if(studyOrPsy.equals("学习"))
			    {		
	 	    	if(stuCondition.equals("学号"))
		    	{
	 	    		if(flag == false){
		    		if(id==0)
		    		{
		    			JOptionPane.showMessageDialog(this, "学号输入错误！");
		    		}
		    		else
		    		{
					   String sql = " where  weekormon = '"+ weekOrMonth+"' and studentid = "+id;
					   iniStuTable(sql);
		    		}}
	 	    		else{
	 	    			if(id==0)
			    		{
			    			JOptionPane.showMessageDialog(this, "学号输入错误！");
			    		}
			    		else
			    		{
						   String sql = " where  weekormon = '"+ weekOrMonth+"' and studentid like '%"+id+"%'";
						   iniStuTable(sql);
			    		}
	 	    		}
		    	}
		    	else if(stuCondition.equals("姓名")) 
		    	{
		    		if(flag == false){
		    		if(name.equals("null"))
		    		{
		    			JOptionPane.showMessageDialog(this,"姓名不能为空！");
		    		}
		    		else
			    	{
				    	String sql =" where weekormon = '"+ weekOrMonth+"' and stuname = '"+name+"'";
				    	iniStuTable(sql);
		    		}
		    		}
		    		else
		    		{
			    		if(name.equals("null"))
			    		{
			    			JOptionPane.showMessageDialog(this,"姓名不能为空！");
			    		}
			    		else
				    	{
					    	String sql =" where weekormon = '"+ weekOrMonth+"' and stuname like '%"+name+"%'";
					    	iniStuTable(sql);
			    		}
		    		}
		    	}

			    }
				if(studyOrPsy.equals("心理"))
		    	{
					if(stuCondition.equals("学号"))
			    	{
						if(flag == false)
						{
			    		if(id==0)
			    		{
			    			JOptionPane.showMessageDialog(this, "学号输入错误！");
			    		}
			    		else
			    		{
						   String sql = " where  weekormon = '"+ weekOrMonth+"' and studentid = "+id;
						   iniPsyTable(sql);
			    		}
						}
						else
						{
				    		if(id==0)
				    		{
				    			JOptionPane.showMessageDialog(this, "学号输入错误！");
				    		}
				    		else
				    		{
							   String sql = " where  weekormon = '"+ weekOrMonth+"' and studentid like '%"+id+"%'";
							   iniPsyTable(sql);	
				    		} 
				    		}
						}
			    	else if(stuCondition.equals("姓名")) 
			    	{
			    		if(flag == false)
			    		{
			    		if(name.equals("null"))
			    		{
			    			JOptionPane.showMessageDialog(this,"姓名不能为空！");
			    		}
			    		else
				    	{
					    	String sql =" where weekormon = '"+ weekOrMonth+"' and stuname = '"+name+"'";
					    	iniPsyTable(sql);
			    		}
			    		}
			    		else
			    		{
				    		if(name.equals("null"))
				    		{
				    			JOptionPane.showMessageDialog(this,"姓名不能为空！");
				    		}
				    		else
					    	{
						    	String sql =" where weekormon = '"+ weekOrMonth+"' and stuname like '%"+name+"%'";
						    	iniPsyTable(sql);
				    		}
			    		}
			    	}

			    }
	    }
	    else
	    {
	    	if(studyOrPsy.equals("学习"))
		    {		
 	    	if(stuCondition.equals("学号"))
	    	{
 	    		if(flag == false){
	    		if(id==0)
	    		{
	    			JOptionPane.showMessageDialog(this, "学号输入错误！");
	    		}
	    		else
	    		{
				   String sql = " where  yearTerm = '"+ yearTerm+"' and weekormon = '"+ weekOrMonth+"' and studentid = "+id;
				   iniStuTable(sql);
	    		}
 	    		}
 	    		else{
 	    			if(id==0)
 		    		{
 		    			JOptionPane.showMessageDialog(this, "学号输入错误！");
 		    		}
 		    		else
 		    		{
 					   String sql = " where  yearTerm = '"+ yearTerm+"' and weekormon = '"+ weekOrMonth+"' and studentid like  '%"+id+"%'";
 					   iniStuTable(sql);
 		    		}
 	    		}
	    	}
	    	else if(stuCondition.equals("姓名")) 
	    	{
	    		if(flag == false){
	    		if(name.equals("null"))
	    		{
	    			JOptionPane.showMessageDialog(this,"姓名不能为空！");
	    		}
	    		else
		    	{
			    	String sql =" where  yearTerm = '"+ yearTerm+"' and weekormon = '"+ weekOrMonth+"' and stuname = '"+name+"'";
			    	iniStuTable(sql);
	    		}
	    		}
	    		else{
	    			if(name.equals("null"))
		    		{
		    			JOptionPane.showMessageDialog(this,"姓名不能为空！");
		    		}
		    		else
			    	{
				    	String sql =" where  yearTerm = '"+ yearTerm+"' and weekormon = '"+ weekOrMonth+"' and stuname like '%"+name+"%'";
				    	iniStuTable(sql);
		    		}
	    		}
	    	}

		    }
			if(studyOrPsy.equals("心理"))
	    	{
				if(stuCondition.equals("学号"))
		    	{
					if(flag == false){
		    		if(id==0)
		    		{
		    			JOptionPane.showMessageDialog(this, "学号输入错误！");
		    		}
		    		else
		    		{
					   String sql = " where  yearTerm = '"+ yearTerm+"' and weekormon = '"+ weekOrMonth+"' and studentid = "+id;
					   iniPsyTable(sql);
		    		}}
					else
					{
						if(id==0)
			    		{
			    			JOptionPane.showMessageDialog(this, "学号输入错误！");
			    		}
			    		else
			    		{
						   String sql = " where  yearTerm = '"+ yearTerm+"' and weekormon = '"+ weekOrMonth+"' and studentid like '%"+id+"%'";
						   iniPsyTable(sql);
			    		}
					}
		    	}
		    	else if(stuCondition.equals("姓名")) 
		    	{
		    		if(flag == false){
		    		if(name.equals("null"))
		    		{
		    			JOptionPane.showMessageDialog(this,"姓名不能为空！");
		    		}
		    		else
			    	{
				    	String sql =" where  yearTerm = '"+ yearTerm+"' and  weekormon = '"+ weekOrMonth+"'  and stuname = '"+name+"'";
				    	iniPsyTable(sql);
		    		}
		    		}
		    		else
		    		{
			    		if(name.equals("null"))
			    		{
			    			JOptionPane.showMessageDialog(this,"姓名不能为空！");
			    		}
			    		else
				    	{
					    	String sql =" where  yearTerm = '"+ yearTerm+"' and  weekormon = '"+ weekOrMonth+"'  and stuname like '%"+name+"%'";
					    	iniPsyTable(sql);
			    		}
		    		}
		    	}

		    }
	    }
	   }
	/**
	 * 查询条件学号/姓名的下拉框的响应方法
	 * @param evt
	 */
	private void fullComboBoxActionPerformed(ActionEvent evt) {
		//如果选择的为全部
		if(this.fullComboBox.getSelectedItem().equals("全部"))
		{
			//设置模糊查询项不可操作
			this.mixCheckBox.setSelected(false);
			//设置不是模糊查询
			this.mixCheckBox.setEnabled(false);
			//设置文本框中显示查询所有
			this.inputTextField.setText("查询全部");
			//设置文本框不可编辑
			this.inputTextField.setEditable(false);
		}
		else //选择其他
		{
			//模糊查询可以操作
			this.mixCheckBox.setEnabled(true);
			//设置不是模糊查询
			this.mixCheckBox.setSelected(false);
			//设置文本框可以操作
			this.inputTextField.setEditable(true);
			//设置文本框为空
			this.inputTextField.setText("");
		}
	}
	/**
	 * 设置月/周数的方法
	 * @param evt
	 */
	private void weekormonComboBoxActionPerformed(ActionEvent evt) {
		//System.out.println("weekormonComboBox.actionPerformed, event=" + evt);
		//TODO add your code for weekormonComboBox.actionPerformed
		String [] weeknum = new String[]{"1","2","3","4","5","6",
			"7","8","9","10","11","12",
			"13","14","15","16","17","18"};
		String [] monthmnum = new String[]{"1","2","3","4"};
		//如果是周
		if(this.weekormonComboBox.getSelectedItem().equals("周"))
		{
			//设置有1-18周
			numComboBox1Model = new DefaultComboBoxModel(
					weeknum);
		}
		else //如果是月
		{
			//设置有1-4月
			numComboBox1Model = new DefaultComboBoxModel(
					monthmnum);
		}
		//numComboBox1Model = new DefaultComboBoxModel(
				//weeknum);
			//numComboBox1 = new JComboBox();
			//wmStuPsyComPanel.add(numComboBox1);
			numComboBox1.setModel(numComboBox1Model);
			//numComboBox1.setBounds(231, 21, 63, 28);
			
	}
	/**
	 * 获取学期的方法
	 * @return
	 */
	public String getYearTerm()
	{
		String year = (String)this.yeartermComboBox.getSelectedItem();
		String term =(String)this.termComboBox.getSelectedItem();
		String yearTerm =year + term;
		return yearTerm;
	}
	/**
	 * 获取周数/月数的方法
	 * @return
	 */
	public int getNum()
	{
		String num = (String)this.numComboBox1.getSelectedItem();
		int number = Integer.parseInt(num); 
		return number;
	}
	/**
	 * 获取月/周的信息
	 * @return
	 */
	public String getWeekOrMonth()
	{
		String weekOrMonth = (String)this.weekormonComboBox.getSelectedItem();
		if(weekOrMonth.equals("月"))
			weekOrMonth = "M";
		else
			weekOrMonth = "W";
		return weekOrMonth;
	}
	/**
	 * 获取学习评论
	 * @return
	 */