stumainframe.java

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

						selectjButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								selectjButtonActionPerformed(evt);
							}
						});
					}
					{
						classjTextField = new JTextField();
						jPanel.add(classjTextField);
						classjTextField.setBounds(91, 56, 133, 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 s1,String s2,String s3,String s4,String s5,String s6,String s7){
		stujTable = new JTable();
		stujTableModel = new DefaultTableModel();
		stujTableModel.addColumn("学号");
	    stujTableModel.addColumn("姓名");
	    stujTableModel.addColumn("性别");
	    stujTableModel.addColumn("出生日期");
	    stujTableModel.addColumn("家庭住址");
	    stujTableModel.addColumn("所在班级");
		stujScrollPane.setViewportView(stujTable);
		StuAction sa  = new StuAction();
		sa.select(s1,s2,s3,s4,s5,s6,s7,stujTableModel,this.page);//初始化页面
		stujTable.setModel(stujTableModel);
		stujTable.setPreferredSize(new java.awt.Dimension(623, 77));
	}
	private void backjButtonActionPerformed(ActionEvent evt) {
		StudentManagerFrame smf=new StudentManagerFrame();
		this.setVisible(false);
		smf.setVisible(true);
	}
	
	/**
	 * 点击添加按钮弹出StuAddFrame
	 * @param evt
	 */
	private void addjButtonActionPerformed(ActionEvent evt) {
		StuAddFrame saf=new StuAddFrame(this);
		saf.setModal(true);//设置StuMainFrame不能做任何操作
		saf.setVisible(true);//设置StuAddFrame可见
	}
	
	/**
	 * 选择数据栏中一项在点击修改按钮将数据栏中的对象传到StuUpdateFrame中
	 * @param evt
	 */
	private void updatejButtonActionPerformed(ActionEvent evt) {
		try{
		 StuUpdateFrame suf=new StuUpdateFrame(this);
		 String stuid=stujTable.getValueAt(stujTable.getSelectedRow(), 0).toString(); 
		 if(stuid.equals("")){
			 JOptionPane.showMessageDialog(this, "请先选择要修改的行");
			}
			else{
				sa.setValue(stuid, suf);
				suf.setModal(true);
				suf.setVisible(true);
//				gettable();
			} 
		}catch (Exception e) {
				// TODO: handle exception
				JOptionPane.showMessageDialog(this, "请选择要修改的行!");
			}
			
 }
	/**
	 * 从数据栏中删除数据
	 * @param evt
	 */
	private void deljButtonActionPerformed(ActionEvent evt) {
		try {	
			Object n=stujTable.getValueAt(stujTable.getSelectedRow(),0 );
			String stuid=n.toString();
			StuAction sa = new StuAction();
			if(stuid.equals("")){			
			}
			else
			{
				int control=JOptionPane.showConfirmDialog(this, "真的要删除吗？","警告！",JOptionPane.OK_OPTION);
				if(JOptionPane.OK_OPTION==control)
				{
					sa.delete(stuid);
					stujTableModel.removeRow(stujTable.getSelectedRow());
					
				}
			}
		} catch (Exception e) {
			// TODO: handle exception
			JOptionPane.showMessageDialog(this, "请选择要删除的行!");
		}
	}
	
	private void selectjButtonActionPerformed(ActionEvent evt) {
		page=1;
		
		if(this.stujTextField.getText().equals("")&&this.namejTextField.getText().equals("")&&this.sexjComboBox.getSelectedItem()==null&&yearjComboBox1.getSelectedItem()==null&&yearjComboBox2.getSelectedItem()==null
				&&addjTextField.getText().equals("")&&classjTextField.getText().equals("")){
			JOptionPane.showMessageDialog(this, "请至少输入一个查询条件！");
		}
		else{
		if(isTPF(stujTextField.getText())||isTPF(namejTextField.getText())||isTPF(addjTextField.getText())||isTPF(classjTextField.getText())){
			JOptionPane.showMessageDialog(this, "不可输入通配符");
		}
		else{
			
			int s8,s9;
			s1=stujTextField.getText();
			s2=namejTextField.getText();
			if(sexjComboBox.getSelectedItem()!=null){
				s3=sexjComboBox.getSelectedItem().toString();
			}
			else{
				s3="";
			}
			if(this.yearjComboBox1.getSelectedItem()!=null)
			{
				s4=this.yearjComboBox1.getSelectedItem().toString()+"-1-1";
			}
			else
			{
				s4="1970-1-1";
			}
            if(this.yearjComboBox2.getSelectedItem()!=null)
            {
            	s5=this.yearjComboBox2.getSelectedItem().toString()+"-1-1";
            }
            else
            {
            	s5="2010-1-1";
            }
			s6=addjTextField.getText();
			s7=classjTextField.getText();
			s8=Integer.parseInt(s4.substring(0, 4));
	        s9=Integer.parseInt(s5.substring(0, 4));
	            if(s8>s9)
	            {
	            	JOptionPane.showMessageDialog(this, "年龄段的输入不合规范！");
	            }
	            else
	            {
	            	stujTable = new JTable();
	        		stujTableModel = new DefaultTableModel();
	        		stujTableModel.addColumn("学号");
	        	    stujTableModel.addColumn("姓名");
	        	    stujTableModel.addColumn("性别");
	        	    stujTableModel.addColumn("出生日期");
	        	    stujTableModel.addColumn("家庭住址");
	        	    stujTableModel.addColumn("所在班级");
	        		stujScrollPane.setViewportView(stujTable);
	        		StuAction sa  = new StuAction();
	        		sa.select(s1, s2, s3, s4, s5, s6, s7, stujTableModel,this.page);
	        		stujTable.setModel(stujTableModel);
	        		stujTable.setPreferredSize(new java.awt.Dimension(623, 77));
	            }
		}
	}
}
	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 lastButtonActionPerformed(ActionEvent evt) {
		page=sa.page(s1,s2,s3,s4,s5,s6,s7);
		gettable(s1,s2,s3,s4,s5,s6,s7);
	}
	public boolean isTPF(String s) {
		if (s.indexOf('_') != -1 || s.indexOf('%') != -1
				|| s.indexOf('?') != -1 || s.indexOf("'") != -1) {
			return true;
		}
		return false;
	}
}