tesmainframe.java

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

						{
							tesTeaLabel = new JLabel();
							tesPanel2.add(tesTeaLabel);
							tesTeaLabel.setText("\u76d1\u8003\u4eba\u5458\uff1a");
							tesTeaLabel.setBounds(308, 70, 77, 28);
						}
						{
							ComboBoxModel tesDateComboBoxModel = new DefaultComboBoxModel();
							tesDateComboBox = new JComboBox();
							tesPanel2.add(tesDateComboBox);
							tesDateComboBox.setModel(tesDateComboBoxModel);
							tesDateComboBox.setBounds(126, 126, 140, 28);
							tesDateComboBox.addItem("");
							ta.tesdate(tesDateComboBox,0);//升序

						}
						{
							ComboBoxModel tesDate2ComboBoxModel = new DefaultComboBoxModel();
							tesDate2ComboBox = new JComboBox();
							tesPanel2.add(tesDate2ComboBox);
							tesDate2ComboBox.setModel(tesDate2ComboBoxModel);
							tesDate2ComboBox.setBounds(287, 126, 140, 28);
							tesDate2ComboBox.addItem("");
                            ta.tesdate(tesDate2ComboBox, 1);//降序
						}
						{
							Label1 = new JLabel();
							tesPanel2.add(Label1);
							Label1.setText(" \u81f3");
							Label1.setBounds(266, 126, 21, 28);
						}
						{
							selectButton = new JButton();
							tesPanel2.add(selectButton);
							selectButton.setText("\u67e5\u8be2");
							selectButton.setBounds(504, 127, 77, 28);
							selectButton.addActionListener(new ActionListener() {
								public void actionPerformed(ActionEvent evt) {
									selectButtonActionPerformed(evt);
								}
								});
						}
						{
							teaTextField = new JTextField();
							tesPanel2.add(teaTextField);
							teaTextField.setBounds(385, 70, 196, 28);
						}
						{
							teTextField = new JTextField();
							tesPanel2.add(teTextField);
							teTextField.setBounds(126, 14, 140, 28);
						}
						{
							subidTextField = new JTextField();
							tesPanel2.add(subidTextField);
							subidTextField.setBounds(385, 14, 196, 28);
						}
						{
							adTextField = new JTextField();
							tesPanel2.add(adTextField);
							adTextField.setBounds(126, 70, 140, 28);
						}
					}
				}
			}
			pack();
			this.setSize(631, 452);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	//返回
	private void okButtonActionPerformed(ActionEvent evt) {
	    StudentManagerFrame tes=new StudentManagerFrame();
	    this.setVisible(false);
	    tes.setVisible(true);
	}
	//添加
	private void tesAddButtonActionPerformed(ActionEvent evt) {
		TesAddFrame tesA=new TesAddFrame(tesTable,page);
		tesA.setVisible(true);
	}
	//修改
	private void tesUpdteButtonActionPerformed(ActionEvent evt) {
		if(row==0||tesTable.getValueAt(row, 0).equals("")){
			JOptionPane.showMessageDialog(this,"请先选择要修改的记录");	
		}
		else{
		    if(tesTable.getValueAt(row, 1)==null)
		    	tesTable.setValueAt(" ",row,1);
		    if(tesTable.getValueAt(row, 2)==null)
		    	tesTable.setValueAt("                ", row, 2);//十二位
		    if(tesTable.getValueAt(row, 3)==null)
		    	tesTable.setValueAt(" ", row, 3);
		    if(tesTable.getValueAt(row, 4)==null)
		    	tesTable.setValueAt(" ", row, 4);
			 TesUpdateFrame tesU=new TesUpdateFrame(tesTable,row,page);
			 tesU.setVisible(true);
		 }
	}
	//删除
	private void tesDelButtonActionPerformed(ActionEvent evt) {
		if(row==0||tesTable.getValueAt(row, 0).equals("")){
			JOptionPane.showMessageDialog(this,"请先选择要删除的记录");	
		}
		else{
			int control=JOptionPane.showConfirmDialog(this, "真的要删除吗？","警告！",JOptionPane.OK_OPTION);
			if(JOptionPane.OK_OPTION==control){
			String tesid=(String)tesTable.getValueAt(row,0);
			ta.delete(tesid);
			ta.init(tesTable,1,5);
			}
		}
		
	}
	
	private void tesTableMouseClicked(MouseEvent evt) {
		row=tesTable.getSelectedRow();
	}
	
	private void tesTableMouseEntered(MouseEvent evt) {
	}
	
	private void tesTableMouseExited(MouseEvent evt) {
	}
	
	private void tesTableMousePressed(MouseEvent evt) {
	}
	
	private void tesTableMouseReleased(MouseEvent evt) {
	}
	
	//首页
	private void firstButtonActionPerformed(ActionEvent evt) {
		if(this.page==1) JOptionPane.showMessageDialog(this,"本页为首页!");
		else {
			this.page=1;
			if(this.selectflag==false)
			     ta.init(tesTable,page,5);
			else {
				String tesid=teTextField.getText();
				String subid=subidTextField.getText();
				String time1=tesDateComboBox.getSelectedItem().toString();
				String time2=tesDate2ComboBox.getSelectedItem().toString();
				String address=adTextField.getText();
				String tea=teaTextField.getText();
				ta.tesSelect(tesTable, page, tesid, subid, time1, time2, address, tea);
			}
		}
	}
	//上一页
	private void lastButtonActionPerformed(ActionEvent evt) {
		if(this.page==1)
			JOptionPane.showMessageDialog(this,"本页为首页，没有上一页！");
		else {
			if(this.selectflag==false)
				ta.init(tesTable,--this.page,5);
			else{
				String tesid=teTextField.getText();
				String subid=subidTextField.getText();
				String time1=tesDateComboBox.getSelectedItem().toString();
				String time2=tesDate2ComboBox.getSelectedItem().toString();
				String address=adTextField.getText();
				String tea=teaTextField.getText();
				ta.tesSelect(tesTable,--this.page, tesid, subid, time1, time2, address, tea);
			}
		}
	}
	//下一页
	private void nextButtonActionPerformed(ActionEvent evt) {
		int temPage;
		String tesid=teTextField.getText();
		String subid=subidTextField.getText();
		String time1=tesDateComboBox.getSelectedItem().toString();
		String time2=tesDate2ComboBox.getSelectedItem().toString();
		String address=adTextField.getText();
		String tea=teaTextField.getText();
		if(this.selectflag==false)
			temPage=ta.pageCount();
		else
			temPage=ta.pageCountSelect(tesid, subid, time1, time2, address, tea);
		if(this.page==temPage)
			JOptionPane.showMessageDialog(this,"本页为尾页，没有下一页！");
		else {
			if(this.selectflag==false)
				ta.init(tesTable,++this.page,5);
			else{
				ta.tesSelect(tesTable,++this.page, tesid, subid, time1, time2, address, tea);
			}
		}
	}
    //尾页
	private void finalButtonActionPerformed(ActionEvent evt) {
		int temPage;
		String tesid=teTextField.getText();
		String subid=subidTextField.getText();
		String time1=tesDateComboBox.getSelectedItem().toString();
		String time2=tesDate2ComboBox.getSelectedItem().toString();
		String address=adTextField.getText();
		String tea=teaTextField.getText();
		if(this.selectflag==false)
			temPage=ta.pageCount();
		else
			temPage=ta.pageCountSelect(tesid, subid, time1, time2, address, tea);
		if(this.page==temPage) JOptionPane.showMessageDialog(this,"本页为尾页！");
		else {
			this.page=temPage;
			if(this.selectflag==false)
				ta.init(tesTable,page,5);
			else
				ta.tesSelect(tesTable, page, tesid, subid, time1, time2, address, tea);
		}	
	}
//条件查询
	private void selectButtonActionPerformed(ActionEvent evt) {
		String tesid=teTextField.getText();
		String subid=subidTextField.getText();
		String time1=tesDateComboBox.getSelectedItem().toString();
		String time2=tesDate2ComboBox.getSelectedItem().toString();
		String address=adTextField.getText();
		String tea=teaTextField.getText();
		if(tesid.indexOf("'")!=-1||tesid.indexOf("_")!=-1||tesid.indexOf("?")!=-1||tesid.indexOf("%")!=-1||
				subid.indexOf("'")!=-1||subid.indexOf("_")!=-1||subid.indexOf("?")!=-1||subid.indexOf("%")!=-1||
				address.indexOf("'")!=-1||address.indexOf("_")!=-1||address.indexOf("?")!=-1||address.indexOf("%")!=-1||
				tea.indexOf("'")!=-1||tea.indexOf("_")!=-1||tea.indexOf("?")!=-1||tea.indexOf("%")!=-1)
			JOptionPane.showMessageDialog(this, "找不到要查询的结果！");
		else{
		     ta.tesSelect(tesTable,1,tesid,subid,time1,time2,address,tea);	
		     this.selectflag=true;
		     this.page=1;
		}
	}

}