wmstupsycomdialog.java

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

					anLabel.setText("  \u6309");
					anLabel.setPreferredSize(new java.awt.Dimension(56, 28));
				}
				{
					ComboBoxModel fullComboBoxModel = new DefaultComboBoxModel(
						new String[] { "全部", "学号", "姓名" });
					fullComboBox = new JComboBox();
					showTablePanel1.add(fullComboBox, new AnchorConstraint(182, 295, 243, 129, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
					fullComboBox.setModel(fullComboBoxModel);
					fullComboBox.setPreferredSize(new java.awt.Dimension(91, 28));
					fullComboBox.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							fullComboBoxActionPerformed(evt);
						}
					});
				}
				{
					inputTextField = new JTextField();
					showTablePanel1.add(inputTextField, new AnchorConstraint(182, 552, 243, 321, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
					inputTextField.setEditable(false);
					inputTextField.setPreferredSize(new java.awt.Dimension(126, 28));
				}
				{
					querButton = new JButton();
					showTablePanel1.add(querButton, new AnchorConstraint(182, 885, 243, 718, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
					querButton.setText("\u67e5\u8be2");
					querButton.setPreferredSize(new java.awt.Dimension(91, 28));
					querButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							querButtonActionPerformed(evt);
						}
					});
				}
				{
					wmSeparator = new JSeparator();
					showTablePanel1.add(wmSeparator, new AnchorConstraint(46, 1000, 940, 988, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
					wmSeparator.setOrientation(SwingConstants.VERTICAL);
					wmSeparator.setPreferredSize(new java.awt.Dimension(7, 413));
				}
			}
			this.setSize(918, 489);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	/**
	 * 退出方法
	 * @param evt
	 */
	private void exsitButtonActionPerformed(ActionEvent evt) {
		this.dispose();//退出
	}
	/**
	 * 获得要查询的年份和学期
	 * @return
	 */
	public String getQueryYearTerm()
	{
		String yearTerm = (String)this.wmStuPsyComComboBox.getSelectedItem();
		return yearTerm;
	}
	/**
	 * 获得要查询的月还是周
	 * @return
	 */
	public String getQueryWeekorMon()
	{
		String weekOrMonth = (String)this.wmComboBox.getSelectedItem();
		if(weekOrMonth.equals("周"))
			return "W";
		else if(weekOrMonth.equals("月"))
			return "M";
        return weekOrMonth;
	}
	/**
	 * 获得要查询的条件是学习还是心理评论。
	 * @return
	 */
	public String getQueryStOrPsyco()
	{
		String studyOrPsy = (String)this.spComboBox.getSelectedItem();
		return studyOrPsy;
	}
	/**
	 * 获得要查询的条件的是学号，姓名等
	 * @return
	 */
	public String getQueryCondition()
	{
		String condition = (String)this.fullComboBox.getSelectedItem();
		return condition;
	}
	/**
	 * 获得输入的查询条件
	 * @return
	 */
	public String getInput()
	{
		String input = this.inputTextField.getText().trim();
		return input;
	}
	/**
	 * 查询评论信息，并把查询结果在表格中显示出来
	 * @param sql1 查询SQL语句
	 */
	public void initialTable(String sql1)
	{
		//定义向量，用来存储查询出来的数据
    	Vector vecData = new Vector();
		try
		{
			//创建并获取连接
		    Connection  conn = JdbcConnct.fetchConnection();
		    //定义并创建Statement
			Statement stmt = conn.createStatement();
			//操作的SQL语句
	    	String sql = "select * from ws_stu_tea";
	    	String sql2 = sql + sql1 +" order by wspsycomid asc";
	    	//定义并获取结果集
			 ResultSet rs = stmt.executeQuery(sql2);
			//对结果集操作
			while(rs.next()){
				//把数据库结果集中数据字典的值输出
				String weekormon = (String)rs.getString("weekormon");
				if(weekormon.equals("M"))
					weekormon = "月";
				else if(weekormon.equals("W"))
					weekormon = "周";
				else weekormon = null;
				//把结果集中的数据存放到向量中。
				vecData.addElement((String)rs.getString("wspsycomid"));
				vecData.addElement((String)rs.getString("yearterm"));
				vecData.addElement("第"+(String)rs.getString("weekmonnum")+weekormon);
				vecData.addElement((String)rs.getString("studentid"));
				vecData.addElement((String)rs.getString("stuname"));
				vecData.addElement((String)rs.getString("psychcomment"));
				vecData.addElement((String)rs.getString("studycomment"));
				vecData.addElement((String)rs.getString("teachername"));
				
		}
			 int row = vecData.size()/8;
			 if(row!=0){
			 String [] title=new String[]{ "评论号","年度","周/月","学号", "姓名","心理评论","学习评论","评论老师" };
			 String[][] aa = new String [row][8] ;
			
			 for(int i=0;i<row;i++)
			 {
				for(int k=0;k<8;k++)
				{
					aa[i][k] = (String)vecData.elementAt(i*8+k);
				}
			 }
			 
			 DefaultTableModel dataModel = new DefaultTableModel(aa,title){
				 public boolean isCellEditable(int row, int column)
				 {
					 return false;
				 }
			 };
			    commentTable.setModel(dataModel);
			    commentTable.setRowHeight(20);
			    //System.out.println(dataModel);
				// System.out.println( commentTable.getModel());
				}
			 else 
			 {
				    commentTable.setModel(commentTableModel);
				    commentTable.setRowHeight(20);
				    JOptionPane.showMessageDialog(this, "对不起，您查找的数据不存在!!");
			 }
	} catch (SQLException e) {
		JOptionPane.showMessageDialog(this, "查询出错！！");
		//e.printStackTrace();
	}

	}
	/**
	 * 查询学习评论，并把数据在表格中显示
	 * @param sql1
	 */
	public void iniStuTable(String sql1)
	{
		
    	Vector vecData = new Vector();
		try
		{
			Connection  conn = JdbcConnct.fetchConnection();
			String sql = "select * from ws_stu_tea";
	    	String sql2 = sql + sql1+" order by wspsycomid asc";
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery(sql2);
		
		while(rs.next()){

			String weekormon = (String)rs.getString("weekormon");
			if(weekormon.equals("M"))
				weekormon = "月";
			else if(weekormon.equals("W"))
				weekormon = "周";
			else weekormon = null;
			vecData.addElement((String)rs.getString("wspsycomid"));
			vecData.addElement((String)rs.getString("yearterm"));
			vecData.addElement("第"+(String)rs.getString("weekmonnum")+weekormon);
			vecData.addElement((String)rs.getString("studentid"));
			vecData.addElement((String)rs.getString("stuname"));
			vecData.addElement((String)rs.getString("studycomment"));
			//vecData.addElement((String)rs.getString("psychcomment"));
			vecData.addElement((String)rs.getString("teachername"));
		}
		
		 int row = vecData.size()/7;
		 if(row!=0){
		 String [] title=new String[]{ "评论号","年度","周/月","学号", "姓名","学习评论","评论老师" };
		 String[][] aa = new String [row][7] ;
		
		 for(int i=0;i<row;i++)
		 {
			for(int k=0;k<7;k++)
			{
				aa[i][k] = (String)vecData.elementAt(i*7+k);
			}
		 }
		 
		 DefaultTableModel dataModel = new DefaultTableModel(aa,title){
			 public boolean isCellEditable(int row, int column)
			 {
				 return false;
			 }
		 };
		    commentTable.setModel(dataModel);
		    commentTable.setRowHeight(20);
		    //System.out.println(dataModel);
			// System.out.println( commentTable.getModel());
			}
		 else 
		 {
			    commentTable.setModel(commentTableModel);
			    commentTable.setRowHeight(20);
			    JOptionPane.showMessageDialog(this, "对不起，您要找的数据不存在！！");
		 }
	} catch (SQLException e) {
		JOptionPane.showMessageDialog(this, "查询出错！！");
		e.printStackTrace();
	}

	}
	/*
	 * 查询心理评论信息，并把数据在表格中显示
	 */
	public void iniPsyTable(String sql1)
	{
    	Vector vecData = new Vector();
		try
		{
	    Connection  conn = JdbcConnct.fetchConnection();
	    String sql = "select * from ws_stu_tea";
    	String sql2 = sql+ sql1 +" order by wspsycomid asc";
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery(sql2);
		
		while(rs.next()){

			String weekormon = (String)rs.getString("weekormon");
			if(weekormon.equals("M"))
				weekormon = "月";
			else if(weekormon.equals("W"))
				weekormon = "周";
			else weekormon = null;
			vecData.addElement((String)rs.getString("wspsycomid"));
			vecData.addElement((String)rs.getString("yearterm"));
			vecData.addElement("第"+(String)rs.getString("weekmonnum")+weekormon);
			vecData.addElement((String)rs.getString("studentid"));
			vecData.addElement((String)rs.getString("stuname"));
			//vecData.addElement((String)rs.getString("studycomment"));
			vecData.addElement((String)rs.getString("psychcomment"));
			vecData.addElement((String)rs.getString("teachername"));
		}
		int row = vecData.size()/7;
		 if(row!=0){
		 String [] title=new String[]{ "评论号","年度","周/月","学号", "姓名","心理评论","评论老师" };
		 String[][] aa = new String [row][7] ;
		
		 for(int i=0;i<row;i++)
		 {
			for(int k=0;k<7;k++)
			{
				aa[i][k] = (String)vecData.elementAt(i*7+k);
			}
		 }
		 
		 DefaultTableModel dataModel = new DefaultTableModel(aa,title){
			 public boolean isCellEditable(int row, int column)
			 {
				 return false;
			 }
		 };
		// dataModel.isCellEditable(row, column)
		    commentTable.setModel(dataModel);
		    commentTable.setRowHeight(20);
		    //System.out.println(dataModel);
			// System.out.println( commentTable.getModel());
			}
		 else 
		 {
			    commentTable.setModel(commentTableModel);
			    commentTable.setRowHeight(20);
			    JOptionPane.showMessageDialog(this, "对不起，您要找的数据不存在！！");
		 }
	} catch (SQLException e) {
		JOptionPane.showMessageDialog(this, "查询出错！！");
		e.printStackTrace();
	}
	 
	}
	/**
	 *获取查询的学号，并判断是否合法
	 * @return
	 */
	public int getQStuId()
	{
		//获取输入的字符串
		String input = getInput();
		//如果为空
    		if(input.equals(""))
    		{
    		//返回0
    			return 0;
    		}
    		else
    		{
    			//如果不为空
    			//定义正则表达式
    			String regex = "\\d{0,9}";
    			if(!input.matches(regex))
    			{
    				//如果不匹配，返回0
    				return 0;
    			}
    			else{
    				//如果匹配，变成int类型返回
		    		int stuId = Integer.parseInt(input);	
		    		return stuId;
    			}
    	}
	}
	/**
	 * 获得查询条件输入的姓名
	 * @return
	 */
	public String getQStuName()
	{
		String input = getInput();
		if(input.equals(""))
			return "null";
		else 
			return input;
	}
	/**
	 * 查询按钮响应方法
	 * @param evt
	 */
	private void querButtonActionPerformed(ActionEvent evt) {
		//定义一个连接
		Connection conn = null;
		// 定义一个SQLStatement状态对象
		Statement statement = null;
		// 定义一个ResultSet结果集对象
		ResultSet rs = null;
		//定义一个Vector变量 vecData 存储数据集
		
		//定义int变量 ncoloumn,数据库表的列数
		//获得SQL语句
		//获得查询学期
	    String yearTerm = getQueryYearTerm();
	    //获取查询月/周
	    String weekOrMonth = getQueryWeekorMon();
	    //获取查心理/学习评论
	    String studyOrPsy = getQueryStOrPsyco();
	    //获取查询条件评论
	    String stuCondition = getQueryCondition(); 
	    //获取输入的查询条件
	    String input = getInput();
	    //获取查询时候输入的学号。
	    int id = getQStuId();
	    //获得查询时候的姓名  
	    String name = getQStuName();
	    //判断是否模糊查询
	    boolean flag = this.mixCheckBox.isSelected();
	    //查询全部
	    if(yearTerm.equals("全部")&&weekOrMonth.equals("全部")&&studyOrPsy.equals("全部")&&stuCondition.equals("全部"))
	    {
	    	String sql ="";
	    	//查询并把数据显示到表格
	    	initialTable(sql);
	    }
	    //按学期查询
	    else if(!yearTerm.equals("全部")&&weekOrMonth.equals("全部")&&studyOrPsy.equals("全部")&&stuCondition.equals("全部"))
	    {

	    	String sql =" where yearterm ='"+yearTerm+"'";
	    	initialTable(sql);
	    	
		    }
	    //按照周/月查询
	    else if(yearTerm.equals("全部")&&!weekOrMonth.equals("全部")&&studyOrPsy.equals("全部")&&stuCondition.equals("全部"))
	    {

	    	String sql = " where weekormon ='"+weekOrMonth+"'";
	    	initialTable(sql);
	    }
	    //按照学习/心理查询
	    else if(yearTerm.equals("全部")&&weekOrMonth.equals("全部")&&!studyOrPsy.equals("全部")&&stuCondition.equals("全部"))
	    {
	    	System.out.println(studyOrPsy);
	    
		    if(studyOrPsy.equals("学习"))
		    {
				String sql = "";
				iniStuTable(sql);