studymainframe.java

包含了学生管理系统的一些基本操作以及相关窗口页面实现。

					}
					{
						ComboBoxModel yearjComboBoxModel = new DefaultComboBoxModel(
							new String[] { null, "第一学期" , "第二学期", "第三学期", "第四学期"
									, "第五学期", "第六学期", "第七学期", "第八学期"});
						yearjComboBox = new JComboBox();
						studyjPanel.add(yearjComboBox);
						yearjComboBox.setModel(yearjComboBoxModel);
						yearjComboBox.setBounds(357, 56, 77, 28);
					}
					{
						jLabel1 = new JLabel();
						studyjPanel.add(jLabel1);
						jLabel1.setText("/");
						jLabel1.setBounds(518, 56, 14, 28);
					}
				}
			}
			{
				addjButton = new JButton();
				getContentPane().add(addjButton);
				addjButton.setText("\u6dfb\u52a0");
				addjButton.setBounds(14, 385, 77, 28);
				addjButton.addActionListener(new ActionListener() {
					public void actionPerformed(ActionEvent evt) {
						addjButtonActionPerformed(evt);
					}
				});
			}
			{
				updatejButton = new JButton();
				getContentPane().add(updatejButton);
				updatejButton.setText("\u4fee\u6539");
				updatejButton.setBounds(140, 385, 77, 28);
				updatejButton.addActionListener(new ActionListener() {
					public void actionPerformed(ActionEvent evt) {
						updatejButtonActionPerformed(evt);
					}
				});
			}
			{
				deljButton = new JButton();
				getContentPane().add(deljButton);
				deljButton.setText("\u5220\u9664");
				deljButton.setBounds(266, 385, 77, 28);
				deljButton.addActionListener(new ActionListener() {
					public void actionPerformed(ActionEvent evt) {
						deljButtonActionPerformed(evt);
					}
				});
			}
			{
				backjButton = new JButton();
				getContentPane().add(backjButton);
				backjButton.setText("\u8fd4\u56de");
				backjButton.setBounds(399, 385, 77, 28);
				backjButton.addActionListener(new ActionListener() {
					public void actionPerformed(ActionEvent evt) {
						backjButtonActionPerformed(evt);
					}
				});
			}
			pack();
			setSize(630, 450);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public void gettable(String stuid,String name,String xuexi,String xinli,String week,String month,String year){
		studyjTableModel = new DefaultTableModel();
		studyjTableModel.addColumn("学号");
		studyjTableModel.addColumn("姓名");
		studyjTableModel.addColumn("学习情况");
		studyjTableModel.addColumn("心理情况");
		studyjTableModel.addColumn("周时间");
		studyjTableModel.addColumn("月时间");
		studyjTableModel.addColumn("学期");
		sa.FristSelect(s1,s2,s3,s4,s5,s6,s7,studyjTableModel,this.page);//初始化页面
		studyjTable = new JTable();
		studyjScrollPane.setViewportView(studyjTable);
		studyjTable.setModel(studyjTableModel);
		studyjTable.setPreferredSize(new java.awt.Dimension(602, 77));
	}
	
	private void backjButtonActionPerformed(ActionEvent evt) {
		StudentManagerFrame smf=new StudentManagerFrame();
		this.setVisible(false);
		smf.setVisible(true);
	}
	
	private void addjButtonActionPerformed(ActionEvent evt) {
		StudyAddFrame saf=new StudyAddFrame(this);
		saf.setModal(true);
		saf.setVisible(true);
	}
	
	private void headjButtonActionPerformed(ActionEvent evt) {
		page=1;
		gettable(s1,s2,s3,s4,s5,s6,s7);
	}
	
	private void upjButtonActionPerformed(ActionEvent evt) {
		if(page!=1){
	    	page=page-1;
			gettable(s1,s2,s3,s4,s5,s6,s7);
	    }
	    else{
	    	JOptionPane.showMessageDialog(this,"已经是首页");
	    }
	}
	
	private void nextjButtonActionPerformed(ActionEvent evt) {
		if(page!=sa.page(s1,s2,s3,s4,s5,s6,s7)){
			page=page+1;
			gettable(s1,s2,s3,s4,s5,s6,s7);
		}
		else{
			JOptionPane.showMessageDialog(this,"已经是尾页");
		}
	}
	
	private void lastjButtonActionPerformed(ActionEvent evt) {
		page=sa.page(s1,s2,s3,s4,s5,s6,s7);
		gettable(s1,s2,s3,s4,s5,s6,s7);
	}
	
	private void updatejButtonActionPerformed(ActionEvent evt) {
		try {	
			StudyUpdateFrame suf=new StudyUpdateFrame();
			String stuid =studyjTable.getValueAt(studyjTable.getSelectedRow(), 0).toString();
			String week=studyjTable.getValueAt(studyjTable.getSelectedRow(), 4).toString();
			String month=studyjTable.getValueAt(studyjTable.getSelectedRow(), 5).toString();
			String year=studyjTable.getValueAt(studyjTable.getSelectedRow(), 6).toString();
		    System.out.println(stuid);
			if(stuid.equals("")||week.equals("")||month.equals("")||year.equals("")){
			}
			else{
				sa.getStudyAll(stuid,week,month,year,suf);
				suf.setModal(true);
				suf.setVisible(true); 
				gettable(s1,s2,s3,s4,s5,s6,s7);	
			}
		} catch (Exception e) {
			// TODO: handle exception
			JOptionPane.showMessageDialog(this, "请选择要修改的行!");
		}
	}
	
	private void deljButtonActionPerformed(ActionEvent evt) {
		try {	
			String stuid =studyjTable.getValueAt(studyjTable.getSelectedRow(), 0).toString();
			String week=studyjTable.getValueAt(studyjTable.getSelectedRow(), 4).toString();
			String month=studyjTable.getValueAt(studyjTable.getSelectedRow(), 5).toString();
			String year=studyjTable.getValueAt(studyjTable.getSelectedRow(), 6).toString();
			if(stuid.equals("")||week.equals("")||month.equals("")||year.equals("")){			
			}
			else
			{
				int control=JOptionPane.showConfirmDialog(this, "真的要删除吗？","警告！",JOptionPane.OK_OPTION);
				if(JOptionPane.OK_OPTION==control)
				{
					sa.deleteStudy(stuid, week, month, year);
					studyjTableModel.removeRow(studyjTable.getSelectedRow());
					gettable(s1,s2,s3,s4,s5,s6,s7);	
				}
			}
		} catch (Exception e) {
			// TODO: handle exception
			JOptionPane.showMessageDialog(this, "请选择要删除的行!");
		}
	}
	
	private void selectjButtonActionPerformed(ActionEvent evt) {
		page=1;
		if(stujTextField.getText().equals("")&&namejTextField.getText().equals("")&&studyjComboBox.getSelectedItem()==null
				&&mindjComboBox.getSelectedItem()==null&&yearjComboBox.getSelectedItem()==null&&monthjComboBox.getSelectedItem()==null&&weekjComboBox.getSelectedItem()==null){
			JOptionPane.showMessageDialog(this, "请至少输入一个查询条件！");
		}
		else{
			if(isTPF(stujTextField.getText())||isTPF(namejTextField.getText())){
				JOptionPane.showMessageDialog(this, "不可输入通配符");
			}
			else{
			s1=stujTextField.getText();
			s2=namejTextField.getText();
			if(studyjComboBox.getSelectedItem()==null){
				s3="";
			}
			else{
				s3=studyjComboBox.getSelectedItem().toString();
			}
			if(mindjComboBox.getSelectedItem()==null){
				s4="";
			}
			else{
				s4=mindjComboBox.getSelectedItem().toString();
			}
			if(weekjComboBox.getSelectedItem()==null){
				s5="";
			}
			else{
				s5=weekjComboBox.getSelectedItem().toString();
			}
			if(monthjComboBox.getSelectedItem()==null){
				s6="";
			}
			else{
				s6=monthjComboBox.getSelectedItem().toString();
			}
			if(yearjComboBox.getSelectedItem()==null){
				s7="";
			}
			else{
				s7=yearjComboBox.getSelectedItem().toString();
			}
			studyjTable = new JTable();
			studyjTableModel = new DefaultTableModel();
			studyjTableModel.addColumn("学号");
			studyjTableModel.addColumn("姓名");
			studyjTableModel.addColumn("学习情况");
			studyjTableModel.addColumn("心理情况");
			studyjTableModel.addColumn("周时间");
			studyjTableModel.addColumn("月时间");
			studyjTableModel.addColumn("学期");
			sa.FristSelect(s1, s2, s3, s4, s5, s6, s7, studyjTableModel,this.page);
			studyjScrollPane.setViewportView(studyjTable);
			studyjTable.setModel(studyjTableModel);
			studyjTable.setPreferredSize(new java.awt.Dimension(602, 77));
		}
	}
	}
	public boolean isTPF(String s) {
		if (s.indexOf('_') != -1 || s.indexOf('%') != -1
				|| s.indexOf('?') != -1 || s.indexOf("'") != -1) {
			return true;
		}
		return false;
	}
}